Bug 58294 - Pivot Table corrupted when saving an xlsx workbook
Summary: Pivot Table corrupted when saving an xlsx workbook
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.12-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-08-28 07:37 UTC by Amit
Modified: 2017-07-10 02:32 UTC (History)
1 user (show)



Attachments
Code and generated file. test1.xlsx and test2.xlsx are original file without saving test1.xlsx form excel. (26.57 KB, application/zip)
2015-08-28 07:37 UTC, Amit
Details

Note You need to log in before you can comment on or make changes to this bug.
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.