[Libreoffice-bugs] [Bug 108268] EDITING: Vlookup doesn't work

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Jun 1 19:44:14 UTC 2017


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

GerardF <gerard.fargeot at orange.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
                 CC|                            |gerard.fargeot at orange.fr
         Resolution|---                         |NOTABUG

--- Comment #6 from GerardF <gerard.fargeot at orange.fr> ---
It is simply the REGEX enabled within the file.
Menu Tools > Option > LO Calc : Enable regular expressions in formula.
'(' is a REGEX.
The special characters are . ^ $ * + ? \ [ ( { |

If you want a (V/H)LOOKUP with one of these characters, disable the regex.

-- 
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/20170601/05e1fb1e/attachment.html>


More information about the Libreoffice-bugs mailing list