LOOKUP, VLOOKUP do not work correctly with strings

To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=81155



User fst changed the following:

                What    ld value 
               |New value
============================================================
====================
                  Status|UNCONFIRMED              
|RESOLVED
------------------------------------------------------------
--------------------
              Resolution|                          |INVALID
------------------------------------------------------------
--------------------




------- Additional comments from fstopenoffice.org Fri Aug 31
10:36:40 +0000 2007 -------
Hi,

this is not a bug. You're looking up the whole cell content
which in case of K23
contains a space but the searched column has the value
without the space making
it correctly a none match.

For your second problem it's just the missing parameter for
the sort order. If
this parameter is true or not given, the search column has
to be sorted in
ascending order which clearly is not the case in your
example.

So this is not a bug and closed invalid.

Frank

------------------------------------------------------------
---------
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: issues-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org