<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Cells no automatically recalculated when formula is dependent of language and this is changed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=111920#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Cells no automatically recalculated when formula is dependent of language and this is changed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=111920">bug 111920</a> from <a class="email" href="mailto:luismiguel.lacosta@gmail.com" title="Luis <luismiguel.lacosta@gmail.com>"> Luis</a> <pre>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].</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>