https://bz.apache.org/bugzilla/show_bug.cgi?id=58294
Bug ID: 58294
Summary: File crashes while opening XLSX after writing new
pivot table to the workBook.
Product: POI
Version: 3.12-FINAL
Hardware: PC
Status: NEW
Severity: critical
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 33045
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33045&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
