Bug 59823

Summary:	LibreOffice Calc UI: Window > Freeze Is Broken
Product:	LibreOffice	Reporter:	C A J <caj-bugz>
Component:	LibreOffice	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	pavel.zahradnik
Priority:	medium
Version:	4.0.2.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Spreadsheet saved with Freeze active at cell B5. Uncheck Split to restore row/column headers. Similar spreadsheet saved as .xls, showing correct behavior of Freeze.

Description C A J 2013-01-24 21:14:50 UTC

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.

Comment 1 C A J 2013-01-24 21:17:22 UTC

Created attachment 73615 [details]
Spreadsheet saved with Freeze active at cell B5. Uncheck Split to restore row/column headers.

Comment 2 C A J 2013-01-25 21:07:31 UTC

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.

Comment 3 C A J 2013-01-25 21:17:23 UTC

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.

Comment 4 C A J 2013-03-26 14:02:02 UTC

Any action on this? Thx.

Comment 5 pavelz 2013-04-22 18:35:12 UTC

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).

Comment 6 ign_christian 2013-05-09 09:40:34 UTC


*** This bug has been marked as a duplicate of bug 57324 ***