Re: isnumeric function

2022-06-23 Thread Dave 



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

2022-06-23 Thread Dave 



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

Fwd: AOO 4.1 Feature Verification Test needs your help -- Call for volunteers!

2014-01-17 Thread Dave 
Testing 4.1: I could do a few tests on Ubuntu 64bit. However I am only
really familiar with AOO Writer, not with the other modules. Yours, Dave


-- Forwarded message --
From: Rob Weir robw...@apache.org
Date: 17 January 2014 14:52
Subject: Fwd: AOO 4.1 Feature Verification Test needs your help -- Call for
volunteers!
To:
Cc: us...@openoffice.apache.org us...@openoffice.apache.org, 
market...@openoffice.apache.org market...@openoffice.apache.org, 
d...@openoffice.apache.org d...@openoffice.apache.org


A good opportunity to test-drive AOO 4.1, in a pre-beta form.  I
wouldn't recommend using pre-release code for real work, but if you
are curious and can help run some test cases (we have 945 test cases
remaining) you can help us reach our beta-release target.

Read on for more details about how to help...

Regards,

-Rob


-- Forwarded message --
From: Yuzhen Fan fanyuz...@gmail.com
Date: Fri, Jan 17, 2014 at 4:39 AM
Subject: AOO 4.1 Feature Verification Test needs your help -- Call for
volunteers!
To: qa qa@openoffice.apache.org, dev d...@openoffice.apache.org


Hi All,

We have made some progress on the 4.1 Feature Verification Test (FVT)
execution with help from Edwin, Maryna and Liu Ping and will get even more
done with upcoming helping from Nadya and Simon.

But we still have a lot of work to do.  We still have 945 testcases to
run.  Completing these tests is critical to finish feature FVT before
February 13th, so we can start the beta for AOO 4.1 on time as scheduled
[1].

We need your help.  Even if you don't consider yourself a tester, you can
still help.  You just need to be familiar with the OpenOffice product and
be able to follow test instructions and record your results. If every
volunteer can do a number of executions, then we will get a great
achievement.

We need volunteers on Linux Redhat 64bit, Linux Redhat 32bit, Linux Ubuntu
64bit, Mac 10.8/10.9, Windows 7 and Windows 8.

If you have interest and can help over the next few weeks, please send a
note to the QA mailing list (qa@openoffice.apache.org).   If you have a
Testlink account[2] send your ID as well as what platform you can help
test.   You should also get installation sets from trunk [3] and report
issues in Bugzilla [4].

Thanks!

[1]
https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.1+Release+Planning
[2] http://aootesting.adfinis-sygroup.org/index.php
[3] http://ci.apache.org/projects/openoffice/
[4] https://issues.apache.org/ooo/

Yuzhen Fan(范玉珍)

-
To unsubscribe, e-mail: doc-unsubscr...@openoffice.apache.org
For additional commands, e-mail: doc-h...@openoffice.apache.org