Similar to Issue 18934 we have 2003 XLS files with PivotTables that, if opened and closed with Aspose.Cells 5.1.2, the PivotTables are corrupted. An example is attached.
After an initial test, I can find the issue as you have mentioned. I have logged your issue into our issue tracking system with an issue id: CELLSNET-19430.
We will figure it out soon.
Actually that still doesn’t fix the issue if we have date grouping on a pivot field?!?
We are in process of fixed the issue. We will be able to provide the fix in next week.
Thank you for your patience.
Please use the updated version of Aspose.Cells.dll v18.104.22.168 attached. The issue has been fixed.
XLS files are fine now - BUT this now causes Issue 18934 to reoccur - we can’t open/save the file when it’s in 2007 XLSX format.
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable4.xml part (PivotTable view)Removed Feature: PivotTable report from /xl/pivotTables/pivotTable5.xml part (PivotTable view)Removed Feature: PivotTable report from /xl/pivotTables/pivotTable6.xml part (PivotTable view)Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)
Hi can you acknowledge there’s still an issue?
We acknowledge the issue. We are able to reproduce the issue by following the way you had specified. We apologize for your hassle. We are working on the issue. We will update you as soon as it is fixed.
Please try the attached version. We have fixed your mentioned issue.