Out of memory error for pivot table creation

Aspose.Cells Product Family
1

Hi Team,

we are getting out of memory error for pivot table creation.

issue with the no of page fields.

if i add less number of page fields then no issue.

please find the source , csv and output file.

Thanks
kumar.

2

Hi,

Thanks for your code example and sample files.

I was able to replicate it using the latest version:
Aspose.Cells
for Java v7.0.4.5

We have logged this issue in our database. We will look into it and fix the problems and update you asap.

This issue has been logged as CELLSJAVA-40103.

3

Hi,

We suggest you to add this code:

C#


pivotTable.setAutoFormatType(PivotTableAutoFormatType.REPORT_1);

pivotTable.setRefreshDataFlag(true);//add this code

and,

in your code,the name of the row field is "Organization Name" but not "Organization Nameg"

pivotTable.addFieldToArea(PivotFieldType.ROW,"Organization Nameg");

4

Hi Team,

Thanks, working fine now.

Thanks,
kumar