[Libreoffice-bugs] [Bug 139612] Option "Search criteria = and <> must apply to whole cells" doesn't affect to calculation as must.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139612

--- Comment #7 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Mike Kaganski from comment #6)

Bibisected to
https://git.libreoffice.org/core/+/a953fa1c0f6a40a08859570516c511f3a8410a35
> author Michael Meeks <michael.meeks at collabora.com> Sun Apr 08 00:24:15 2018 +0100
> committer Michael Meeks <michael.meeks at collabora.com> Tue Apr 10 22:28:37 2018 +0200
> 
> vlookup - optimize SC_EQUAL and NOT_EQUAL.
> 
> Also don't accept partial matches ie. CONTAINS != EQUAL,
> for VLOOKUP even if document option "search criteria =, <>
> for whole cells" is turned off.
> 
> This also adds a new spreadsheet test file vlookup2.fods
> with the option "search criteria =,<> for whole cells" turned off,
> with VLOOKUP test cases that ensures that partial matches are not
> accepted.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210115/8429b637/attachment.htm>