We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Refresh the pivot tab and save corrupts the output file

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

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.

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