[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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
As I had this ready in the edit buffer anyway..

Either disable regular expressions under Tools -> Options -> Calc -> Calculate
(set to Wildcards for Excel compatibility, or no wildcards or regular
expressions at all), or if you want to keep them enabled to be active for other
expressions enclose the search text in \Q...\E to force literals, in your case

=HLOOKUP("\Q"& $J$9 &"\E";...)

(you could omit the closing "\E" in this case where it is the very last
switching quoted literals off).

-- 
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/05173e1e/attachment.htm>