[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