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


User rvojta changed the following:

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




------- Additional comments from [email protected] Tue Jan 27 15:49:22 
+0000 2009 -------
> Referring to my last entry...
> How can Hs0 return the HS0 line and have the VLOOKUP be working just fine? It 
> is
> the WRONG ANSWER. Doesn't that count as not working?

Again, read documentation:

 - match is *always* case-insensitive
 - when set to 1, returned line is not necessarily nearest the top

What is not clear? It's absolutely clear.

> How can I make this work case sensitive?

I gave you two links in of my previous comments. There's an example how to
provide case sensitive match with EXACT function. Read it and apply to OO.o. If
it will not work, use users forums or users mailing list.

Closing as INVALID. This is broken from your point of view, but according to
spec & documentation, this behavior is valid.

---------------------------------------------------------------------
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]

Reply via email to