Bug 64571 - Freeze Panes now cause Excel to repair the file.
Summary: Freeze Panes now cause Excel to repair the file.
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC Mac OS X 10.1
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2020-07-01 12:55 UTC by Neal
Modified: 2020-09-25 15:23 UTC (History)
0 users

office 2019 need repair (7.29 KB, image/png)
2020-09-24 08:46 UTC, zili.peng

Note You need to log in before you can comment on or make changes to this bug.
Description Neal 2020-07-01 12:55:15 UTC

Upgraded to POI-4.1.2 and it appears that xssfSheet.createFreezePane(...) no longer produces .xlsx files that can be read by MSExcel (Office 365 current version 16.35) without first being "Repaired" by Excel. The repairing appears to remove the freeze panes. Commenting out the xssfSheet.createFreezePane() method calls allows the generated xlsx file to become properly readable by Excel, but obviously without any freeze panes. All help very gratefully received.

The application I have has been successfully using freeze panes on complex multi sheet workbook generator for 8 years with no problems, so it does appear to be a problem associated with the recent upgrade. The previous version I used for the application was POI-3.17.

I tested the problem on a workbook containing a pair of cells containing text and it still occurred when for the split pane was created, so confident it is not the complexity of my main application.

Kind regards,
Neal Snooke
Comment 1 zili.peng 2020-09-24 08:26:09 UTC
I also have the same problem. It's OK with office 2010, but has some problem with higher office version.

POI 3.17
office 2010 OK
office 2016 Need Repair
office 2019 Need Repair
Comment 2 zili.peng 2020-09-24 08:46:13 UTC
Created attachment 37467 [details]
office 2019 need repair

when open the createFreezePane xlsx file, office alert this window.
Comment 3 Dominik Stadler 2020-09-25 15:23:32 UTC
Can you create a small code sample which reproduces this problem for you?