My local setting in `Tools` -> `Options` -> `Language Settings` -> `Languages` -> `Locale setting` is Hungarian and the label of the checkbox under it is "Same as locale setting (,)"
If I enter the formula `=1/2` in the cell A1 then "0,5" is displayed which is correct, in Hungarian, decimal comma is used, not period.
If I enter the formula `="A:"&A1` then "A:0,5" is displayed which is also correct.
However, if I change the locale setting to "English (USA)" then the following things happen:
- A1 is changed to "0.5" which is correct.
- B1 is not changed, it remains "A:0,5" (comma) which seems to be wrong
- a vague error message is displayed which seems to be related to this issue.
Instead of this, the following should happen:
- displaying a question: "Some text-resulting formulae refer to cells containing numbers. Do you want to update them according to the new locale setting?"
- if the user says YES then B1 should show "A:0.5" (period), otherwise it should remain "A:0,5" (comma).
i can confirm this behaviour, changing locale results in:
"Because the current formula separator settings conflict with the locale,
the formula separators have been reset to their default values."
-> B1 is not changed, it remains "A:0,5"
but a hard recalc via Menu "Data/Calculate/Recalculate Hard"
seems to solve the problem
it's fixed after LibreOffice is restarted.
LibreOffice ask to restart for this kind of reason.
Closing as RESOLVED NOTABUG
Actually, my previous comment was wrong. If locale is changed, it doesn't ask for restarting... Sorry
Not reproducible in
Version 220.127.116.11.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)