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
Just happened again. My usual spreadsheet has been open for a while. The tab with focus lost its freeze settings. Not sure when that happened. Is there an auto-save function that could be responsible?