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 See the description given in lines 63-65 http://openoffice-vm1-he-de.apache.org/xref/trunk/main/basic/source/sbx/sbxscan.cxx?r=323c3501#63 and the code in line `153-154 http://openoffice-vm1-he-de.apache.org/xref/trunk/main/basic/source/sbx/sbxscan.cxx?r=323c3501#152 Best regards, Czesław Le jeu. 23 juin 2022 à 16:23, Dave <b...@apache.org> a écrit : > > > 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 > >