Hi Niklas, On Monday, 2008-04-14 16:53:53 +0200, Niklas Nebel wrote:
>> > =LOOKUP(6.1;[.B51:.B57];[.C51:.C57]) >> I believe the correct result there is 19, not 11. DEV300_m5 gives 19. > > Did you enter the formula in a locale where 6.1 is parsed as a date (with a > value larger than those from the lookup list)? That would indeed be a possibility. One more cause to change the implicit relaxed date recognition to something more reasonable, respectively do not attempt to detect dates in formulas. 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.
pgpufVmmaeLVD.pgp
Description: PGP signature