I was playing with the new ODFF compatibility changes for MATCH[1] and
LOOKUP[2], and noticed what seems to be an error in the current ODFF
spec (OpenDocument-formula-20071228[3]).
In section 6.13.7, "LOOKUP", p.246, shows this test case:
> =LOOKUP(6.1;[.B51:.B57];[.C51:.C57])
> 11
> 2
> Lookup – if not exact, largest available that is smaller than value
to Find
I believe the correct result there is 19, not 11. DEV300_m5 gives 19.
Nice improvements here!
[1,2]
http://qa.openoffice.org/issues/buglist.cgi?resort=1&issue_id=15666,74245
[3]
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
