[Libreoffice-bugs] [Bug 117002] ISNUMBER is treating the value provided by LEFT as text instead of as a number.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Apr 14 00:36:42 UTC 2018


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

--- Comment #2 from MM <plokklop at vivaldi.net> ---
The outcome looks fully correct here. Left() is outputting character[s] (text)
instead of values, so Isnumber will always be false when given this as input.
https://help.libreoffice.org/Calc/Text_Functions#LEFT

-- 
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/20180414/44730750/attachment.html>


More information about the Libreoffice-bugs mailing list