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 2014/10/09 21:06:22 UTC
[Issue 125735] New: Vlookup ignores trailing signs
https://issues.apache.org/ooo/show_bug.cgi?id=125735
Issue ID: 125735
Issue Type: DEFECT
Summary: Vlookup ignores trailing signs
Product: Calc
Version: 4.1.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: josemoya@gmail.com
Created attachment 84051
--> https://issues.apache.org/ooo/attachment.cgi?id=84051&action=edit
Screenshot with target and destination tables and formula
Using ES-ES (spanish) locale.
A named range contains grades like "b+" ("bien alto": very good), "r-"
("regular bajo": almost average) and so on.
I use "BuscarV" (spanish for VlookUP) to translate from simbols to numeric
grades and get an average.
But when a Cell contains "B+", grade for "B" is issued, despite of using
"ordered" parameter with value=0.
It seems that this issue affects only to "+", not to "-"
(Look at the attached screenshot).
I don't have enough space in disk to compile a dev version so I don't know if
4.2 is affected.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125735] Vlookup ignores trailing signs
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125735
brinzing <ol...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #3 from brinzing <ol...@gmx.de> ---
as stated above:
> Special characters are . ^ $ * + ? \ [ ( { | , use escape character \ before
> special characters if regular expressions is enabled.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125735] Vlookup ignores trailing signs
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125735
brinzing <ol...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--- Comment #4 from brinzing <ol...@gmx.de> ---
closing
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125735] Vlookup ignores trailing signs
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125735
arcalaus <jo...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |josemoya@gmail.com
--- Comment #1 from arcalaus <jo...@gmail.com> ---
Created attachment 84052
--> https://issues.apache.org/ooo/attachment.cgi?id=84052&action=edit
Sample ods file
I'm adding also my test sheet.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125735] Vlookup ignores trailing signs
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125735
brinzing <ol...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |oliver.brinzing@gmx.de
Ever confirmed|0 |1
--- Comment #2 from brinzing <ol...@gmx.de> ---
please try:
[Solved] VLOOKUP Text w/ + Operator
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=46292
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.