https://bugs.documentfoundation.org/show_bug.cgi?id=159517
Bug ID: 159517
Summary: option to unfreeze rows or column is missing from Calc
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
