Bug ID: 117002
Summary: ISNUMBER is treating the value provided by LEFT as
text instead of as a number.
Version: 220.127.116.11 release
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
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
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.
Libreoffice-bugs mailing list