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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 117002
           Summary: ISNUMBER is treating the value provided by LEFT as
                    text instead of as a number.
           Product: LibreOffice
           Version: 5.4.5.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: simm.emanem at gmail.com

The ISNUMBER function is not recognizing a number when it is obtained through
another function, or at least through LEFT().
I need to know whether a string of text starts with a number, or not, and so I
used =ISNUMBER(LEFT(G6)).

The value of G6 is "2aaa"
The result of =Left(G6) is 2.


=ISNUMBER(LEFT(G6))  results in FALSE.

It should show TRUE. 

Also, copying and pasting the cell containing the function using Paste Only >
Text results in 2 being displayed in the cell.

But copying and pasting using Paste Only > Number option results in a blank
cell.

I am pretty sure that the problem is with ISNUMBER, because if I add a number
to the result of  LEFT, I get a correct sum:   =LEFT(G6)+1 equals 3.

ISNUMBER is treating the value provided by LEFT as text instead of as a number.

-- 
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/20180413/ec01bafc/attachment.html>