https://bugs.documentfoundation.org/show_bug.cgi?id=102939
Bug ID: 102939
Summary: freeze cells function not operating consistently with
multiple sheets selected
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/53.0.2785.143 Safari/537.36
Build Identifier: 31dd62db80d4e60af04904455ec9c9219178d620
Unlike other functions (e.g., insert column; delete row) which can create the
same change in multiple selected sheets at once, freeze cells fails to perform
as expected when more than one sheet is selected.
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.
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.
However, selecting to freeze both rows and columns for multiple selected sheets
should override any previous number of rows and/or columns that may have
already been frozen in any of the selected sheets.
Reproducible: Always
Steps to Reproduce:
1. Create multiple sheets with dummy content (e.g., cells marked A1, A2,...An,
B1...Bn, C1...n, ....
2. optionally, set pattern of frozen rows and columns in individual sheets
3. Attempt to freeze first rows | first columns | rows & columns of sheets
4. Inspect results under changes.
Actual Results:
Freeze seems to operate as expected only on the visible sheet; not on the
multiple selected sheets.
Expected Results:
See problem description above.
Observations:
1)
Freeze first row and free first column functions are somehow conflicting. 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.
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".
Maybe this counts as another bug, separate from the failure to operate on
multiple sheets. However, the functionality is closely related as to suggest
there is one underlying routine that needs to be reworked.
So:
2)
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".
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.
3)
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.
4)
It is quite common to want to make changes to frozen rows or columns of
multiple sheets during both development and usage of complex models, and to
want to make changes on one axis without altering the existing settings on the
other axis.
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.
Reset User Profile?No
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
