[Libreoffice-bugs] [Bug 125484] New: Updated locale does not update the result of text-resulting formulae

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125484

            Bug ID: 125484
           Summary: Updated locale does not update the result of
                    text-resulting formulae
           Product: LibreOffice
           Version: 6.2.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: csongor at halmai.hu

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).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190525/1cf57714/attachment.html>