I can't make poi work for creating xlsx file with freeze pane starting not in cell (0,0). consider this raw excel:
[image: image.png] I want to freeze it using POI to look like this: [image: image.png] Meaning: freezing 10 rows and 5 column. but top left freeze pane should be cell (9,5) cell A10. I tried to apply it with the 2 overloads of xssfSheet.createFreezePane - none seem to work. either I get the correct freeze pane size but starting from A1 or I get an error in the excel file meaning it wasn't saved properly.
