https://bugs.documentfoundation.org/show_bug.cgi?id=111920
--- Comment #4 from Luis <[email protected]> ---
I looked at functions FIXED and DOLLAR:
FIXED(12345/10,2,false)
returns "1,234.50" in english and "1.234,50" in spanish.
DOLLAR(12345/10,2)
returns "$1,234.50" in english and "1.234,50 €" in spanish.
When you change cell language in the "Format cells" and the result of the
function is diferent nothing changes as only consider locale settings in Tools,
Options.
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. The cell is recalculated when you press [F9] over
cell or when you press [Ctrl+Shft+F9].
--
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
