Bug 160615

Summary: Adding a warning message about the type of settings in Calc.
Product: LibreOffice Reporter: Amin Irgaliev <irgaliev01>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: heiko.tietze, miguelangelrv, vladislav.tarakanov
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=43786
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 113943    

Description Amin Irgaliev 2024-04-10 14:44:28 UTC 
Description:
The settings in Calc (Tools -> Options -> LibreOffice Calc) can be set for new files and for the current file separately. For example, some users got confused with the setting "Search criteria = and <> must apply to whole cells". If you open the LibreOffice Calc and remove the check mark from this setting, then in the new files ".ods" format this setting will be disabled. At the same time, you can enable this setting separately in any file and save it (then this setting will be enabled for the saved file and for new files created later). However, in order for the setting to be disabled again for new files after that, it must be disabled in LO Calc (not in file) again (in this case, this setting will be disabled in all new files, but enabled in previously saved ones).

Maybe it will be clearer to add some message in the settings that shows what the change in settings will affect:
1) If you open the file in Calc and go to the settings (Tools -> Options -> LibreOffice Calc), then there is logical message - "The settings will be applied to the current file and those created later."
2) If you open LibreOffice Calc and go to the same settings, then then there is logical message - "The settings will be applied to new files".

Actual Results:
1) Open LibreOffice Calc.
2) Go to Tools -> Options -> LibreOffice Calc -> Calculate.
3) Make sure that there is no message about the type of settings.

Expected Results:
First type:
1) Open LibreOffice Calc.
2) Go to Tools -> Options -> LibreOffice Calc -> Calculate.
3) Make sure that there is a message about the type of settings to save (for example, "The settings will be applied to the current file and those created later").

Second type:
1) Open the file .ods via LibreOffice Calc.
2) Go to Tools -> Options -> LibreOffice Calc -> Calculate.
3) Make sure that there is a message about the type of saving settings (for example, "The settings will be applied to new files").


Reproducible: Always


User Profile Reset: No

Additional Info:
Comment 1 m_a_riosv 2024-04-10 20:19:59 UTC 
I can't find it, but I think something was reported/discussed, about adding a tick to each option about whether it is per file or per user.
Comment 2 Roman Kuznetsov 2024-04-10 21:40:58 UTC 
I agree with the problem but I'm not sure in the solution. Set to NEW
Comment 3 Heiko Tietze 2024-04-11 15:01:27 UTC 
We have a lot of options that define the default for new document. For example there is no question about the language of new documents or the page size. Bug for some options this relation is not so clear, eg. all the view settings.

Having some kind of info mark, ideally with a hint on the respective command (I also don't know how to switch this search criteria per document). This has been discussed in some tickets, recently bug 144814 somewhat more matured in bug 43786. I suggest to make this ticket a duplicate and to consolidate all reports around this issue.