On Fri, 2011-11-11 at 15:41 +0100, Eike Rathke wrote: > 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)?
Thanks. Reverted. Will try to come up with a different approach then. Kohei -- Kohei Yoshida, LibreOffice hacker, Calc _______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
