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
I also have the same problem. It's OK with office 2010, but has some problem with higher office version. enviroment: POI 3.17 office 2010 OK office 2016 Need Repair office 2019 Need Repair
Created attachment 37467 [details] office 2019 need repair when open the createFreezePane xlsx file, office alert this window.
Can you create a small code sample which reproduces this problem for you?