https://bugs.documentfoundation.org/show_bug.cgi?id=117002
m.a.riosv changed:
What|Removed |Added
Status|UNCONFIRMED |RESOLVED
CC|
https://bugs.documentfoundation.org/show_bug.cgi?id=117002
--- Comment #2 from MM ---
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
https://bugs.documentfoundation.org/show_bug.cgi?id=117002
--- Comment #1 from simm.ema...@gmail.com ---
The result of =LEFT(G6) is '2, not 2. I used VALUE(LEFT(G6)) to ensure that
the result is 2, not '2.
=ISNUMBER(VALUE(LEFT(DG6))) is 2.
--
You are receiving this mail because:
You are the a