https://bz.apache.org/bugzilla/show_bug.cgi?id=64571
Bug ID: 64571
Summary: Freeze Panes now cause Excel to repair the file.
Product: POI
Version: unspecified
Hardware: PC
OS: Mac OS X 10.1
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Hi,
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
--
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]
