https://bugs.documentfoundation.org/show_bug.cgi?id=112641
--- Comment #3 from Holger Klene <h.kl...@gmx.de> ---
I suppose this is a "feature" designed, to protect someone from opening their
spreadsheet on a low resolution beamer and being unable to scroll as the whole
screen is taken up by frozen cells. So dragging the window to a small
rectangle, until the frozen line touches the scrollbar will disable the
freeze-status for that axis.
This has multiple strange effects. You better not:
- unfold cells within the frozen range (as of this bug)
- drag toolbars around
- expand the properties sidebar
- paste text in a multiline-cell that automatically wraps
- toggle screen resolution to duplicate output to some ancient beamer
- resize the window, e.g. pressing <Windows>+<Left>
All those (and possibly more, I didn't think of) are triggers that reset
freeze-status. To top it off, the document does not get dirty by this
inadvertent change. But saving it due to other changes will persist the
unfrozen state.
On the other hand, manually freezing the cells again after such an incident
will make the document dirty and ask to save, if you try to close it.
I suggest making the freeze-state ternary:
a) disabled - nothing is frozen
b) enabled - cells are fixed
c) "temporary suspended" - the viewport is not big enough to show anything
other than the frozen rows / columns, so freezing them is obsolete, until
later, when the conditions change.
This status is to be tracked independently for both axis.
Please also have a look at: #99477
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
