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 15:52:46 UTC
[Issue 126168] New: VLOOKUP does not work
https://bz.apache.org/ooo/show_bug.cgi?id=126168
Issue ID: 126168
Issue Type: DEFECT
Summary: VLOOKUP does not work
Product: Calc
Version: 3.4.1
Hardware: Mac
OS: Mac OSX, 10.10
Status: UNCONFIRMED
Severity: normal
Priority: P5
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: Janetzko@SBL-Logistik.de
Created attachment 84580
--> https://bz.apache.org/ooo/attachment.cgi?id=84580&action=edit
VLOOKUP does not work
VLOOKUP does not work
The VLOOKUP should see the same text in the two lines but it doesn't.
A normal IF function sees it.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126168] VLOOKUP does not work
Posted by bu...@apache.org.
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.
[Issue 126168] VLOOKUP does not work
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126168
--- Comment #2 from Janetzko@SBL-Logistik.de ---
Hello(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.
Hello Mrs Henschel
thank you very much for your answer. Now it works.
best regards
Eduard janetzko
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126168] VLOOKUP does not work
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126168
orcmid <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |orcmid@apache.org
--- Comment #3 from orcmid <or...@apache.org> ---
(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.