Description: If an existing sheet is opened and the only action during that session is to MENU>VIEW>CHECK or UNCHECK [ViewHeaders] then there is no suggestion to save the changes. Reopening the sheet presents the headers as if the action had never been taken. It may be related to bug137717 which also fails to save the status of an inserted QR Code in a new - previously BLANK sheet I think it's a bug but the "big boys" may think I'm just being pedantic - and will undoubtedly set the appropriate status :). Steps to Reproduce: Open any existing sheet Make no changes apart from changing the status of MENU>VIEW> [ViewHeaders] Exit the sheet with the [X] button @ top right corner Actual Results: No option to save the status - probably because there has been no defined activity in any cell Expected Results: Perhaps a prompt to save the current sheet or a notification that whilst the status hasn't changed the configuration has - would you like to save? Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.7.2 (x64) / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
I can confirm with Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 14844d835cc5d6dfde499a0b1074aea5dcff4fc7 CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
For the record Excel conceals them when hiding the headers but then again, the Americans also put an ashtray on a Harley Davidson but you'd never find one on a MTT 420-RR. It's a bit like supergluing the Capewell release on your parachute
IOW, the setting of: Menu View > View Headers is not being saved to the file (at all, whether with or without other changes). Actually, it is not being even considered at all: * there is no sign that the document has been modified (e.g. the "save" icon has no red dot...) * the setting is not preserved when starting a new empty document (which is perfectly fine; no need to change this). I would suggest simplifying the subject/title of this bug report; for example: View Headers setting is not saved to file
(In reply to ady from comment #3) > > I would suggest simplifying the subject/title of this bug report; for > example: > View Headers setting is not saved to file Is this for me to action or a suggestion for somebody higher up in the food chain?
(In reply to Colin from comment #4) > (In reply to ady from comment #3) > > > > > I would suggest simplifying the subject/title of this bug report; for > > example: > > View Headers setting is not saved to file > > Is this for me to action or a suggestion for somebody higher up in the food > chain? I was asking to confirm what I reported in comment 3 and, if adequate, then modify the title subject of the report. Currently, the subject says: "CALC Hiding Headers action is not saved if no other changes have been effected" In my tests, what I see is that "other changes" have no relevance. Let me put it this way... Initially, the report seems to request that when the spreadsheet is saved and the only next action is "View Headers", then there is no "flag" to remind the user to save the file (again) before closing it (e.g. no warning/info message at closing time). In my tests, I find that none of those points are really relevant in the current state of things: the "View Headers" setting is not being saved to the file, whichever other variant of steps or factors you would take. (Note: I have not tested with xls(x) files nor other than ods.) And so, if others would re-test and confirm what I reported in comment 3, then I would suggest converting this report into a slightly different one (with a more-important problem than originally-reported): "View Headers setting is not saved to file"
The Summary has been changed to comply with suggestions but I must reiterate:- If a new sheet has anything typed into any cell and the View Headers setting is amended then exiting the file prompts "save" and the header status is somehow retained. If the file is reloaded and the View headers setting is the only amendment during that session then exiting the file does not prompt a save and the new header status is not retained. If the file is reloaded and the view headers setting is the only amendment during that session and the user forces a save with [Ctrl]+S and then exits the file then upon reloading that file the header status at the time of the save is retained when the file is reopened. If it's not being saved somewhere then I think LO has probably created the first publicly available quantum computer program or I've stumbled/bungled my way into a quantum Calc🤣
(In reply to Colin from comment #6) > If a new sheet has anything typed into any cell and the View Headers setting > is amended then exiting the file prompts "save" and the header status is > somehow retained. > If the file is reloaded and the view headers setting is the only amendment > during that session and the user forces a save with [Ctrl]+S and then exits > the file then upon reloading that file the header status at the time of the > save is retained when the file is reopened. I cannot repro any of those 2 behaviors using: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: cf8f7b91f41821b79495c0388359c4cb1156ea67 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded I reiterate: whenever I set the status of the "View Headers" setting to OFF, no matter what other steps or changes I make (either before or after changing the View Headers status to OFF), the row/column Headers will be displayed on screen when I save and reload the file. Therefore, I claim that the View Headers setting is not saved to the file (or it is always saved as ON). Please confirm this. If the behavior is different for you, then we have 2 different bugs, maybe depending on version or on some other factor.
(In reply to ady from comment #7) > (In reply to Colin from comment #6) > > > If a new sheet has anything typed into any cell and the View Headers setting > > is amended then exiting the file prompts "save" and the header status is > > somehow retained. > > > If the file is reloaded and the view headers setting is the only amendment > > during that session and the user forces a save with [Ctrl]+S and then exits > > the file then upon reloading that file the header status at the time of the > > save is retained when the file is reopened. > > I cannot repro any of those 2 behaviors using: > Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community > Build ID: cf8f7b91f41821b79495c0388359c4cb1156ea67 > CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: > win > Locale: en-US (es_AR); UI: en-US > Calc: CL threaded > > I reiterate: whenever I set the status of the "View Headers" setting to OFF, > no matter what other steps or changes I make (either before or after > changing the View Headers status to OFF), the row/column Headers will be > displayed on screen when I save and reload the file. Therefore, I claim that > the View Headers setting is not saved to the file (or it is always saved as > ON). > > Please confirm this. If the behavior is different for you, then we have 2 > different bugs, maybe depending on version or on some other factor. Now tersted with: Version: 7.3.1.3 (x86) / LibreOffice Community Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL And indeed the status of the View Headers setting _is_ saved. Crap, we have 2 bugs, with the new one being worse (and somewhat "including" or closely related) to the initially reported here.
(In reply to ady from comment #8) > (In reply to ady from comment #7) > > (In reply to Colin from comment #6) > > > And indeed the status of the View Headers setting _is_ saved. Crap, we have > 2 bugs, with the new one being worse (and somewhat "including" or closely > related) to the initially reported here. Is it feasible that your experience could be related to the user profile if the status is a component of the user profile and that mine is a fairly simple bug that LO just fails to recognise a saveable amendment if there has been no processing change? I understand the processing is optimised to affect only amended cells and of course I didn't amend any values so CALC thinks "No Change - No Action"
LO 7.5 is also saving the status of the View Headers setting in the file. I have not tested 7.6. The initial behavior reported in comment 0 is still seen in 7.5 up to current Dev 24.2 built as of today 2023-07-27. Dev version 24.2 built as of today 2023-07-27 is not saving the status of the View Headers setting at all, not even in Safe Mode. I have not tested 7.6.
(In reply to ady from comment #8) > And indeed the status of the View Headers setting _is_ saved. Crap, we have > 2 bugs, with the new one being worse (and somewhat "including" or closely > related) to the initially reported here. That's now bug 156501. I'll change the subject title of this bug 153295 back to its original.
Further experimentation has dictated yet another change to the subject heading and a more reliable subject definition. It is not simply the hiding and exposing action that is ignored. If the user browses around their file, examining different sheets, possibly selecting multiple cells to view the analytics on the bottom ribbon or many other UI presentation changes - in the View menu - but makes no changes that require a recalculation then no "save" is prompted upon exit. It is not occurring with all "toggles" in the View menu. As originally identified; View headers toggle does not trigger a save, nor does it present the change upon reloading the file Whereas View>Toolbars>Form Design also does not trigger a save but the change is presented upon reloading the file alternatively View>View Gridlines -does- trigger a file save and of course the change is presented upon reloading the file I'm unsure whether the elements in the View Menu can be assigned by the user as part of their UI setup or whether it is fixed "at source". Is there any value to the project if I systematically test everything in MY View menu and produce a calc defining the save prompt and file reload condition? Please make my day - and advise me there's already something extant defining the response "triggers" for all UI amendments and they just reuire rationalising.
(In reply to Colin from comment #12) > View>Toolbars>Form Design also does not trigger a save but the change is > presented upon reloading the file I think the specific toolbars (that are displayed on your screen) are not saved to the file, ever. The toolbars are part of your user preferences, not part of the ods file. > alternatively > View>View Gridlines -does- trigger a file save and of course the change is > presented upon reloading the file I think that's expected. The status of Grid lines and row/column headers are supposed to be saved in each file. Each report should be focused on one problem only. I would suggest not cluttering the report with unrelated matters. If the issue involves more than just View Headers, developers will eventually find out. For questions that are not (for certain) known to be related to this report, I would suggest using ask.libreoffice.org .
I suspect this is related Bug 137717
(In reply to Colin from comment #14) > I suspect this is related Bug 137717 Already mentioned in comment 0. And no, the QR code feature is much newer than the problem reported in this bug 153295. BTW, changing the version field to inherited.