PivotField unique items more than 33k

Aspose.Cells Product Family
1

Hi,


I am using aspose cells 2.5.4 and I am getting an error when generating a pivot table with more than 33K unique items. What is the maximum PivotField unique items? I get the following error message:
com.aspose.cells.CellsException: This pivot field has more unique items than can be used in a pivot table.

cheers




2

Hi,

Thanks for your posting and using Aspose.Cells for Java.

Please download and use the latest version:

Aspose.Cells for Java 7.2.2 It should solve this problem.

Once, you have downloaded it, please update aspose.cells jar file with the latest version:
Aspose.Cells
for Java v7.2.2.1

If the problem still occurs, please provide us your sample code and source xls/xlsx file replicating this problem.

We will look into it and help you asap.

3

Thanks for your reply.


I have upgraded to the latest version of Aspose Cells. Unfortunately, I am still getting that same error. Attached is the sample source and excel file.
4

Hi,

Thanks for your posting and using Aspose.Cells for Java.

I found if you remove the following line, exception does not occur.

///pivotTable.addFieldToArea(PivotFieldType.ROW, 1);

However, we will look into this issue and see how to fix it.

If it is a bug, we will fix it and let you know asap.

5

Hi,


Yes, it will work because PivotField ‘Name’ has only 1 unique item. whereas, ‘Name2’ has 35k+ unique items.

Please help take a look.

thanks
6

Hi,

Thanks for your feedback.

I have logged this issue in our database with the id: CELLSJAVA-40235

We will look into it and fix the bug and update you asap.

7

Hi,


I saw that it was also a bug in .Net before. https://blog.aspose.com/2008/12/27/aspose-total-for-net-q4-2008
8

Hi,

Thanks for your posting.

You are right. Seems like this bug reappeared with your source file.

Hopefully, it will be fixed soon.

9

Any updates on this one? Can you give me the version that has the fix?(if it has been fixed before).


Thanks.
10

Hi,

Thanks for your posting and using Aspose.Cells for Java.

Please wait for 2~3 working days.

I have logged your comments against the issue id: CELLSJAVA-40235

I hope your issue will be fixed soon and we will update you here.

Also, you can try some of the archived versions from this link.
http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx

11

Hi,

We have fixed this issue.

Please download and try this fix: Aspose.Cells for Java v7.2.2.6

12

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

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