https://bugs.documentfoundation.org/show_bug.cgi?id=167749
Bug ID: 167749
Summary: Freeze state is randomly, infrequently, lost
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a spreadsheet. It contains about 40 tabs, nearly all are created from a
macro that builds a template sheet, and as part of the creation process applies
a "freeze cells" state to rows 1 - 19 inclusive.
Occasionally, it is infrequent but has happened enough times that I'm here
reporting it as a bug, the freeze state of one of the code-created sheets is
just... gone/removed/lost.
I do not have a reproducible test case.
The state is easily re-applied manually, so there is a workaround: [ select row
20 -> View -> Freeze Rows and Columns ]
I checked just now, there is no keychord registered for "Freeze Rows and
Columns" in [ Tools -> Customize -> Keyboard ] so I don't think I'm
accidentally hitting a key combo and not realizing it.
[ Alt V -> e ] is very difficult to hit on purpose, so I am certain I am not
hitting it accidentally.
Except for repairing affected sheets, I _never_ touch the freeze cells function
manually. All freeze states are created via macro code, and are never touched
after.
This bug ( https://bugs.documentfoundation.org/show_bug.cgi?id=130319 ) seems
related in that there is a mechanism for LibreOffice Calc to remove the freeze
state without the user's direct action or consent.
However, I never use the zoom functionality in my spreadsheet, so it's not the
same bug ALTHOUGH it's possible the same underlying mechanism may be at fault
there and here.
I am a programmer so happy to assist with any debugging that could be done;
turning on logging for example.
I have seen this for a while; at least one, probably several years; but I can't
confirm a date of first encounter because I'm certain I rationalized it away as
something I had done, or a macro malfunction and then forgot about it.
Seen just now, hence the report.
I have a hunch that the sheet that loses its freeze state is the sheet that is
active at [ last save / first open ].
I have not tried resetting my user profile due to not having a reproducible
test case.
Seen on:
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 16; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-US (C.UTF-8); UI: en-US
Ubuntu package version: 4:25.2.5~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded
Steps to Reproduce:
No reproduction at this time.
Actual Results:
No reproduction at this time.
Expected Results:
No reproduction at this time.
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
Linux Mint 22.1 x86_64
Kernel: Linux 6.11.0-26-generic
--
You are receiving this mail because:
You are the assignee for the bug.
