https://bugs.documentfoundation.org/show_bug.cgi?id=161612
Bug ID: 161612
Summary: [LOCALHELP] Improve help for Calc function XMATCH
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Current in part 'MatchType':
0: exact match (default). If Lookup value is not found and NotFound text is
omitted, then return the #N/A error.
Error:
The function XMATCH has no parameter 'NotFound'.
Suggested correction:
0: exact match (default). If Lookup value is not found, then return the #N/A
error.
-------------------------------------
Current in part 'MatchType':
2: a wildcard match where characters *, ?, and ~ have special meanings.
Problem:
LibreOffice allows not only wildcards but regular expressions as well.
Suggested correction:
2: a wildcard match where characters *, ?, and ~ have special meanings, or a
match using regular expressions.
--------------------------------------
Add a warning:
MatchType value 2 cannot be combined with binary search (SearchMode value 2 or
-2).
--------------------------------------
Problem:
A help page "Using Regular Expressions in Formulas" is missing.
Add such page and link to it from MatchType value 2 similar as the link on
"wildcards". Such link can then be included in XLOOKUP too and in other
functions that allow regular expressions.
--------------------------------------
XMATCH is case-insensitive by default. But you can use the mode modifier (?-i)
in regular expressions to force search for a case-sensitive match. A
corresponding hint is missing. If not the help, then at least the Wiki page
should have such hint.
--
You are receiving this mail because:
You are the assignee for the bug.
