Re: Bug Label not recognized after if...then Resume

Hi Lucien, Am 23.06.22 um 13:41 schrieb Lucien Mathay: > Hi Mathias, > > Le 23/06/22 à 13:31, Matthias Seidel a écrit : >> Since you are on Windows, you might also want to test on my personal >> builds of AOO42X: > no, it also fails. Thanks for the information! Regards,    Matthias > > Best

isnumeric function

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.

Re: isnumeric function

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

Re: isnumeric function

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

Re: Bug Label not recognized after if...then Resume

Hi Lucien, Am 22.06.22 um 14:36 schrieb Lucien Mathay: > Hello all, > > I am back already.  I found a bug similar to the bug reported > previously with "If...then...else" followed by a comment. > > In the present case, the bug concerns a Label "exitfunction" that > follows a line "if...then

Re: isnumeric function

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

Re: isnumeric function

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 - >

Re: isnumeric function

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

RE: isnumeric function

Lucien asked, " Is that a relic from prehistoric ages ?" Yes. E was the original exponent marker for what we would now call float values. D was added to distinguish double from (single-precision) float. This had nothing to do with (Visual) Basic (for Applications) originally. To know what is

Re: Value returned by CInt("+1")

Hi all, Bugzilla issue 128518 - Basic - Converting "+1" to a number https://bz.apache.org/ooo/show_bug.cgi?id=128518 Regards, Czesław - To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org For additional commands,

Re: isnumeric function

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

Re: Value returned by CInt("+1")

Hi Czesław, On 6/23/22 11:18 AM, Czesław Wolański wrote: Hi all, Bugzilla issue 128518 - Basic - Converting "+1" to a number https://bz.apache.org/ooo/show_bug.cgi?id=128518 Regards, Czesław - To unsubscribe, e-mail:

Re: Bug Label not recognized after if...then Resume

Hi Mathias, Le 23/06/22 à 13:31, Matthias Seidel a écrit : Since you are on Windows, you might also want to test on my personal builds of AOO42X: no, it also fails. Best regards, Lucien