https://bz.apache.org/ooo/show_bug.cgi?id=126168
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Resolution|--- |NOT_AN_ISSUE --- Comment #1 from Regina Henschel <[email protected]> --- 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.
