Bug 62575 - XSSFWorkbook containing XSSFPivotTable is corrupt if workbook-data was written by SXSSFWorkbook
Summary: XSSFWorkbook containing XSSFPivotTable is corrupt if workbook-data was writte...
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: 3.17-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2018-07-27 11:09 UTC by torsten
Modified: 2019-06-20 08:41 UTC (History)
0 users

Example class to reproduce the bug. (6.28 KB, text/x-csrc)
2018-07-27 11:09 UTC, torsten

Note You need to log in before you can comment on or make changes to this bug.
Description torsten 2018-07-27 11:09:53 UTC
Created attachment 36052 [details]
Example class to reproduce the bug.

If a workbook is created as SXSSFWorkbook and than (re)read as XSSFWorkbook a XSSFPivotTable can be created. But if the xlsx file is opened, excel complains about removed/repaired features.
Comment 1 PJ Fanning 2018-07-27 11:19:38 UTC
Could you add the stacktrace?
Comment 2 torsten 2018-07-27 11:41:57 UTC
There is no stacktrace. The workbook is updated without any message / failure.

The problem is visible if the workbook is opened in excel (and probably in open office) only.
Comment 3 Dominik Stadler 2018-12-27 09:27:52 UTC
I could not reproduce this with POI 4.0.1 and LibreOffice any more, can you recheck with the latest release and report if it was fixed in the meantime?
Comment 4 Dominik Stadler 2019-06-20 08:41:46 UTC
Could not reproduce the reported problem and no answer for a long time, thus I am closing this for now, please reopen with more information if this is still a problem for you.