[Libreoffice-bugs] [Bug 107371] New: Enhancement to Calc functions MATCH, HLOOKUP and VLOOKUP

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=107371

            Bug ID: 107371
           Summary: Enhancement to Calc functions MATCH, HLOOKUP and
                    VLOOKUP
           Product: LibreOffice
           Version: 5.2.3.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: david_lynch at blueyonder.co.uk

MATCH(SearchCriterion; LookupArray; Type)
        SearchCriterion is the value which is to be searched for in the
single-row or single-column array.
        LookupArray is the reference searched. A lookup array can be a single
row or column, or part of a single row or column.
        Type may take the values 1, 0, or -1. If Type = 1 or if this optional
parameter is omitted, it is assumed that the first column of the search array
is sorted in ascending order. If Type = -1 it is assumed that the column is
sorted in descending order. This corresponds to the same function in Microsoft
Excel.
        If Type = 0, only exact matches are found. If the search criterion is
found more than once, the function returns the index of the first matching
value. Only if Type = 0 

Enhancement requested:

*** or Type > 1 *** 

can you search for regular expressions (if enabled in calculation options) or
wildcards (if enabled in calculation options).
        If Type = 1 or the third parameter is omitted, the index of the last
value that is smaller than or equal to the search criterion is returned. This
applies even when the search array is not sorted. For Type = -1, the index of
the first value that is larger than or equal is returned.

Enhancement requested:

*** If Type > 1, only exact matches are found. If the search criterion is found
more than once, the function returns the index of the Type'th matching value.

VLOOKUP(SearchCriterion; Array; Index; Sorted)
HLOOKUP(SearchCriterion; Array; Index; Sorted)

Enhancement requested:

*** Sorted does the same as the Type parameter in function MATCH. ***

This enhancement is compatible with existing MATCH, HLOOKUP and VLOOKUP.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170423/31090797/attachment-0001.html>