Bug 58294

Summary: Pivot Table corrupted when saving an xlsx workbook
Product: POI Reporter: Amit <thatisamit>
Component: XSSFAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal CC: thatisamit
Priority: P2    
Version: 3.12-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
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.