diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-02-19 13:54:10 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-02-19 21:11:59 +0100 |
| commit | 33a703440353008f3cb62855329e427ac41deedc (patch) | |
| tree | 460d42ce1ae4729713812f8f6c6ae375b04f9af9 | |
| parent | d4aff35aba0b2db8179b57b523a94762f55b993a (diff) | |
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.hallot@libreoffice.org>
| -rw-r--r-- | AllLangHelp_scalc.mk | 1 | ||||
| -rw-r--r-- | source/text/scalc/00/avail_release.xhp | 9 | ||||
| -rw-r--r-- | source/text/scalc/01/func_webservice.xhp | 128 | ||||
| -rw-r--r-- | source/text/scalc/01/func_xlookup.xhp | 166 | ||||
| -rw-r--r-- | source/text/scalc/guide/wildcards.xhp | 14 |
5 files changed, 246 insertions, 72 deletions
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> |