Hi Joe, On Friday, 2008-04-11 16:29:14 -0400, Joe Smith wrote:
> 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. I don't know which m5 build you have, I didn't try with m5, but my m6 still gives 11 as result, which is correct. 19 would not be correct. With the given data in B51:C57 when searching for 6.1 the value 6 is the last value <= 6.1, the result vector has the corresponding value 11 in the same row. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks.
pgppIl5ajSeYl.pgp
Description: PGP signature
