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 -
> function not defined" )
>
> In Basic thus, msgbox isnumeric("123D456") returns True, although it
> should return False, if I am not wrong ?
>
> Lucien
Ah! Star Basic
IsNumeric is very picky about what it accepts.
Print IsNumeric(" 123”) 'True
Print IsNuneric(" 12 3”) 'False
Print lsNumeric(1.23) 'True
Print IsNumeric("123abc") 'False
Print IsNuneric(True) 'False
Print IsNumeric(Now) 'False
See "Openoffice.Org Macros Explained by Andrew Pitonyak"
https://www.pitonyak.org/book/ page 221
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
For additional commands, e-mail: qa-h...@openoffice.apache.org
