Re: [Libreoffice] [Libreoffice-commits] .: sc/inc sc/source

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.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)?

Thanks.  Reverted.  Will try to come up with a different approach then.

Kohei

-- 
Kohei Yoshida, LibreOffice hacker, Calc