<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Nested functions return wrong values" href="https://bugs.documentfoundation.org/show_bug.cgi?id=111887#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Nested functions return wrong values" href="https://bugs.documentfoundation.org/show_bug.cgi?id=111887">bug 111887</a> from <a class="email" href="mailto:luismiguel.lacosta@gmail.com" title="Luis <luismiguel.lacosta@gmail.com>"> Luis</a> <pre>I make a little mistake: I said "Seems as in funcion TEXT of calc, the decimal separator of the format string is ever "." and the thousands separator is ever "," (is excel seems localized)." but really the format code of function TEXT is localized. But this is not relevant to the example file. Only is important to reproduce issue in LO installations with diferent languages. As the language of cell is set to default if locale is set to "English (USA)" the decimal separator to use in the format code is "." and the thousand separator to use in format code is "," so rest of comment is fine. I checked step by step the function in cell C4 and the correct result when cell B1 is equal to 12.1126 is Err:502 as show in cell. The issue is only related to function wizard.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>