Bug 160615 - Adding a warning message about the type of settings in Calc.
Summary: Adding a warning message about the type of settings in Calc.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Options-Dialog-Calc
  Show dependency treegraph
 
Reported: 2024-04-10 14:44 UTC by Amin Irgaliev
Modified: 2024-04-11 15:01 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.