You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/10/31 14:00:41 UTC

[Issue 125813] VLOOKUP() doesn't work like expected

https://issues.apache.org/ooo/show_bug.cgi?id=125813

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |rb.henschel@t-online.de
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
It is a feature :).

Goto Tools > Options > OpenOffice Calc > Calculate. Find the option "Search
criteria = and <> must apply to whole cells". If that is checked, the complete
cell content is used for comparisons, otherwise substrings will match too.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.