Bug 153295

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.