[Libreoffice-bugs] [Bug 111887] Nested functions return wrong values

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=111887

Luis <luismiguel.lacosta at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |luismiguel.lacosta at gmail.co
                   |                            |m

--- Comment #3 from Luis <luismiguel.lacosta at gmail.com> ---
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.

-- 
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/20170818/fe6dbe57/attachment.html>