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
That's it for the moment.
Thanks
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
