Hi Kohei, On Thursday, 2011-11-10 12:49:29 -0800, Kohei Yoshida wrote:
commit eaea417bfdf8d06df2b7f2e42c904c32ce77e871
Author: Kohei Yoshida <kohei.yoshida@suse.com>
Date: Thu Nov 10 15:45:53 2011 -0500
Removing the mixed comparison flag, which is no longer needed.
This flag was introduced years ago to deal with Excel's behavior on
incorrectly sorted data range. But later versions of Excel no longer
follow that behavior & keeping this flag would make the evaluation
code unnecessarily more complex & hard to adopt to multi-item matching.
Isn't that needed for MATCH and ([HV])LOOKUP with mixed data such as 1,2,3,b,c,d when queried for "a" would return the last less_or_equal position, hence 3? Or are we now on a good track where when querying for string we always return #N/A if the less_or_equal match is numeric (and vice versa)? Eike -- LibreOffice Calc developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD : 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
Attachment:
pgpXegW9cROcG.pgp
Description: PGP signature