You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/03/10 17:10:17 UTC

[Issue 126168] VLOOKUP does not work

https://bz.apache.org/ooo/show_bug.cgi?id=126168

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |rb.henschel@t-online.de
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
VLOOKUP is sensitive to regular expressions. Any character which belongs to the
syntax of regular expressions are not handled as simple character but as
command inside a regular expression. In your case + is such a character.

If you do not want to use regular expressions in the search, you have to
uncheck "Enable regular expressions in formulas" in Tools > Options >
OpenOffice Calc > Calculate.

-- 
You are receiving this mail because:
You are the assignee for the issue.