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

[Eike Rathke]

Hi Kohei,

On Thursday, 2011-11-10 12:49:29 -0800, Kohei Yoshida wrote:

> commit eaea417bfdf8d06df2b7f2e42c904c32ce77e871
> Author: Kohei Yoshida <kohei.yoshida at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20111111/6d6efd32/attachment.pgp>