Bug 125484 - Updated locale does not update the result of text-resulting formulae
Summary: Updated locale does not update the result of text-resulting formulae
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisectRequest, regression
Depends on:
Reported: 2019-05-25 08:49 UTC by csongor
Modified: 2019-05-27 14:23 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description csongor 2019-05-25 08:49:46 UTC
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).
Comment 1 Oliver Brinzing 2019-05-26 07:56:53 UTC
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
Comment 2 Xisco Faulí 2019-05-27 14:00:28 UTC Comment hidden (obsolete)
Comment 3 Xisco Faulí 2019-05-27 14:13:54 UTC
Actually, my previous comment was wrong. If locale is changed, it doesn't ask for restarting... Sorry
Comment 4 Xisco Faulí 2019-05-27 14:23:33 UTC
Not reproducible in

Version (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)