<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><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> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - HLOOKUP not working when (..) in lookup field"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=141976">bug 141976</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - HLOOKUP not working when (..) in lookup field"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=141976#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - HLOOKUP not working when (..) in lookup field"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=141976">bug 141976</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>This is not a bug.
As described in HLOOKUP documentation [1]:
<span class="quote">> The search supports wildcards or regular expressions. With regular
> expressions enabled, you can enter "all.*", for example to find the first
> location of "all" followed by any characters. If you want to search for a
> text that is also a regular expression, you must either precede every
> character with a "\" character, or enclose the text into \Q...\E. You can
> switch the automatic evaluation of wildcards or regular expression on and
> off in Tools - Options - LibreOffice Calc - Calculate.</span >
The parentheses (and many other elements) are parts of Regular Expression
syntax [2], and since your document has regular expressions enabled, the
parentheses are considered capturing elements of regular expression, not
literal search characters.
Make sure to not use regular expressions in formulas, or to properly mask the
strings that should not be treated as regular expressions, as described in the
help.
[1]
<a href="https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3151001">https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3151001</a>
[2] <a href="https://unicode-org.github.io/icu/userguide/strings/regexp.html">https://unicode-org.github.io/icu/userguide/strings/regexp.html</a></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>