Bug 64571 - Freeze Panes now cause Excel to repair the file.
Summary: Freeze Panes now cause Excel to repair the file.
Status: NEW
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-07-01 12:55 UTC (History)
0 users


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