Bug 159517 - option to unfreeze rows or column is missing from Calc
Summary: option to unfreeze rows or column is missing from Calc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.4.1 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-02-02 05:22 UTC by mazaltov
Modified: 2024-02-02 06:05 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description mazaltov 2024-02-02 05:22:42 UTC
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
Comment 1 Mike Kaganski 2024-02-02 05:58:44 UTC
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.
Comment 2 Mike Kaganski 2024-02-02 06:05:52 UTC
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.