Apache OpenOffice (AOO) Bugzilla – Issue 118343
word HIGH appearing in text string causes logic error
Last modified: 2013-08-07 15:14:47 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
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
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) M.-