No data in pivot table with just rows or columns

Aspose.Cells Product Family
1

Recently I received a fixed version of Aspose.Cells.GridWeb.dll:


File Version: 20.0.3.2001
Product Version: 2010.01.06

In this version a performance problem generating pivot tables was fixed, however apparently a new bug has been introduced:

When a pivot table is generated from a source datatable and just row fields are defined (no column fields) then no data is shown in the output.

When column fields are defined (but no row fields) then no data is shown in the output.

Previous version (20.0.3.2000 / 2009.12.29) works fine with this.

I have tried to fix it by setting a new GridWeb.Data.PivotField property called Subtotals, but nothing changes.

Any help about this will be appreciated.


2

Hi,

Could you create a simple project and post us here to show the issue you have mentioned. We will check it soon.

Thank you.

3

Attached is the sample application requested.

Te default page has three buttons:

Columns and Rows: Create a Pivot table with rows and columns, it works fine

Columns only: Create a Pivot table with columns only. It doesn't work.

Rows only: Create a pivot table with rows only: Shows row headers but no data.

NOTE: The program must be closed and opened again for each test.

Thanks for your help.

4

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id CELLSNET-14327.

Thank you & Best Regards,

5

When is going to be available a fixed version of aspose.cells.

I really need this very soon.

In the mean time, it si possible to use two diferent versions of aspose.cells at the same time, and generate a pivot table using one or the other depending of some conditions?

It could be diferent pages, then we could use diferent versions of the control on each page.

Thanks.

6

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We will update you regarding the progress of your issue next week as our development team is on leave this week due to Spring Festival.

Also, it is not possible to use two different versions of Aspose.Cells in the same project as the compiler will not be able to decide which version’s namespaces / classes to be used.

Thank you for understanding,

7

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We have fixed the issue regarding not able to generate Pivot table for only row fields or column fields. Please try the attached version and modify your code as per the attached sample code.

Thank You & Best Regards,

8

The issues you have found earlier (filed as 14327) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.