https://bugs.documentfoundation.org/show_bug.cgi?id=141976
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--- Comment #3 from Eike Rathke <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
