1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?>
2cdf0e10cSrcweir<helpdocument version="1.0">
3cdf0e10cSrcweir
4*0ba1032bSAndrew Rist<!--***********************************************************
5*0ba1032bSAndrew Rist *
6*0ba1032bSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one
7*0ba1032bSAndrew Rist * or more contributor license agreements.  See the NOTICE file
8*0ba1032bSAndrew Rist * distributed with this work for additional information
9*0ba1032bSAndrew Rist * regarding copyright ownership.  The ASF licenses this file
10*0ba1032bSAndrew Rist * to you under the Apache License, Version 2.0 (the
11*0ba1032bSAndrew Rist * "License"); you may not use this file except in compliance
12*0ba1032bSAndrew Rist * with the License.  You may obtain a copy of the License at
13*0ba1032bSAndrew Rist *
14*0ba1032bSAndrew Rist *   http://www.apache.org/licenses/LICENSE-2.0
15*0ba1032bSAndrew Rist *
16*0ba1032bSAndrew Rist * Unless required by applicable law or agreed to in writing,
17*0ba1032bSAndrew Rist * software distributed under the License is distributed on an
18*0ba1032bSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19*0ba1032bSAndrew Rist * KIND, either express or implied.  See the License for the
20*0ba1032bSAndrew Rist * specific language governing permissions and limitations
21*0ba1032bSAndrew Rist * under the License.
22*0ba1032bSAndrew Rist *
23*0ba1032bSAndrew Rist ***********************************************************-->
24*0ba1032bSAndrew Rist
25*0ba1032bSAndrew Rist
26cdf0e10cSrcweir
27cdf0e10cSrcweir
28cdf0e10cSrcweir<meta>
29cdf0e10cSrcweir      <topic id="textsharedoptionen01060500xml" indexer="include" status="PUBLISH">
30cdf0e10cSrcweir         <title xml-lang="en-US" id="tit">Calculate</title>
31cdf0e10cSrcweir         <filename>/text/shared/optionen/01060500.xhp</filename>
32cdf0e10cSrcweir      </topic>
33cdf0e10cSrcweir   </meta>
34cdf0e10cSrcweir   <body>
35cdf0e10cSrcweir      <section id="berechnen">
36cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3149399"><bookmark_value>references; iterative (Calc)</bookmark_value>
37cdf0e10cSrcweir         <bookmark_value>calculating;iterative references (Calc)</bookmark_value>
38cdf0e10cSrcweir         <bookmark_value>iterative references in spreadsheets</bookmark_value>
39cdf0e10cSrcweir         <bookmark_value>recursions in spreadsheets</bookmark_value>
40cdf0e10cSrcweir         <bookmark_value>dates; default (Calc)</bookmark_value>
41cdf0e10cSrcweir         <bookmark_value>dates; start 1900/01/01 (Calc)</bookmark_value>
42cdf0e10cSrcweir         <bookmark_value>dates; start 1904/01/01 (Calc)</bookmark_value>
43cdf0e10cSrcweir         <bookmark_value>case sensitivity;comparing cell contents (Calc)</bookmark_value>
44cdf0e10cSrcweir         <bookmark_value>decimal places displayed (Calc)</bookmark_value>
45cdf0e10cSrcweir         <bookmark_value>precision as shown (Calc)</bookmark_value>
46cdf0e10cSrcweir         <bookmark_value>values; rounded as shown (Calc)</bookmark_value>
47cdf0e10cSrcweir         <bookmark_value>rounding precision (Calc)</bookmark_value>
48cdf0e10cSrcweir         <bookmark_value>search criteria for database functions in cells</bookmark_value>
49cdf0e10cSrcweir         <bookmark_value>Excel; search criteria</bookmark_value>
50cdf0e10cSrcweir</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>
51cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_SCPAGE_CALC" id="bm_id3149095" localize="false"/>
52cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3145071" role="heading" level="1" l10n="U" oldref="1"><link href="text/shared/optionen/01060500.xhp" name="Calculate">Calculate</link></paragraph>
53cdf0e10cSrcweir         <paragraph xml-lang="en-US" id="par_id3147576" role="paragraph" l10n="CHG" oldref="2"><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>
54cdf0e10cSrcweir      </section>
55cdf0e10cSrcweir      <section id="howtoget">
56cdf0e10cSrcweir         <embed href="text/shared/00/00000406.xhp#exopbe"/>
57cdf0e10cSrcweir      </section>
58cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="hd_id3149399" role="heading" level="2" l10n="U" oldref="3">Iterative references</paragraph>
59cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3155419" role="paragraph" l10n="U" oldref="4">In this section you can delimit the number of approximation steps carried out during iterative calculations. In addition, you can specify the degree of precision of the answer.</paragraph>
60cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCPAGE_CALC:BTN_ITERATE" id="bm_id3156153" localize="false"/>
61cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3154142" role="heading" level="3" l10n="U" oldref="5">Iterations</paragraph>
62cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3149795" role="paragraph" l10n="U" oldref="6"><ahelp hid="SC:CHECKBOX:RID_SCPAGE_CALC:BTN_ITERATE">Specifies whether formulas with iterative references (formulas that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions.</ahelp> If the<emph> Iterations </emph>box is not marked, an iterative reference in the table will cause an error message.</paragraph>
63cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3148686" role="paragraph" l10n="CHG" oldref="7">
64cdf0e10cSrcweir         <emph>Example:</emph> calculating the cost of an item without the value-added tax.</paragraph>
65cdf0e10cSrcweir      <list type="ordered">
66cdf0e10cSrcweir         <listitem>
67cdf0e10cSrcweir            <paragraph xml-lang="en-US" id="par_id3156155" role="listitem" l10n="U" oldref="8">Type the text 'Selling price' in cell A5, the text 'Net' in cell A6, and the text 'Value-added tax' in cell A7.</paragraph>
68cdf0e10cSrcweir         </listitem>
69cdf0e10cSrcweir         <listitem>
70cdf0e10cSrcweir            <paragraph xml-lang="en-US" id="par_id3147530" role="listitem" l10n="U" oldref="61">Now type a selling price (for example, 100) in cell B5. The net price should be shown in cell B6 and the value-added tax should be shown in cell B7. </paragraph>
71cdf0e10cSrcweir         </listitem>
72cdf0e10cSrcweir         <listitem>
73cdf0e10cSrcweir            <paragraph xml-lang="en-US" id="par_id3153061" role="listitem" l10n="CHG" oldref="62">You know that the value-added tax is calculated as 'net price times 15%' and that you arrive at the net price by deducting the value-added tax from the selling price. Type the formula <item type="literal">=B5-B7</item> in B6 to calculate the net price, and type the formula <item type="literal">=B6*0.15</item> in cell B7 to calculate the value-added tax.</paragraph>
74cdf0e10cSrcweir         </listitem>
75cdf0e10cSrcweir         <listitem>
76cdf0e10cSrcweir            <paragraph xml-lang="en-US" id="par_id3154760" role="listitem" l10n="U" oldref="63">Switch on the iterations to correctly calculate the formulas, otherwise a 'Circular reference' error message appears in the <emph>Status</emph> Bar.</paragraph>
77cdf0e10cSrcweir         </listitem>
78cdf0e10cSrcweir      </list>
79cdf0e10cSrcweir      <table id="tbl_id3149669">
80cdf0e10cSrcweir         <tablerow>
81cdf0e10cSrcweir            <tablecell>
82cdf0e10cSrcweir</tablecell>
83cdf0e10cSrcweir            <tablecell>
84cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3154365" role="paragraph" l10n="U" oldref="9">A</paragraph>
85cdf0e10cSrcweir            </tablecell>
86cdf0e10cSrcweir            <tablecell>
87cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3145606" role="paragraph" l10n="U" oldref="10">B</paragraph>
88cdf0e10cSrcweir            </tablecell>
89cdf0e10cSrcweir         </tablerow>
90cdf0e10cSrcweir         <tablerow>
91cdf0e10cSrcweir            <tablecell>
92cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3149202" role="paragraph" l10n="U" oldref="11">5</paragraph>
93cdf0e10cSrcweir            </tablecell>
94cdf0e10cSrcweir            <tablecell>
95cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3151041" role="paragraph" l10n="U" oldref="12">Selling Price</paragraph>
96cdf0e10cSrcweir            </tablecell>
97cdf0e10cSrcweir            <tablecell>
98cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3159149" role="paragraph" l10n="U" oldref="13">100</paragraph>
99cdf0e10cSrcweir            </tablecell>
100cdf0e10cSrcweir         </tablerow>
101cdf0e10cSrcweir         <tablerow>
102cdf0e10cSrcweir            <tablecell>
103cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3159254" role="paragraph" l10n="U" oldref="14">6</paragraph>
104cdf0e10cSrcweir            </tablecell>
105cdf0e10cSrcweir            <tablecell>
106cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3147317" role="paragraph" l10n="U" oldref="15">Net</paragraph>
107cdf0e10cSrcweir            </tablecell>
108cdf0e10cSrcweir            <tablecell>
109cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3147348" role="paragraph" l10n="U" oldref="16">=B5-B7</paragraph>
110cdf0e10cSrcweir            </tablecell>
111cdf0e10cSrcweir         </tablerow>
112cdf0e10cSrcweir         <tablerow>
113cdf0e10cSrcweir            <tablecell>
114cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3154918" role="paragraph" l10n="U" oldref="17">7</paragraph>
115cdf0e10cSrcweir            </tablecell>
116cdf0e10cSrcweir            <tablecell>
117cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3153573" role="paragraph" l10n="U" oldref="18">Tax</paragraph>
118cdf0e10cSrcweir            </tablecell>
119cdf0e10cSrcweir            <tablecell>
120cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3154319" role="paragraph" l10n="U" oldref="19">=B6*0,15</paragraph>
121cdf0e10cSrcweir            </tablecell>
122cdf0e10cSrcweir         </tablerow>
123cdf0e10cSrcweir      </table>
124cdf0e10cSrcweir
125cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:NumericField:RID_SCPAGE_CALC:ED_STEPS" id="bm_id3146119" localize="false"/>
126cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3145750" role="heading" level="3" l10n="U"
127cdf0e10cSrcweir                 oldref="22">Steps</paragraph>
128cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3152576" role="paragraph" l10n="U" oldref="23"><ahelp hid="SC:NUMERICFIELD:RID_SCPAGE_CALC:ED_STEPS">Sets the maximum number of iteration steps.</ahelp></paragraph>
129cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCPAGE_CALC:ED_EPS" id="bm_id3145273" localize="false"/>
130cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153728" role="heading" level="3" l10n="U"
131cdf0e10cSrcweir                 oldref="24">Minimum Change</paragraph>
132cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3153139" role="paragraph" l10n="CHG" oldref="25"><ahelp hid="SC:EDIT:RID_SCPAGE_CALC:ED_EPS">Specifies the difference between two consecutive iteration step results. If the result of the iteration is lower than the minimum change value, then the iteration will stop.</ahelp></paragraph>
133cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="hd_id3147125" role="heading" level="2" l10n="U"
134cdf0e10cSrcweir                 oldref="45">Date</paragraph>
135cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3155416" role="paragraph" l10n="U" oldref="46">Select the start date for the internal conversion from days to numbers.</paragraph>
136cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCPAGE_CALC:BTN_DATESTD" id="bm_id3153159" localize="false"/>
137cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3147396" role="heading" level="3" l10n="U"
138cdf0e10cSrcweir                 oldref="47">12/30/1899 (default)</paragraph>
139cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3145646" role="paragraph" l10n="U" oldref="48"><ahelp hid="SC:RADIOBUTTON:RID_SCPAGE_CALC:BTN_DATESTD">Sets 12/30/1899 as day zero.</ahelp></paragraph>
140cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCPAGE_CALC:BTN_DATESC10" id="bm_id3150715" localize="false"/>
141cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3156283" role="heading" level="3" l10n="U"
142cdf0e10cSrcweir                 oldref="49">01/01/1900 (StarCalc 1.0)</paragraph>
143cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3154018" role="paragraph" l10n="U" oldref="50"><ahelp hid="SC:RADIOBUTTON:RID_SCPAGE_CALC:BTN_DATESC10">Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries.</ahelp></paragraph>
144cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCPAGE_CALC:BTN_DATE1904" id="bm_id3147173" localize="false"/>
145cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3156181" role="heading" level="3" l10n="U"
146cdf0e10cSrcweir                 oldref="51">01/01/1904</paragraph>
147cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3153948" role="paragraph" l10n="U" oldref="52"><ahelp hid="SC:RADIOBUTTON:RID_SCPAGE_CALC:BTN_DATE1904">Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are imported in a foreign format.</ahelp></paragraph>
148cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCPAGE_CALC:BTN_CASE" id="bm_id3151205" localize="false"/>
149cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153838" role="heading" level="2" l10n="U"
150cdf0e10cSrcweir                 oldref="26">Case sensitive</paragraph>
151cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3146793" role="paragraph" l10n="U" oldref="27"><ahelp hid="SC:CHECKBOX:RID_SCPAGE_CALC:BTN_CASE">Specifies whether to distinguish between upper and lower case in texts when comparing cell contents.</ahelp></paragraph>
152cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3153707" role="paragraph" l10n="U" oldref="28">
153cdf0e10cSrcweir         <emph>Example:</emph> Type the text 'Test' in cell A1; and the text 'test' in B1. Then type the formula "=A1=B1" in cell C1. If the <emph>Case sensitive</emph> box is marked, FALSE will appear in the cell; otherwise, TRUE will appear in the cell.</paragraph>
154cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3153965" role="note" l10n="U" oldref="29">The EXACT text function is always case-sensitive, independent of the settings in this dialog.</paragraph>
155cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:NumericField:RID_SCPAGE_CALC:ED_PREC" id="bm_id3147362" localize="false"/>
156cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3145231" role="heading" level="2" l10n="U"
157cdf0e10cSrcweir                 oldref="53">Decimal places</paragraph>
158cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3149568" role="paragraph" l10n="CHG" oldref="54"><ahelp hid="SC:NUMERICFIELD:RID_SCPAGE_CALC:ED_PREC">Defines the number of decimals to be displayed for numbers with the <emph>Standard</emph> number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers.</ahelp></paragraph>
159cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCPAGE_CALC:BTN_CALC" id="bm_id3145766" localize="false"/>
160cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3145150" role="heading" level="2" l10n="U"
161cdf0e10cSrcweir                 oldref="30">Precision as shown</paragraph>
162cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3150644" role="paragraph" l10n="CHG" oldref="31"><ahelp hid="SC:CHECKBOX:RID_SCPAGE_CALC:BTN_CALC">Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the <emph>Precision as shown</emph> option is not marked, the displayed numbers are rounded, but they are calculated internally using the non-rounded number.</ahelp></paragraph>
163cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCPAGE_CALC:BTN_MATCH" id="bm_id3150364" localize="false"/>
164cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3152581" role="heading" level="2" l10n="U"
165cdf0e10cSrcweir                 oldref="32">Search criteria = and &lt;&gt; must apply to whole cells</paragraph>
166cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3149211" role="paragraph" l10n="CHG" oldref="33"><ahelp hid="SC:CHECKBOX:RID_SCPAGE_CALC:BTN_MATCH">Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When the <emph>Search criteria = and &lt;&gt; must apply to whole cells</emph> box is marked, $[officename] Calc behaves exactly as MS Excel when searching cells in the database functions.</ahelp></paragraph>
167cdf0e10cSrcweir      <table id="tbl_id3149814">
168cdf0e10cSrcweir         <tablerow>
169cdf0e10cSrcweir            <tablecell>
170cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3148422" role="tablehead" l10n="U" oldref="34">.* in following position:</paragraph>
171cdf0e10cSrcweir            </tablecell>
172cdf0e10cSrcweir            <tablecell>
173cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3156139" role="tablehead" l10n="U" oldref="35">Search result:</paragraph>
174cdf0e10cSrcweir            </tablecell>
175cdf0e10cSrcweir         </tablerow>
176cdf0e10cSrcweir         <tablerow>
177cdf0e10cSrcweir            <tablecell>
178cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3150979" role="tablecontent" l10n="U" oldref="36">win</paragraph>
179cdf0e10cSrcweir            </tablecell>
180cdf0e10cSrcweir            <tablecell>
181cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3159239" role="tablecontent" l10n="U" oldref="37">Finds win, but not win95, os2win, or upwind</paragraph>
182cdf0e10cSrcweir            </tablecell>
183cdf0e10cSrcweir         </tablerow>
184cdf0e10cSrcweir         <tablerow>
185cdf0e10cSrcweir            <tablecell>
186cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3153782" role="tablecontent" l10n="U" oldref="38">win.*</paragraph>
187cdf0e10cSrcweir            </tablecell>
188cdf0e10cSrcweir            <tablecell>
189cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3151278" role="tablecontent" l10n="U" oldref="39">Finds win and win95, but not os2win or upwind</paragraph>
190cdf0e10cSrcweir            </tablecell>
191cdf0e10cSrcweir         </tablerow>
192cdf0e10cSrcweir         <tablerow>
193cdf0e10cSrcweir            <tablecell>
194cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3155506" role="tablecontent" l10n="U" oldref="40">.*win</paragraph>
195cdf0e10cSrcweir            </tablecell>
196cdf0e10cSrcweir            <tablecell>
197cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3150886" role="tablecontent" l10n="U" oldref="41">Finds win and os2win, but not win95 or upwind</paragraph>
198cdf0e10cSrcweir            </tablecell>
199cdf0e10cSrcweir         </tablerow>
200cdf0e10cSrcweir         <tablerow>
201cdf0e10cSrcweir            <tablecell>
202cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3147167" role="tablecontent" l10n="U" oldref="42">.*win.*</paragraph>
203cdf0e10cSrcweir            </tablecell>
204cdf0e10cSrcweir            <tablecell>
205cdf0e10cSrcweir               <paragraph xml-lang="en-US" id="par_id3152985" role="tablecontent" l10n="U" oldref="43">Finds win, win95, os2win, and upwind</paragraph>
206cdf0e10cSrcweir            </tablecell>
207cdf0e10cSrcweir         </tablerow>
208cdf0e10cSrcweir      </table>
209cdf0e10cSrcweir
210cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3148814" role="paragraph" l10n="U" oldref="44">If <emph>Search criteria = and &lt;&gt; must apply to whole cells </emph>is not enabled, the "win" search pattern acts like ".*win.*". The search pattern can be at any position within the cell when searching with the Calc database functions.</paragraph>
211cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCPAGE_CALC:BTN_REGEX" id="bm_id3154419" localize="false"/>
212cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3156448" role="heading" level="2" l10n="U"
213cdf0e10cSrcweir                 oldref="58">Enable regular expressions in formulas</paragraph>
214cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3155092" role="paragraph" l10n="U" oldref="59"><ahelp hid="SC_CHECKBOX_RID_SCPAGE_CALC_BTN_REGEX">Specifies that regular expressions 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 and SEARCH.
215cdf0e10cSrcweir</caseinline></switchinline><comment>Sorry, no more switches allowed inside AVIS tags</comment></paragraph>
216cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCPAGE_CALC:BTN_LOOKUP" id="bm_id3152901" localize="false"/>
217cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3156199" role="heading" level="2" l10n="U"
218cdf0e10cSrcweir                 oldref="55">Automatically find column and row labels</paragraph>
219cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3153818" role="paragraph" l10n="CHG" oldref="56"><ahelp hid="SC:CHECKBOX:RID_SCPAGE_CALC:BTN_LOOKUP">Specifies that you can use the text in any cell as a label for the column below the text or the row to the right of the text. The text must consist of at least one word and must not contain any operators.</ahelp></paragraph>
220cdf0e10cSrcweir      <paragraph xml-lang="en-US" id="par_id3151242" role="paragraph" l10n="U" oldref="57">
221cdf0e10cSrcweir         <emph>Example</emph>: Cell E5 contains the text "Europe". Below, in cell E6, is the value 100 and in cell E7 the value 200. If the <emph>Automatically find column and row labels</emph> box is marked, you can write the following formula in cell A1: =SUM(Europe).</paragraph>
222cdf0e10cSrcweir
223cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCPAGE_CALC:BTN_GENERAL_PREC" id="bm_id315342901" localize="false"/>
224cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:NumericField:RID_SCPAGE_CALC:ED_PREC" id="bm_id315442901" localize="false"/>
225cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id315634199" role="heading" level="2" l10n="NEW">Limit decimals for general number format</paragraph>
226cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id315343818" role="paragraph" l10n="NEW"><ahelp hid=".">You can specify the maximum number of decimal places that are shown by default for cells with General number format. If not enabled, cells with General number format show as many decimal places as the column width allows.</ahelp></paragraph>
227cdf0e10cSrcweir
228cdf0e10cSrcweir</body>
229cdf0e10cSrcweir</helpdocument>