<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:luismiguel.lacosta@gmail.com" title="Luis <luismiguel.lacosta@gmail.com>"> <span class="fn">Luis</span></a>
</span> changed
<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>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>luismiguel.lacosta@gmail.com
</td>
</tr></table>
<p>
<div>
<b><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#c3">Comment # 3</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 <span class="vcard"><a class="email" href="mailto:luismiguel.lacosta@gmail.com" title="Luis <luismiguel.lacosta@gmail.com>"> <span class="fn">Luis</span></a>
</span></b>
<pre>I am from Spain and I have set Languaje setting of LO to:
User interface: English (USA)
Locale setting: English (USA)
Decimal separator key: checked Same as locale setting (.)
So decimal separator is "." and argument separator of functions is ","
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).
So
TEXT(12.1126,"#,##########") returns string "12"
Then
RIGHT(TEXT("12.1126","#,##########"),LEN(TEXT("12.1126","#,##########"))-LEN(TRUNC("12.1126"))-1)
Equals to
RIGHT("12",2-2-1) that returns "Err:502"
I think the issue is not with function processing but with the function wizard
that shows incorrect values when the function (once results of type error
appear) becomes more complex.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>