XMATCH Function /text/scalc/01/func_xmatch.xhp XMATCH function

XMATCH

Searches for a value in a one-dimensional array and returns the relative position of the item.
XMATCH outperforms function MATCH as it allows searches according to the search mode. XMATCH(Search criterion; Search Array [; Match Mode [; Search Mode ] ] ) Search criterion: The value of any type to search for in Search Array. Search Array: is the reference of the array or range to search. Match Mode: (optional) specifies the match type. Values can be: 0: exact match (default). If Search criterion value is not found, then return the #N/A error. -1: attempt exact match. If Search criterion value is not found, then return the next smaller item. 1: attempt exact match. If Search criterion value is not found, then return the next larger item. 2: a wildcard match where characters *, ?, and ~ have special meanings. 3: a regular expression match. =XMATCH("Atomic Number"; A1:A4) returns 3, the third line of the A1:A4 array. =XMATCH("Li"; A2:DO2) returns 4, the fourth column of the A2:DO2 array. COM.MICROSOFT.XMATCH
XMATCH wiki page.
LibreOffice 核心代码仓库文档基金会
summaryrefslogtreecommitdiff
path: root/oox/source/ppt/headerfootercontext.hxx
AgeCommit message (Collapse)Author
2017-10-23loplugin:includeform: ooxStephan Bergmann
Change-Id: I9f1cc9940f5b31370394f789ebfaddfd6d30ca61
2017-07-31loplugin:constparams in ooxNoel Grandin
Change-Id: I43984b4ece82da39ca61a91fa14e4660298509dd Reviewed-on: https://gerrit.libreoffice.org/40581 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
2016-09-13loplugin:override: No more need for the "MSVC dtor override" workaroundStephan Bergmann
The issue of 362d4f0cd4e50111edfae9d30c90602c37ed65a2 "Explicitly mark overriding destructors as 'virtual'" appears to no longer be a problem with MSVC 2013. (The little change in the rewriting code of compilerplugins/clang/override.cxx was necessary to prevent an endless loop when adding "override" to OOO_DLLPUBLIC_CHARTTOOLS virtual ~CloseableLifeTimeManager(); in chart2/source/inc/LifeTime.hxx, getting stuck in the leading OOO_DLLPUBLIC_CHARTTOOLS macro. Can't remember what that isAtEndOfImmediateMacroExpansion thing was originally necessary for, anyway.) Change-Id: I534c634504d7216b9bb632c2775c04eaf27e927e
2014-06-25remove whitespacesMarkus Mohrhard
Change-Id: Ie14ba3dcb97f20479a04538748ef2c1c9e6c5dac
2014-04-01Explicitly mark overriding destructors as "virtual"Stephan Bergmann
It appears that the C++ standard allows overriding destructors to be marked "override," but at least some MSVC versions complain about it, so at least make sure such destructors are explicitly marked "virtual." Change-Id: I0e1cafa7584fd16ebdce61f569eae2373a71b0a1
2013-10-23fixincludeguards.sh: ooxThomas Arnhold
Change-Id: Ibc1fb5c149461d6030749a974c6d37aa11ad0e16