|Summary:||Pivot Table corrupted when saving an xlsx workbook|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
|Attachments:||Code and generated file. test1.xlsx and test2.xlsx are original file without saving test1.xlsx form excel.|
Description Amit 2015-08-28 07:37:51 UTC
Created attachment 33045 [details] Code and generated file. test1.xlsx and test2.xlsx are original file without saving test1.xlsx form excel. My Environment is windows and this is not tested on unix. I am generating a xlsx file using jasper report and save it to locally (test1.xlsx). This file is fine and open without error or crash. When i am trying trying to add the pivot table and saving it as new file test2.xlsx (Can also do in the same file but same result) the code works fine. But when i open test2.xlsx, this crashes with the following error in Excel. "Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache) Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view) Removed Records: Workbook properties from /xl/workbook.xml part (Workbook) Repaired Records: Cell information from /xl/worksheets/sheet2.xml part " Now if i Open the test1.xlsx and save it again without any modification and run my code again, the test2.xlsx file generates fine and opening properly. i am attaching test1.xlsx, test2.xlsx and my code for the reference.