Description: "Freeze Row" is intended to show a title row as user scrolls through spreadsheet. However, choosing this option does not achieve this result. In fact, it seems to do nothing. Steps to Reproduce: 1. Select a row 2. right-click, click "freeze row" 3. Scroll Actual Results: Frozen title roll should remain visible while rest of data scrolls. Expected Results: Frozen title row disappears. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Mac OS X (All) OS is 64bit: no
As explained in respective help [1], and as it works in other spreadsheet software, too [2], this feature freezes the row(s)/column(s) that are *to the top* and *to the left* of the cursor, not the ones where the cursor is. You select the first cell that must *scroll*. This likely allowed to use the same command to "unfreeze", simply selecting A1, and using this command; since there was nothing to the top and left, the freeze was removed. No matter why, this is now the established way how the industry does it. NOTABUG. [1] https://help.libreoffice.org/latest/en-US/text/scalc/guide/line_fix.html?&DbPAR=CALC [2] https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f