With an old or new spreadsheet (.xls or .xlsx), pick a cell and select Window and Freeze. Lines appears above and to the left of the cell and any horizontal or vertical scrolling moves the viewport on the cells at, below, and to the right. This is the expected behavior of the Freeze feature. Now save the file and reopen it. Lettered column headers are missing; numbered row headers are garbled. Further, clicking Window drops down a menu with Split checked and Freeze not checked. (This ISN'T the expected behavior. <g>) Unchecking Split at this point retuend the row and column headers, but the Freeze feature is not active.
Created attachment 73615 [details] Spreadsheet saved with Freeze active at cell B5. Uncheck Split to restore row/column headers.
I said the problem applied to both .xls and .xlsx spreadsheets, but I've only tested it on the .xlsx side. I've had a problem (similar? same?) with .xls files, but they were largely inherited from my previous life as a Microsoft Excel user. Oddly, one of these older .xls files had one tab that worked fine with Freeze and two other tabs that showed the reported behavior, though the row/column headings were not mangled. I no longer have the file, having upgraded it (SaveAs) to .xlsx.
Created attachment 73660 [details] Similar spreadsheet saved as .xls, showing correct behavior of Freeze. I can't find the .xls spreadsheet that had one tab with Freeze working and two others where it didn't. Sorry.
Any action on this? Thx.
I can confirm this. It looks like that saving XLSX file with LO, the option Window - Freeze is incorrectly exported as Window - Split and thus when opening such XLSX file it behaves strangely, because it is imported as Window - Split. See also bug 63626 (points 2 and 3 in original bug report).
*** This bug has been marked as a duplicate of bug 57324 ***