diff options
Diffstat (limited to 'source/text/shared/optionen/01060500.xhp')
| -rw-r--r-- | source/text/shared/optionen/01060500.xhp | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/source/text/shared/optionen/01060500.xhp b/source/text/shared/optionen/01060500.xhp index 14625f669a..fca2206281 100644 --- a/source/text/shared/optionen/01060500.xhp +++ b/source/text/shared/optionen/01060500.xhp @@ -45,7 +45,7 @@ </bookmark><comment>UFI: removed a double entry</comment><comment>mw changed "cell contents;" to "case sensitivity;.."</comment><comment>mw deleted "numbers;decimal places (Calc)"</comment> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/OptCalculatePage" id="bm_id3149095" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optcalculatepage/@@nowidget@@" id="bm_id3149095" localize="false"/> -<h1 id="hd_id3145071"><link href="text/shared/optionen/01060500.xhp" name="Calculate">Calculate</link></h1> +<h1 id="hd_id3145071"><link href="text/shared/optionen/01060500.xhp">Calculate</link></h1> <paragraph xml-lang="en-US" id="par_id3147576" role="paragraph"><ahelp hid=".">Defines the calculation settings for spreadsheets.</ahelp> Defines the behavior of spreadsheets with iterative references, the date settings, the number of decimal places, and if capitalization or lower cases are to be considered when searching within sheets.</paragraph> </section> <section id="howtoget"> @@ -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 LOOKUP, 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">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 <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. + <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">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">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 LOOKUP, 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">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> |