then there's something to QA against.
- Dennis
-Original Message-
From: Lucien Mathay
Sent: Thursday, June 23, 2022 08:12
To:qa@openoffice.apache.org
Subject: Re: isnumeric function
Le 23/06/22 à 16:23, Dave a écrit :
Like Pedro, I can replicate your issue, but cannot explain i
know what is recognized as a number, someone should specify the grammar for
such constants, and then there's something to QA against.
- Dennis
-Original Message-
From: Lucien Mathay
Sent: Thursday, June 23, 2022 08:12
To: qa@openoffice.apache.org
Subject: Re: isnumeric function
Le 23/
Le 23/06/22 à 16:23, Dave a écrit :
Like Pedro, I can replicate your issue, but cannot explain it, other
than to say it might be that the function is seeing 123D456 as a Hex
value, which equates to Decimal 19.125.334.
Dave,
the problem then is that 'A', 'B', 'C' and 'F' are not accepted
HI all,
Just a poorly educated guess:
In the source code, isNumeric()
http://openoffice-vm1-he-de.apache.org/xref/trunk/main/basic/source/runtime/methods.cxx?r=710acb7f#2472
leads to ImpScan()
http://openoffice-vm1-he-de.apache.org/xref/trunk/main/basic/source/sbx/sbxscan.cxx?r=323c3501#70
On 23/06/2022 14:26, Lucien Mathay wrote:
>
> Le 23/06/22 à 14:53, Dave a écrit :
>> Try =ISNUMBER("123D456") instead of =ISNUMERIC("123D456")
> Thank you and sorry, Dave, I forgot to specify that the question was
> related to Basic. ( msgbox ISNUMBER("123C456") sends "Basic error -
>
It is clearly an odd bug
isnumeric("123E456") is also True but isnumeric("123DE456") is False...
Maybe there is a confusion with Hexadecimal numbers? But A,B,C and F is also
False...
Anyone has a clue?
Regards,
Pedro
On Thursday 23 June 2022 14:26:33 (+01:00), Lucien Mathay wrote:
>
> Le
Le 23/06/22 à 14:53, Dave a écrit :
Try =ISNUMBER("123D456") instead of =ISNUMERIC("123D456")
Thank you and sorry, Dave, I forgot to specify that the question was
related to Basic. ( msgbox ISNUMBER("123C456") sends "Basic error -
function not defined" )
In Basic thus, msgbox
On 23/06/2022 13:39, Lucien Mathay wrote:
> Hi again,
>
> can anybody explain me why isnumeric("123D456") returns True ?
> (notice well the "D")
>
> To me it looks strange ... but maybe I miss something
>
> Thanks,
> Lucien.
Try =ISNUMBER("123D456") instead of =ISNUMERIC("123D456")
Same
