Issue 118343

Summary: word HIGH appearing in text string causes logic error
Product: Calc Reporter: tony.fields
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact: LadyMariu <ladymariu>
Severity: Normal    
Priority: P3 CC: issues
Version: OOo 3.3   
Target Milestone: ---   
Hardware: Mac   
OS: Mac OS X 10   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description tony.fields 2011-07-26 16:13:53 UTC
When using LOOKUP function to search range of text cells, the word HIGH which appears as one of the text inputs causes a logic error -  LOOKUP fails to recognise HIGH as a valid entry in range.

eg =LOOKUP($B25;$B$57:$B$67;D$57:D$67) where the word HIGH is in $B25 and in the range $B$57:$B$67 fails to work for HIGH but does work for other text entries
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:30:08 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 2 LadyMariu 2013-01-08 02:24:32 UTC
I tried the =lookup function and failed for different text strings

(not just the word "High" but "April" in an H2 cell where "April" was present at AF2 cell too).

=LOOKUP($H2;$A1:$AL1)  where H2 = "April" and AF2 = "April" output = 2013 (Z1!)

Worth checking the functionality for text strings.

It worked ok with numbers.

Tested on:
Win7 SP1 64bits (AOO 341m1 - B9593 - R 1372282)