https://bz.apache.org/ooo/show_bug.cgi?id=126168
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from orcmid <[email protected]> --- (In reply to Regina Henschel from comment #1) > 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. It seems to me that having this be the default is a problem for new users since it expects an advanced feature is understood. I am wondering about these alternatives: 1. Change AOO to have plain comparison by default in new spreadsheets (but have the setting be explicit and preserved on reading of existing documents). 2. Have some indication that regular-expression interpretation applies when entering VLOOKUP and other functions that are dependent on the regular-expression setting, whatever the default is. 3. Have (2) and, in ODF 1.3, extend these functions to have the regular-expression setting be over-ridden locally on the given function usage (extra parameter?), rather than having to deal with a global setting that impacts a great variety of functions. As usual, this is indeed an issue for non-expert users. I think it is a more of a WONTFIX. (Is this an interop case with Excel too, or does Excel work this way?) -- You are receiving this mail because: You are the assignee for the issue.
