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: qa-unsubscr...@openoffice.apache.org For additional commands, e-mail: qa-h...@openoffice.apache.org Thanks for entering it in bz. Best regards, Carl - To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org For additional commands, e-mail: qa-h...@openoffice.apache.org
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 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/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
Only 'D' and 'E' are accepted :
- 'E' probably stands for Exponent, thus is should be valid character in the
numeric string
- 'D' : something like "Decimal" ?
[orcmid] [ ... ]
- I note that msgbox ("123D-456") also returns True : 'D' seems thus to behave
like an exponent.
Power of 10 maybe ?
- lets test msgbox("123D3") : it prints out 123000 ; it seems thus
perfectly equivalent to "123E3"
Note that msgbox CDbl("123D3") does not loop but prints out 123000
Is that a relic from prehistoric ages ?
Lucien.
-
To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
For additional commands, e-mail: qa-h...@openoffice.apache.org
-
To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
For additional commands, e-mail: qa-h...@openoffice.apache.org
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, e-mail: qa-h...@openoffice.apache.org
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
Only 'D' and 'E' are accepted :
- 'E' probably stands for Exponent, thus is should be valid character in
the numeric string
- 'D' : something like "Decimal" ?
- in fact, as Basic states it is a number, I tried to print it out :
-> msgbox CLng("123D456") : raises an error stating an overflow
-> msgbox CDbl("123D456") : enters an infinite loop and you must
terminate the program to exit from this loop
-> msgbox CDec("123D456") : prints the value zero (0)
- I note that msgbox ("123D-456") also returns True : 'D' seems thus to
behave like an exponent.
Power of 10 maybe ?
- lets test msgbox("123D3") : it prints out 123000 ; it seems thus
perfectly equivalent to "123E3"
Note that msgbox CDbl("123D3") does not loop but prints out 123000
Is that a relic from prehistoric ages ?
Lucien.
-
To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
For additional commands, e-mail: qa-h...@openoffice.apache.org
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
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 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
>
>
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 -
> 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
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 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
>
> -
> To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: qa-h...@openoffice.apache.org
>
>
--
Sent with Vivaldi Mail. Download Vivaldi for free at vivaldi.com
-
To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
For additional commands, e-mail: qa-h...@openoffice.apache.org
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 isnumeric("123D456") returns True, although it
should return False, if I am not wrong ?
Lucien
-
To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
For additional commands, e-mail: qa-h...@openoffice.apache.org
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 meaning, different terminology,
-
To unsubscribe, e-mail: qa-unsubscr...@openoffice.apache.org
For additional commands, e-mail: qa-h...@openoffice.apache.org
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: 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 regards, > Lucien smime.p7s Description: S/MIME Cryptographic Signature
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
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 Resume" ; here is the code : > > Function EffacerFichier(nom As String, msg As String) As Boolean > Dim nb As Long > On Error GoTo erreur > EffacerFichier = True > GoTo exitfunction > erreur: > nb = nb + 1 > If nb<3 Then Resume > exitfunction: > End Function > > The error message states : "Label 'exitfunction' undefined. > > However when inserting a blank line just before the label > 'exitfunction', the compiler parses OK. > > I tested it on both OO4.1.6 and OO4.1.12, both fail. > > Sorry for that, No need to apologize! ;-) If the label is recognized with an empty line before, it is clearly a bug. Since you are on Windows, you might also want to test on my personal builds of AOO42X: https://home.apache.org/~mseidel/AOO-builds/AOO-420-Test/Full%20Installation/ Regards, Matthias > Lucien. > > > smime.p7s Description: S/MIME Cryptographic Signature
