<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Option "Search criteria = and <> must apply to whole cells" doesn't affect to calculation as must."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139612#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Option "Search criteria = and <> must apply to whole cells" doesn't affect to calculation as must."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139612">bug 139612</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>(In reply to Mike Kaganski from <a href="show_bug.cgi?id=139612#c6">comment #6</a>)
Bibisected to
<a href="https://git.libreoffice.org/core/+/a953fa1c0f6a40a08859570516c511f3a8410a35">https://git.libreoffice.org/core/+/a953fa1c0f6a40a08859570516c511f3a8410a35</a>
<span class="quote">> author Michael Meeks <<a href="mailto:michael.meeks@collabora.com">michael.meeks@collabora.com</a>> Sun Apr 08 00:24:15 2018 +0100
> committer Michael Meeks <<a href="mailto:michael.meeks@collabora.com">michael.meeks@collabora.com</a>> 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.</span ></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>