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?
Happened again while I was using the sheet. I was alt-tabbing around though, and the sheet was in the background (under other windows) for a while. This is still on 25.2.5.2 because the PPA hasn't updated with 25.8 yet.
Happened again. Spreadsheet has been open for at least 18 hours, overnight. I have a two monitor setup. I typically keep Calc open on the right-hand side. Linux Mint, or its desktop Cinnamon, has an issue where when the machine goes to sleep and is awakened, apps don't restore on the monitor they were on. For my PC, this means apps on the right-hand monitor are moved to the left-hand monitor, and I have to manually put them back to the right-hand monitor. So the freeze state was lost, and at the same, Calc was moved from right to left by the system. I don't know if those are related or not, but it's easy enough to test. Still on 25.2.5.2
Happened again. Still on 25.2.5.2
Happened again.
The "not on the same monitor it used to be on" bug doesn't seem to be a contributing factor. I've had the spreadsheet open for a couple of days, over several instances of Calc being moved to the other monitor, and the freeze state has been okay.
I've discovered a 100% reproducible test case: 1. Have a spreadsheet with a freeze state open on Linux Mint 22.1 with Cinnamon 6.4.8 2. Press ctrl-alt-esc to restart Cinnamon Observe the freeze state is lost. This is almost certainly where the "random" losses come from; Linux Mint is installed with System Settings -> General -> Memory limit -> Restart Cinnamon when it uses too much memory == Enabled
Oh weird. My main investment tracking spreadsheet always loses the freeze state. Another sheet I have open at the same time never loses its freeze state.