Hi! We have a problem with PivotTable while we are trying to save the template file without any modifications made by Aspose.Cells API. We just do the “save as” and nothing more.
Pivot Table becomes inoperable in the result file (filters don’t work, no changes in field list can be made).
We attached the source file and the result.
And here’s a sample code to make the result from the source file
public class Test {
public static void main(String[] args) throws Exception {
License license = new License();
license.setLicense("Aspose.Cells.lic");
Workbook workbook = new
Workbook(Test.class.getResourceAsStream("example.xlsx"));
workbook.save("result.xlsx");
workbook.dispose();
}
}
We have evaluated the presented scenario while using the latest revision of Aspose.Cells for Java 8.8.0.2, and we are able to notice the said problem. In order to further investigate the matter, we have raised this incident with our product team by logging a ticket as CELLSJAVA-41829. Please spare us little time to properly analyze this case and revert back with updates in this regard.
I am afraid, the ticket attached to this thread (CELLSJAVA-41829) is currently unresolved. I have requested the concerned member of the product team to share the analysis results as well as the ETA for the fix. As soon as we get any news in this regard, we will post here for your kind reference.
Two files named “result.xlsx” and “example (1).xlsx” have the same manner when we open the files using MS-Excel. Please see the result pictures in the attachments. About the file size is changed, we think Aspose.Cells and MS-Excel have different compression ratio.
We are pleased to inform you that your issue (logged as “CELLSJAVA-41829”) has been resolved. The fix will be included in the upcoming release (Aspose.Cells v23.11) that we plan to release in the first half of November. You will be notified when new version is released.