https://bugs.freedesktop.org/show_bug.cgi?id=74075

m.a.riosv <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW
           Keywords|                            |regression
             Blocks|                            |65675

--- Comment #5 from m.a.riosv <[email protected]> ---
Wrong results for MATCH and VLOOKUP function. As in the sample both works with
the last parameter to 0, but fails with it at 1 or without it.

=MATCH(A1&"";$A$1:$A$36)
fails from 's'

=MATCH(A1&"^";$A$1:$A$36)
fails from 'z'

=MATCH(A1&".*";$A$1:$A$36)
=MATCH(A1&"$";$A$1:$A$36)
works fine

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to