Refresh the pivot tab and save corrupts the output file

Aspose.Cells Product Family
1

Hi,

When I refresh the pivot tab and save to the output file. My output file is getting corrupted. I am writing in Java as below :
Workbook wb = new Workbook(“template.xlsx”);
wb.calculateFormula();
PivotTable pt = wb.getWorksheets().get(1).getPivotTables().get(0);
pt.refreshData();
pt.calculateData();
wb.save(“output.xlsx”);
Attached is the template and output files .

Thanks,
Sowmya
2

Hi Sowmya,


Thank you for contacting Aspose support.

We are able to replicate the said issue while using the latest revision of the Aspose.Cells for Java 8.8.0 therefore we have raised this incident as CELLSJAVA-41821. Please spare us little time to properly look in to said issue and get back with updates in this regard.

We are sorry for the inconvenience caused to you.
3

@sowmyashree.p,
The issue is fixed in v21.6.2.
aspose-cells-21.6.2-java.zip (7.3 MB)