Hi Kohei, On Thursday, 2011-11-10 12:49:29 -0800, Kohei Yoshida wrote:
> commit eaea417bfdf8d06df2b7f2e42c904c32ce77e871 > Author: Kohei Yoshida <kohei.yosh...@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
pgpMLqpstyCPG.pgp
Description: PGP signature
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
