source/text/shared/optionen/01060500.xhp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-)
New commits: commit 934cd73d20322b68c830c78ac596eeddcdf85051 Author: Mike Kaganski <mike.kagan...@collabora.com> AuthorDate: Tue Oct 27 13:56:02 2020 +0200 Commit: Mike Kaganski <mike.kagan...@collabora.com> CommitDate: Tue Oct 27 13:21:58 2020 +0100 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.kagan...@collabora.com> diff --git a/source/text/shared/optionen/01060500.xhp b/source/text/shared/optionen/01060500.xhp index bb3bf1216..389724976 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> _______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits