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)
3.5.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: User-Locale
  Show dependency treegraph
Reported: 2019-05-25 08:49 UTC by csongor
Modified: 2021-07-26 09:04 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


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 Comment hidden (obsolete)
Comment 5 Buovjaga 2020-06-04 16:18:49 UTC
(In reply to Xisco Faulí from comment #4)
> Not reproducible in
> Version (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

Contrary to this result, I get the problem with the oldest commit of 41max and 43all on Linux.