To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=98420
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sat Jan 24 00:14:43
+0000 2009 -------
Lookup presumes, that the search vector is sorted. Search values for LOOKUP may
be text and numbers mixed, but the text must be sorted behind the numbers.
Therefore the text 'cat' is expected to be behind the number 13. But the vector
ends there and the rule "If LOOKUP cannot find the search criterion, it matches
the largest value in the search vector that is less than or equal to the search
criterion." is used. In your case it matches the value 13 and therefore returns
the parallel 222 as result.
The behavior corresponds to the definition of the function.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
