https://bugs.documentfoundation.org/show_bug.cgi?id=111920
raal <[email protected]> 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| |[email protected]
--- Comment #5 from raal <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs