[sc-issues] [Bug 118343] New: word HIGH appearing in text string causes logic error

http://openoffice.org/bugzilla/show_bug.cgi?id=118343

        Issue Type: DEFECT
           Summary: word HIGH appearing in text string causes logic error
    Classification: Application
           Product: Spreadsheet
           Version: OOo 3.3
          Platform: Macintosh
        OS/Version: Mac OS X
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: P3
         Component: programming
        AssignedTo: [email protected]
        ReportedBy: [email protected]
         QAContact: [email protected]


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

-- 
Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification
from Bugzilla. Please log into the website and enter your comments.
---------------------------------------------------------------------
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help