diff options
| author | Mike Kaganski <mike.kaganski@collabora.com> | 2020-10-27 13:56:02 +0200 |
|---|---|---|
| committer | Mike Kaganski <mike.kaganski@collabora.com> | 2020-10-27 13:21:58 +0100 |
| commit | 934cd73d20322b68c830c78ac596eeddcdf85051 (patch) | |
| tree | 450719d430669f3fb4fc6708830a9935eced506b | |
| parent | c1b3e8ec874a7d3fa2463a17bd55452315cec6df (diff) | |
Improve "Enable regular expressions in formulas" section
Add a link to regular expressions list; add LOOKUP to affected functions
Change-Id: Ic753552b916bdccfcb13335ff32490babe0d840a
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104836
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
| -rw-r--r-- | source/text/shared/optionen/01060500.xhp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/source/text/shared/optionen/01060500.xhp b/source/text/shared/optionen/01060500.xhp index bb3bf1216b..3897249760 100644 --- a/source/text/shared/optionen/01060500.xhp +++ b/source/text/shared/optionen/01060500.xhp @@ -197,7 +197,7 @@ <section id="wildcards"> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/formulawildcards" id="bm_id3154420" localize="false"/> <h2 id="hd_id3156449">Enable wildcards in formulas</h2> - <paragraph xml-lang="en-US" id="par_id3155093" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/formulawildcards">Specifies that wildcards are enabled when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH.</caseinline></switchinline></paragraph> + <paragraph xml-lang="en-US" id="par_id3155093" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/formulawildcards">Specifies that wildcards are enabled when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to LOOKUP, VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH.</caseinline></switchinline></paragraph> <list type="unordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3155100" role="listitem"><emph>?</emph> (question mark) matches any single character</paragraph> @@ -214,13 +214,13 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/formularegex" id="bm_id3154419" localize="false"/> <h2 id="hd_id3156448">Enable regular expressions in formulas</h2> - <paragraph xml-lang="en-US" id="par_id3155092" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/formularegex">Specifies that regular expressions instead of simple wildcards are enabled when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH. + <paragraph xml-lang="en-US" id="par_id3155092" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/formularegex">Specifies that <link href="text/shared/01/02100001.xhp" name="list of regular expressions">regular expressions</link> instead of simple wildcards are enabled when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to LOOKUP, VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH. </caseinline></switchinline><comment>Sorry, no more switches allowed inside AVIS tags</comment></paragraph> <warning id="par_id3155095">Do not enable regular expressions in formulas for spreadsheets that need to be interoperable with Microsoft Excel.</warning> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/formulaliteral" id="bm_id3154421" localize="false"/> <h2 id="hd_id3156450">No wildcards or regular expressions in formulas</h2> - <paragraph xml-lang="en-US" id="par_id3155097" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/formulaliteral">Specifies that only literal strings are used when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH. + <paragraph xml-lang="en-US" id="par_id3155097" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/formulaliteral">Specifies that only literal strings are used when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to LOOKUP, VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH. </caseinline></switchinline></paragraph> <warning id="par_id3155098">Do not disable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.</warning> |