AllLangHelp_scalc.mk | 1
source/text/scalc/00/avail_release.xhp | 9 +
source/text/scalc/01/func_webservice.xhp | 128 +++++++++++------------
source/text/scalc/01/func_xlookup.xhp | 166 +++++++++++++++++++++++++++++++
source/text/scalc/guide/wildcards.xhp | 14 +-
5 files changed, 246 insertions(+), 72 deletions(-)
New commits:
commit 33a703440353008f3cb62855329e427ac41deedc
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Feb 19 13:54:10 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Feb 19 21:11:59 2024 +0100
tdf#159596 Help page for XLOOKUP function
+ Added new entries for release numbers
+ refactoring of some other files
Change-Id: I125fc35f1a38599e68857ad0959a5d3777a0a63e
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/163602
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 9038e92f1a..3f2110535f 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -278,6 +278,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_today \
helpcontent2/source/text/scalc/01/func_trunc \
helpcontent2/source/text/scalc/01/func_value \
+ helpcontent2/source/text/scalc/01/func_xlookup \
helpcontent2/source/text/scalc/01/func_weekday \
helpcontent2/source/text/scalc/01/func_webservice \
helpcontent2/source/text/scalc/01/func_weeknum \
diff --git a/source/text/scalc/00/avail_release.xhp
b/source/text/scalc/00/avail_release.xhp
index 07171f91a2..d0b17175bc 100644
--- a/source/text/scalc/00/avail_release.xhp
+++ b/source/text/scalc/00/avail_release.xhp
@@ -92,5 +92,14 @@
<section id="7.5">
<tip id="par_id651551401041670">This function is available since
%PRODUCTNAME 7.5.</tip>
</section>
+ <section id="7.6">
+ <tip id="par_id581708280759954">This function is available since
%PRODUCTNAME 7.6.</tip>
+ </section>
+ <section id="24.2">
+ <tip id="par_id81708280763167">This function is available since
%PRODUCTNAME 24.2.</tip>
+ </section>
+ <section id="24.8">
+ <tip id="par_id491708280768121">This function is available since
%PRODUCTNAME 24.8.</tip>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_webservice.xhp
b/source/text/scalc/01/func_webservice.xhp
index 50ba6d5fe3..c3efa3eacb 100644
--- a/source/text/scalc/01/func_webservice.xhp
+++ b/source/text/scalc/01/func_webservice.xhp
@@ -10,81 +10,79 @@
<helpdocument version="1.0">
<meta>
<topic id="textscalc01func_webservice" indexer="include"
status="PUBLISH">
- <title id="tit" xml-lang="en-US">URI Functions</title>
+ <title id="tit">URI Functions</title>
<filename>/text/scalc/01/func_webservice.xhp</filename>
</topic>
</meta>
- <body>
- <section id="section identification">
- <bookmark id="bm_id521677019419913" xml-lang="en-US"
branch="hid/CHANGE ME" localize="false"/>
+<body>
+ <section id="uri_functions">
<h1 id="hd_id391677019419915"><variable id="h1"><link
href="text/scalc/01/func_webservice.xhp">URI Functions</link></variable></h1>
- <paragraph id="par_id141677019419921" role="paragraph"
xml-lang="en-US">These spreadsheet functions are used for inserting data from
Universal Resource Identifiers (URI).</paragraph>
- </section>
+ <paragraph id="par_id141677019419921" role="paragraph">These
spreadsheet functions are used for inserting data from Universal Resource
Identifiers (URI).</paragraph>
+ </section>
<section id="webservice">
- <bookmark xml-lang="en-US" branch="index" id="bm_id3149012">
+ <bookmark branch="index" id="bm_id3149012">
<bookmark_value>WEBSERVICE function</bookmark_value>
</bookmark>
- <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEBSERVICE"
id="bm_id3150028" localize="false"/>
+ <bookmark branch="hid/SC_HID_FUNC_WEBSERVICE" id="bm_id3150028"
localize="false"/>
<section id="webservicefuncheader">
<h2 id="hd_id3149012"><variable id="webservicefuncname"><link
href="text/scalc/01/func_webservice.xhp#webservice">WEBSERVICE</link></variable></h2>
- <paragraph role="paragraph" id="par_id3149893"
xml-lang="en-US"><ahelp
- hid="HID_FUNC_WEBSERVICE">Get some web content from a
URI.</ahelp></paragraph>
- </section>
- <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
- <paragraph role="code" id="par_id3154844"
xml-lang="en-US">WEBSERVICE(URI)</paragraph>
- <paragraph role="paragraph" id="par_id3147469"
xml-lang="en-US"><emph>URI: </emph> URI text of the web service.</paragraph>
- <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
- <paragraph role="paragraph" id="par_id3146142"
xml-lang="en-US"><item
type="input">=WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss")</item></paragraph>
- <paragraph role="paragraph" id="par_id3146143"
xml-lang="en-US">Returns the web page content of
"https://wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss";.</paragraph>
- <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
- <embed href="text/scalc/01/common_func.xhp#notODFF"/>
- <paragraph role="paragraph" id="par_id341640870986703"
localize="false"><literal>COM.MICROSOFT.WEBSERVICE</literal></paragraph>
- </section>
- <section id="filterxml">
- <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FILTERXML"
id="bm_id2950028" localize="false"/>
- <bookmark xml-lang="en-US" branch="index" id="bm_id2949012">
- <bookmark_value>FILTERXML function</bookmark_value>
- </bookmark>
- <section id="filterxmlfuncheader">
- <h2 id="hd_id2949012"><variable id="filterxmlfuncname"><link
href="text/scalc/01/func_webservice.xhp#filterxml">FILTERXML</link></variable></h2>
- <paragraph role="paragraph" id="par_id2949893"
xml-lang="en-US"><ahelp hid="HID_FUNC_FILTERXML">Apply a XPath expression to a
XML document.</ahelp></paragraph>
- </section>
- <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
- <paragraph role="code" id="par_id2954844"
xml-lang="en-US">FILTERXML(XML Document; XPath expression)</paragraph>
- <paragraph role="paragraph" id="par_id2947469"
xml-lang="en-US"><emph>XML Document (required):</emph> String containing a
valid XML stream.</paragraph>
- <paragraph role="paragraph" id="par_id2847469"
xml-lang="en-US"><emph>XPath expression (required):</emph> String containing a
valid XPath expression.</paragraph>
- <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
- <paragraph role="paragraph" id="par_id2946142"
xml-lang="en-US"><item
type="input">=FILTERXML(WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate")</item></paragraph>
- <paragraph role="paragraph" id="par_id2946143" xml-lang="en-US">
Returns information on the last build date of the wiki.</paragraph>
- <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
- <embed href="text/scalc/01/common_func.xhp#notODFF"/>
- <paragraph role="paragraph" id="par_id341600873986703"
localize="false"><literal>COM.MICROSOFT.FILTERXML</literal></paragraph>
+ <paragraph role="paragraph" id="par_id3149893"><ahelp
hid="HID_FUNC_WEBSERVICE">Get some web content from a URI.</ahelp></paragraph>
</section>
- <section id="encodeurl">
- <bookmark id="bm_id121517132649769" xml-lang="en-US"
branch="hid/SC_HID_FUNC_ENCODEURL" localize="false"/>
- <bookmark xml-lang="en-US" branch="index"
id="bm_id811517136840444">
- <bookmark_value>ENCODEURL function</bookmark_value>
- </bookmark>
- <section id="encodeurlfuncheader">
- <h2 id="hd_id671517132649769"><variable
id="encodeurlname"><link
href="text/scalc/01/func_webservice.xhp#encodeurl">ENCODEURL</link></variable></h2>
- <paragraph id="par_id51517132649769" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_ENCODEURL">Returns a URL-encoded
string.</ahelp></paragraph>
- </section>
- <paragraph role="paragraph" id="par_id721517134647880"
xml-lang="en-US">Use this function to transform text with symbols of national
alphabets (for example accented characters, non-ASCII alphabets or Asian words)
to a string of URL-standard symbols.</paragraph>
- <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
- <paragraph role="code" id="par_id351517132879400"
xml-lang="en-US">ENCODEURL(Text)</paragraph>
- <paragraph role="paragraph" id="par_id921517132924079"
xml-lang="en-US"><emph>Text</emph>: String to encode to a sequence of
URL-standard symbols.</paragraph>
- <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
- <paragraph role="paragraph" id="par_id651517132994921"
xml-lang="en-US">If cell A1 contains the Cyrillic text "автомобиль", <item
type="input">=ENCODEURL(A1)</item> returns
%D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%BE%D0%B1%D0%B8%D0%BB%D1%8C (the word
"автомобиль" means car in Russian).</paragraph>
- <paragraph role="paragraph" id="par_id991517133057478"
xml-lang="en-US">If cell B1 contains the text "車", <item
type="input">=ENCODEURL(B1)</item> returns %E8%BB%8A ("車" means car in
Japanese).</paragraph>
- <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
- <embed href="text/scalc/00/avail_release.xhp#5.0"/>
- <embed href="text/scalc/01/common_func.xhp#notODFF"/>
- <paragraph role="paragraph" id="par_id301640873986703"
localize="false"><literal>COM.MICROSOFT.ENCODEURL</literal></paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+ <paragraph role="code" id="par_id3154844">WEBSERVICE(URI)</paragraph>
+ <paragraph role="paragraph" id="par_id3147469"><emph>URI: </emph> URI
text of the web service.</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+ <paragraph role="paragraph" id="par_id3146142"><item
type="input">=WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss")</item></paragraph>
+ <paragraph role="paragraph" id="par_id3146143">Returns the web page
content of
"https://wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss";.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640870986703"
localize="false"><literal>COM.MICROSOFT.WEBSERVICE</literal></paragraph>
+ </section>
+ <section id="filterxml">
+ <bookmark branch="hid/SC_HID_FUNC_FILTERXML" id="bm_id2950028"
localize="false"/>
+ <bookmark branch="index" id="bm_id2949012">
+ <bookmark_value>FILTERXML function</bookmark_value>
+ </bookmark>
+ <section id="filterxmlfuncheader">
+ <h2 id="hd_id2949012"><variable id="filterxmlfuncname"><link
href="text/scalc/01/func_webservice.xhp#filterxml">FILTERXML</link></variable></h2>
+ <paragraph role="paragraph" id="par_id2949893"><ahelp
hid="HID_FUNC_FILTERXML">Apply a XPath expression to a XML
document.</ahelp></paragraph>
</section>
- <section id="relatedtopics">
- <tip id="par_id781677019731175"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEBSERVICE";>WEBSERVICE</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FILTERXML";>FILTERXML</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ENCODEURL";>ENCODEURL</link>
wiki pages.</tip>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+ <paragraph role="code" id="par_id2954844">FILTERXML(XML Document;
XPath expression)</paragraph>
+ <paragraph role="paragraph" id="par_id2947469"><emph>XML Document
(required):</emph> String containing a valid XML stream.</paragraph>
+ <paragraph role="paragraph" id="par_id2847469"><emph>XPath expression
(required):</emph> String containing a valid XPath expression.</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+ <paragraph role="paragraph" id="par_id2946142"><item
type="input">=FILTERXML(WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate")</item></paragraph>
+ <paragraph role="paragraph" id="par_id2946143"> Returns information on
the last build date of the wiki.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341600873986703"
localize="false"><literal>COM.MICROSOFT.FILTERXML</literal></paragraph>
+ </section>
+ <section id="encodeurl">
+ <bookmark id="bm_id121517132649769" branch="hid/SC_HID_FUNC_ENCODEURL"
localize="false"/>
+ <bookmark branch="index" id="bm_id811517136840444">
+ <bookmark_value>ENCODEURL function</bookmark_value>
+ </bookmark>
+ <section id="encodeurlfuncheader">
+ <h2 id="hd_id671517132649769"><variable id="encodeurlname"><link
href="text/scalc/01/func_webservice.xhp#encodeurl">ENCODEURL</link></variable></h2>
+ <paragraph id="par_id51517132649769" role="paragraph"><ahelp
hid="HID_FUNC_ENCODEURL">Returns a URL-encoded string.</ahelp></paragraph>
</section>
- </body>
+ <paragraph role="paragraph" id="par_id721517134647880">Use this
function to transform text with symbols of national alphabets (for example
accented characters, non-ASCII alphabets or Asian words) to a string of
URL-standard symbols.</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+ <paragraph role="code"
id="par_id351517132879400">ENCODEURL(Text)</paragraph>
+ <paragraph role="paragraph"
id="par_id921517132924079"><emph>Text</emph>: String to encode to a sequence of
URL-standard symbols.</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+ <paragraph role="paragraph" id="par_id651517132994921">If cell A1
contains the Cyrillic text "автомобиль", <item
type="input">=ENCODEURL(A1)</item> returns
%D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%BE%D0%B1%D0%B8%D0%BB%D1%8C (the word
"автомобиль" means car in Russian).</paragraph>
+ <paragraph role="paragraph" id="par_id991517133057478">If cell B1
contains the text "車", <item type="input">=ENCODEURL(B1)</item> returns
%E8%BB%8A ("車" means car in Japanese).</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#5.0"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id301640873986703"
localize="false"><literal>COM.MICROSOFT.ENCODEURL</literal></paragraph>
+ </section>
+ <section id="relatedtopics">
+ <tip id="par_id781677019731175"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEBSERVICE";>WEBSERVICE</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/FILTERXML";>FILTERXML</link>,
<link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ENCODEURL";>ENCODEURL</link>
wiki pages.</tip>
+ </section>
+</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_xlookup.xhp
b/source/text/scalc/01/func_xlookup.xhp
new file mode 100644
index 0000000000..8e718c0e9c
--- /dev/null
+++ b/source/text/scalc/01/func_xlookup.xhp
@@ -0,0 +1,166 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="textscalc01func_xlookupxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">XLOOKUP Function</title>
+ <filename>/text/scalc/01/func_xlookup.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+<bookmark branch="hid/SC_HID_FUNC_XLOOKUP_MS" id="bm_id501708280229180"
localize="false"/>
+<bookmark branch="index" id="bm_id361708283183878">
+ <bookmark_value>XLOOKUP function</bookmark_value>
+</bookmark>
+<section id="xlookup">
+ <h1 id="hd_id821708279355736"><variable id="h1"><link
href="text/scalc/01/func_xlookup.xhp">XLOOKUP</link></variable></h1>
+ <paragraph id="par_id581708279355738" role="paragraph">Searches for a
value in an array and returns a reference to a cell or range of
cells.</paragraph>
+</section>
+<paragraph role="paragraph" id="par_id631708282151776">XLOOKUP function is a
modern and flexible replacement for older functions like <link
href="text/scalc/01/04060109.xhp#Section9">VLOOKUP</link>, <link
href="text/scalc/01/04060109.xhp#Section17">HLOOKUP</link>, and <link
href="text/scalc/01/04060109.xhp#Section14">LOOKUP</link>. XLOOKUP supports
approximate and exact matching, wildcards (* ?) for partial matches, and
lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search
and offers a fast binary search option when working with large
datasets.</paragraph>
+<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+<paragraph role="code" id="par_id211708281649651">XLOOKUP(Lookup; Array;
Return [; NotFound; MatchType; SearchMode ] )</paragraph>
+
+<paragraph role="paragraph" id="par_id861708281340704"><emph>Lookup</emph>:
The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP
returns blank cells it finds in <emph>Array</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id831708281625340"><emph>Array</emph>: is
the reference of the array or range to search.</paragraph>
+<paragraph role="paragraph" id="par_id241708281629922"><emph>Return</emph>: is
the reference of the array or range to return.</paragraph>
+<note id="par_id821708357634624">If <emph>Return</emph> is an array of values,
the XLOOKUP function must be entered as an <link
href="text/scalc/01/04060107.xhp#creating_array_formulas">array
formula</link>.</note>
+<paragraph role="paragraph" id="par_id271708281637035"><emph>NotFound</emph>:
a text to return if the <emph>Lookup</emph> value is not found. If a valid
match is not found, and <emph>NotFound</emph> is omitted, returns
#N/A.</paragraph>
+<paragraph role="paragraph" id="par_id121708281643207"><emph>MatchType</emph>:
Specify the match type:</paragraph>
+<list type="unordered">
+ <listitem>
+ <paragraph id="par_id111708281542144" role="listitem"><emph>0</emph>
- Exact match (default). If <emph>Lookup</emph> value is not found and
<emph>NotFound</emph> text is omitted, then return #N/A.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id851708281548335" role="listitem"><emph>-1</emph>
- Exact match. If <emph>Lookup</emph> value is not found, then return the next
smaller item.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id801708281553430" role="listitem"><emph>1</emph>
- Exact match. If <emph>Lookup</emph> value is not found, then return the next
larger item.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id881708281558005" role="listitem"><emph>2</emph>
- A <link href="text/scalc/guide/wildcards.xhp">wildcard</link> match where
characters *, ?, and ~ have special meaning.</paragraph>
+ </listitem>
+</list>
+<paragraph role="paragraph"
id="par_id871708281607313"><emph>SearchMode</emph>: Specify the search mode to
use:</paragraph>
+<list type="unordered">
+ <listitem>
+ <paragraph id="par_id281708281579757" role="listitem"><emph>1</emph>:
- Search starting at the first item (default).</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id251708281584285" role="listitem"><emph>-1</emph>
- Reverse search starting at the last item.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id191708281589997" role="listitem"><emph>2</emph>
- Binary search that relies on <emph>Array</emph> being sorted in ascending
order. If not sorted, invalid results will be returned.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id561708281595885" role="listitem"><emph>-2</emph>
- Binary search that relies on <emph>Array</emph> being sorted in descending
order. If not sorted, invalid results will be returned.</paragraph>
+ </listitem>
+</list>
+<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+<paragraph role="paragraph" id="par_id961708354814163">The table below
contains a glossary for translators:</paragraph>
+<table id="tab_id951708353695721">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id401708355378097" localize="false"
role="tablehead"></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id81708355053626" localize="false"
role="tablehead">A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id771708355056839" localize="false"
role="tablehead">B</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id481708355061087" localize="false"
role="tablehead">C</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id971708355064256" localize="false"
role="tablehead">D</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id601708355403103" localize="false"
role="tablehead">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id781708353695722"
role="tablecontent"><emph>English</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id641708353695723"
role="tablecontent"><emph>French</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id671708353695724"
role="tablecontent"><emph>Italian</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id331708353781503"
role="tablecontent"><emph>Japanese</emph></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id931708356090847" localize="false"
role="tablehead">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id531708353695725" localize="false"
role="tablecontent"><emph>New</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id151708353695726" localize="false"
role="tablecontent">Nouveau</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id901708353695727" localize="false"
role="tablecontent">Nuovo</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id821708353888675" localize="false"
role="tablecontent">新しい</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id81708356113416" localize="false"
role="tablehead">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id791708354354481" localize="false"
role="tablecontent"><emph>Save</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id91708354359320" localize="false"
role="tablecontent">Enregistrer</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id381708354362377" localize="false"
role="tablecontent">Salva</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id881708354364975" localize="false"
role="tablecontent">保存</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id401708355388097" localize="false"
role="tablehead">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id541708354368489" localize="false"
role="tablecontent"><emph>Open</emph></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id991708354371528" localize="false"
role="tablecontent">Ouvrir</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id351708354374560" localize="false"
role="tablecontent">Apri</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id331708354377976" localize="false"
role="tablecontent">開ける</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+<paragraph role="paragraph" id="par_id31708356677157"><input>={XLOOKUP("New",
A2:A4, B2:E4,"Missing")}</input> returns the array
{Nouveau,Nuovo,新しい}.</paragraph>
+<paragraph role="paragraph"
id="par_id671708356683379"><input>={XLOOKUP("Reload", A2:A4,
B2:E4,"Missing")}</input> returns the array
{"Missing","Missing","Missing"}.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#24.8"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640870986703"
localize="false"><literal>COM.MICROSOFT.XLOOKUP</literal></paragraph>
+<section id="relatedtopics">
+ <tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/XLOOKUP";>XLOOKUP
wiki page</link>.</tip>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/guide/wildcards.xhp
b/source/text/scalc/guide/wildcards.xhp
index 5c0b9630a9..a6e9f1cb94 100644
--- a/source/text/scalc/guide/wildcards.xhp
+++ b/source/text/scalc/guide/wildcards.xhp
@@ -11,20 +11,20 @@
<meta>
<topic id="calc_wildcards" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Using Wildcards in Formulas</title>
+ <title id="tit">Using Wildcards in Formulas</title>
<filename>/text/scalc/guide/wildcards.xhp</filename>
</topic>
</meta>
<body>
- <bookmark xml-lang="en-US" branch="index" id="bm_id3152149">
+ <bookmark branch="index" id="bm_id3152149">
<bookmark_value>wildcards in formulas</bookmark_value>
<bookmark_value>wildcards;examples</bookmark_value>
</bookmark>
<h1 id="hd_id941629155075179"><variable id="wildcards_h1"><link
href="text/scalc/guide/wildcards.xhp">Using Wildcards in
Formulas</link></variable></h1>
<paragraph role="paragraph" id="par_id571629155308959">Wildcards are special
characters that can be used in search strings that are passed as arguments to
some Calc functions. They can also be used to define search criteria in the
<emph>Find & Replace</emph> dialog. The use of wildcards enables the
definition of more advanced search parameters with a single search
string.</paragraph>
<paragraph role="paragraph" id="par_id391629156224638">%PRODUCTNAME Calc
supports either <emph>wildcards</emph> or <emph>regular expressions</emph> as
arguments depending on the current application settings. By default
%PRODUCTNAME Calc is set to support wildcards instead of regular
expressions.</paragraph>
- <tip id="par_id551629156504794">To make sure wildcards are supported, go to
<switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME -
Preferences - %PRODUCTNAME Calc -
Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options -
%PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline> and
check if the option <emph>Enable wildcards in formulas</emph> is selected. Note
that you can use this dialog to switch to regular expressions by choosing
<emph>Enable regular expressions in formulas</emph> or choose to support
neither wildcards nor regular expressions.</tip>
+ <tip id="par_id551629156504794">To make sure wildcards are supported, go to
<switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME -
Preferences - %PRODUCTNAME Calc -
Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options -
%PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline> and
check if the option <emph>Enable wildcards in formulas</emph> is selected. Note
that you can use this dialog to switch to regular expressions by choosing
<emph>Enable regular expressions in formulas</emph> or choose to support
neither wildcards nor regular expressions.</tip>
<paragraph role="paragraph" id="par_id141629156913731">The following
wildcards are supported:</paragraph>
<table id="tab_id561629209073388">
<tablerow>
@@ -50,7 +50,7 @@
</tablecell>
<tablecell>
<paragraph id="par_id51629209073388" role="tablecontent">Matches any
sequence of characters, including an empty string. For example, the search
string "*cast" will match “cast”, “forecast”, and “outcast”, but will not match
"forecaster" using default %PRODUCTNAME settings.</paragraph>
- <paragraph id="par_id351629209153307" role="tablecontent">If the
option <menuitem>Search criteria = and <> must apply to whole
cells</menuitem> is disabled in <switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc -
Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options -
%PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>, then
"forecaster" will be a match using the "*cast" search string.</paragraph>
+ <paragraph id="par_id351629209153307" role="tablecontent">If the
option <menuitem>Search criteria = and <> must apply to whole
cells</menuitem> is disabled in <switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc -
Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options -
%PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>, then
"forecaster" will be a match using the "*cast" search string.</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -74,14 +74,14 @@
<paragraph id="par_id321629158810916" role="listitem"><emph>Conditional
functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS,
SUMIF and SUMIFS.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id941629158811325" role="listitem"><emph>Lookup
functions:</emph> HLOOKUP, LOOKUP and VLOOKUP.</paragraph>
+ <paragraph id="par_id941629158811325" role="listitem"><emph>Lookup
functions:</emph> XLOOKUP, HLOOKUP, LOOKUP and VLOOKUP.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id41629158919808" role="listitem"><emph>Other
functions:</emph> MATCH and SEARCH.</paragraph>
+ <paragraph id="par_id41629158919808" role="listitem"><emph>Other
functions:</emph> XMATCH, MATCH and SEARCH.</paragraph>
</listitem>
</list>
<h2 id="hd_id701629159564269">Examples of Wildcards in Formulas</h2>
- <paragraph role="paragraph" id="par_id121629289062103">The following
examples consider that the options <menuitem>Enable wildcards in
formulas</menuitem> and <menuitem>Search criteria = and <> must apply to
whole cells</menuitem> are enabled in <switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc -
Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options -
%PRODUCTNAME Calc -
Calculate</menuitem></defaultinline></switchinline>.</paragraph>
+ <paragraph role="paragraph" id="par_id121629289062103">The following
examples consider that the options <menuitem>Enable wildcards in
formulas</menuitem> and <menuitem>Search criteria = and <> must apply to
whole cells</menuitem> are enabled in <switchinline select="sys"><caseinline
select="MAC"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc -
Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options -
%PRODUCTNAME Calc -
Calculate</menuitem></defaultinline></switchinline>.</paragraph>
<paragraph role="paragraph"
id="par_id271629159111490"><input>=COUNTIF(A1:A10;"Chi*")</input> counts the
number of cells in the range <emph>A1:A10</emph> containing strings that start
with "Chi" followed by zero or more characters.</paragraph>
<paragraph role="paragraph"
id="par_id741629159343415"><input>=SUMIF(A1:A5;"A??";B1:B5)</input> sums the
values in <emph>B1:B5</emph> whose corresponding values in <emph>A1:A5</emph>
start with "A" followed by exactly two other characters.</paragraph>
<note id="par_id141629159465592">Wildcard comparisons are <emph>not</emph>
case sensitive, hence "A?" will match both "A1" and "a1".</note>
