Moin Drew,
On 01.12.08 09:30, Drew Jensen wrote:
Ocke Janssen wrote:
If anything doesn't work as for example in a DEV300_m35 so please
tell me or even submit an issue so that it doesn't get lost. So
please help.
I've started a database with a separate report per function. Not that
far along yet, but will push through (OTHER FOLKS ARE INVITED TO
CONTRIBUTE ) and let you know as I update it.
I've put a copy at http://oucv.org/download/func_tests.odb and will
overwrite that as I add to it - if others want to help they can
download, add a report for a function and email it to me, I'll merge
their reports into this file.
Each function has a report named test_fn_<FUNCTION>, examples:
test_fn_EXACT and test_fn_RIGHT.
For each function I tried to put in a usage that I expected to work,
or variations I expected to work, and for some bounds checking where I
expected it to fail in one way or the other.
example: LEFT([txt], -1 ) is an example of a bounds check looking for
what happens with bad data.
Current functions covered and some comments, questions:
EXACT - 1 question
Not sure if this has an error or not, but in one test "EXACT([txt];0)
= false" I expected an error not false.
FIND - 2 questions
In the 2nd test I expected an error message and got a null string.
In the 3rd test I expected it to return something like -1 to say that
no match was found not "LibFormulaErrorValue{errorCode=504} "
LEFT - All seems as I would expect.
MID - Looks like this is just plain broke.
REPLACE - 2 questions
2nd test, errorcode = 0, is that correct?
3rd test, didn't really expect to get the result I got...but maybe
that is right.
RIGHT - All seems as I would expect.
T - Just seems to be broke, only seems to accept text values..and
what's that point in that?
TEXT - Ok, this acts how I expected 'T' to act - but 1 problem
next to last test line: TEXT(100.01) returns a null string, it seems
any time there is a decimal followed by a zero it returns a null string
Please submit an issue for every function that doesn't work. I have to
fix everything in libformula or better submit an fix for libformula.
Best regards,
Ocke
That's it for the moment.
Thanks
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
