[Libreoffice-bugs] [Bug 111920] Cells no automatically recalculated when formula is dependent of language and this is changed

[bugzilla-daemon at bugs.documentfoundation.org]

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

raal <raal at post.cz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
            Version|5.4.0.3 release             |4.1.0.4 release
                 OS|Windows (All)               |All
                 CC|                            |raal at post.cz

--- Comment #5 from raal <raal at post.cz> ---

I can confirm with Version: 6.2.0.0.alpha0+
Build ID: b7e139fa21607f488465fd87333db757ad0c91a2
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 
and 4.1

When the lenguage of cell is English (decimal separator is ".") the formula
TEXT(12345/10,"#.000") returns "1234.500"
but when the lenguage of cell is Spanish (decimal separator is ",") the formula
TEXT(12345/10,"#.000") return "1.235"
When you change cell language in the "Format cells" dialog or when you change
locale settings in Tools -> Options... -> Language Settings -> Languages and
the result of the function is diferent, the cell is not automatically
recalculated

---
informational message:
Because the current formula separator settings conflict with the locale, the
formula separators have been reset to their default values.

can be tweaked or we should trigger recalculation.

-- 
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/20180727/6ac740a9/attachment.html>