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 2013/12/18 09:54:57 UTC

[Bug 98535] vlookup needs to have case sensitive option (or a new vlookups function that is case sensitive)

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

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |elish@apache.org
             Latest|---                         |4.1-dev
    Confirmation on|                            |
         Issue Type|ENHANCEMENT                 |DEFECT
     Ever confirmed|0                           |1
                 OS|Windows XP                  |All
           Severity|trivial                     |normal

--- Comment #2 from Edwin Sharp <el...@apache.org> ---
According help:
"If SortOrder is set to FALSE or zero, an exact match must be found, otherwise
the error Error: Value Not Available will be the result."

But this is not true - vlookup still fails when Sortorder=0.

AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455
Debian

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.