Description: When a file had no changes and thus it is not flagged as changed (The Save Icon is not indicating a necessary save) and then a existing "Freeze Rows and Columns" option is removed, the file is NOT being flagged as changed. The Save Icon is not changing status, nor is a Save dialogue triggered when the file is closed, the change is just being lost when closing the file. Steps to Reproduce: 1. Open new spreadsheet 2. Go to B2 and select "Views > Freeze Rows and Columns" 3. Save file 4. Select "Views > Freeze Rows and Columns" again, so to remove it. The Save Icon does not change! 5. Close file. The save dialogue is not coming up 6. Open the file 7. Realize that the "Freeze Rows and Columns" in B2 is back again Actual Results: The step to remove "Views > Freeze Rows and Columns" is not saved and lost Expected Results: "Views > Freeze Rows and Columns" removal to flag the file as changed Reproducible: Always User Profile Reset: No Additional Info: 1. This bug is not new and exists at least a couple of years by now, in various versions of Calc. 2. In the case that you enforce a save, although the Save Icon is not indicating changes that need to be saved, the change is saved to the file!
Repro with Version: 7.0.0.0.alpha0+ (x64) Build ID: 4501a0ba623ad61c5a4e0b807da2e96f0e4ce82c CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win; Locale: nl-NL (nl_NL); UI-Language: en-US Calc: CL and with Versie: 4.4.7.2 Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600 Locale: nl_NL and with LibreOffice 3.5.7.2 Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b
I just noticed that a similar problem exists with adding and removing "View > Split Window". Neither adding, no removing will flag the file changed. Since I assume that this is very related to the "Freeze Rows and Columns" bug, I did not file a new bug, but added it here.
Although bug 61060 added modification on freezing, it didn't do it for unfreezing. Proposed fix at http://gerrit.libreoffice.org/c/core/+/140932 I checked how Excel handles these, but it doesn't mark the document as changed in 2003 or 2010 for either freezing or splitting. I realize that this is a saved setting in the document, but it is also a viewing thing. So a person reviewing a document might desire to temporarily view as a split but not intend to save. I would tend to leave it as it is, since one would RARELY change only the split and nothing else. Plus, you learn really quickly that you do need to save if it is part of your workflow to only adding splitting to a document. Best policy is leave things as they are without a clearly correct way to do it. So I WONTFIX, but the code pointers are all there for anyone who wants to do it.