[Libreoffice-ux-advise] [Bug 102939] freeze cells function not operating properly with multiple sheets selected

https://bugs.documentfoundation.org/show_bug.cgi?id=102939

--- Comment #3 from Timur <gtimur@gmail.com> ---
Being an average user, I'll just add some thoughts:

(In reply to Ray Schmitz from comment #0)
> The user-expected behavior when operating on multiple selected sheets that
> is consistent with other functionality would be for the exact same number of
> rows and/or columns to be frozen on every selected sheet.  
A. May make sense, IF other issues are also tackled (warning, no text change,
grey out icon). There should be Yes-No warning that this will change existing
freezes, if any. As a note, MSO 2013 doesn't support this either and it would
be useful to know if some suite does.

> Choosing to freezing only first row of a selected group of sheets should not
> alter the status of frozen columns in any of the selected sheets. Similarly,
> freezing only the first column of a selected group of sheets should not
> change any existing frozen rows settings within any of the selected sheets.  
B. This is contrary to the current singe sheet logic and previous paragraph and
probably complicates all and should not be accepted.

> Even for a single selected sheet, after freezing the first row, choosing
> freeze first column undoes the frozen first row first without freezing
> column A. A second application of freeze first column then gives the
> desired effect.  The same is true if rows and columns are swapped.  
C. Looks like already reported Bug 99477.

> Also, successive application of freeze first row (column) will turn toggle
> the freezing of the row (or column) on and off.  However, the menu text does
> not toggle back and forth between freeze and "unfreeze".  
D. May make sense for a new lowest enhancement bug, looking separately, but
looks contrary to A, so I wouldn't support both.

> Conceptually, only 1 pair of underlying functions are needed: freeze 0 to n
> rows (or 0 to n columns) on selected sheet(s).
> With this underlying logic, the existing wordy and cumbersome "freeze cells"
> submenu ("rows and columns | first row | first column") could be replaced
> with 2 lines: "freeze rows" and "freeze columns".
E. I find "first row" and "first column" handy and probably frequently used.
It's more important than a conception that all rows/columns are the same. 
Also, there's a single drop-down icon now which looks fine.

> The suggested menu text may count as a feature request, rather than a bug,
> but if UI and underlying function are intertwined, new text to go with the
> suggested new underlying feature logic (to resolve the bug) would improve
> usability through greater simplicity and clarity.  Most users do not want to
> "freeze cells" (in some arbitrary array?!?) - they want to freeze rows and
> columns.
F. Of course, and MSO users don't want to freeze panes, but rows and columns.
Personally, I don't find this relevant. It would be useful to search for the
bug/source where this was decided. Anyway, discussion may belong to Bug 97105.

> A possible interim fix would be to grey out "freeze cells" while more than one
> sheet is selected or otherwise warn the user that freeze is not working for
> multiple sheets.
G. No interim fixes please. If A. is confirmed, which what this bug is about,
there should be Yes-No warning. If not, another bug with Yes warning might be
created to warn the user that freeze is not working for multiple sheets. But
that is obvious and doesn't lead to any data loss, so of no importance.

> Listed as minor because the workaround is to adjust each sheet individually;
> this is a productivity issue with severity scaling linearly with the number
> of sheets the user might like to do freeze operations upon increases.
H. Looks like enhancement to me, but I won't change this one.

-- 
You are receiving this mail because:
You are on the CC list for the bug.