[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

--- Comment #4 from Luis <luismiguel.lacosta at gmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170822/7d8b2007/attachment.html>