[Libreoffice-bugs] [Bug 141976] HLOOKUP not working when (..) in lookup field

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug.

As described in HLOOKUP documentation [1]:

> 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.

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]
https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3151001
[2] https://unicode-org.github.io/icu/userguide/strings/regexp.html

-- 
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/20210429/c0bb0578/attachment.htm>