Issue 118343 - word HIGH appearing in text string causes logic error
Summary: word HIGH appearing in text string causes logic error
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.3
Hardware: Mac Mac OS X 10
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: LadyMariu
Depends on:
Reported: 2011-07-26 16:13 UTC by tony.fields
Modified: 2013-08-07 15:14 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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)