Description: (i'm pretty sure that option was there few years ago) In calc it's possible to freeze certain part of the worksheet, so it remains always fixed on top (or on left). but now it's impossible to un-freeze it. I searched in Tools-> Customize-> All commands -- but it's nowhere to be found. If a use sets "freeze rows and columns" it seems they're stuck with this option. A WORKAROUND: select cell A1 go to View -> "Freeze rows and columns" again. This disables the freeze. The problem with this workaround, is that's a programmer's thinking. Regular users don't think about that option, because it is COUNTER INTUITIVE: using a "DO" command for "UN-DO" itself. Steps to Reproduce: 1. View -> "Freeze Cells" -> first first column (or first row, or both "Freeze rows and columns") 2. try to reverse the freeze... Actual Results: explained Expected Results: Either a menu item for UNFREEZE or a menu item with dual function, with a checkbox indicarting whether it's frozen or unfrozen. Reproducible: Always User Profile Reset: Yes Additional Info: 1. normal users don't think like programmers; they need to see an option to UNFREEZE, preferaly next to the option FREEZE. 2. In my environment, I had created a macro to unfreeze rows / columns, then I added this macro to the menu; Thanks god that someone created a "macro record" option, I wouldn't be able to come up with that solution on my own otherwise. sub unfreeze_rows_columns dim document as object dim dispatcher as object document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") dim args1(0) as new com.sun.star.beans.PropertyValue args1(0).Name = "Sel" args1(0).Value = false dispatcher.executeDispatch(document, ".uno:GoToStart", "", 0, args1()) dispatcher.executeDispatch(document, ".uno:FreezePanes", "", 0, Array()) end sub
The View->Freeze Rows and Columns is a *toggle*. When you have rows/columns frozen, the menu item will have its icon *highlighted*; if you put it to toolbar, the button will be *pressed*. When you click that pressed button / menu item, it unchecks. This is absolutely the same as e.g. for "Bold" font. This is not a bug.
FTR: in e.g. LibreOffice v. 3.3 till 5.0, it worked the same. The item was under Window/Freeze, and also was a toggle. In v.6.0, the same toggle entry was under View->Freeze Cells->Freeze Rows and Columns. In current versions, it was moved one level up for convenience. But in any case, it worked the same way throughout the history; just as any other toggle.