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 9e3b7724fd..563494411f 100644 --- a/source/text/shared/optionen/01060500.xhp +++ b/source/text/shared/optionen/01060500.xhp @@ -148,7 +148,7 @@ <paragraph id="par_id3150644" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/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> <bookmark branch="hid/modules/scalc/ui/optcalculatepage/match" id="bm_id3150364" localize="false"/> <h2 id="hd_id3152581">Search criteria = and <> must apply to whole cells</h2> - <paragraph id="par_id3149211" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/match">Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When both, the <emph>Search criteria = and <> must apply to whole cells</emph> box and the <emph>Enable wildcards in formulas</emph> box are marked, $[officename] Calc behaves exactly as Microsoft Excel when searching cells in the database functions.</ahelp></paragraph> + <paragraph id="par_id3149211" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/match">Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When both, the <emph>Search criteria = and <> must apply to whole cells</emph> box and the <emph>Enable wildcards in formulas</emph> box are marked, $[officename] Calc behaves exactly as Microsoft Excel when searching cells in the database functions.</ahelp></paragraph> <table id="tbl_id3149814"> <tablerow> <tablecell> @@ -227,9 +227,9 @@ <bookmark branch="hid/modules/scalc/ui/optcalculatepage/lookup" id="bm_id3152901" localize="false"/> <h2 id="hd_id3156199">Automatically find column and row labels</h2> - <paragraph id="par_id3153818" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/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> - <paragraph id="par_id3151242" role="paragraph"> - <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> +<paragraph id="par_id3153818" role="paragraph"><ahelp hid="modules/scalc/ui/optcalculatepage/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> +<paragraph id="par_id3151242" role="paragraph"><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> +<paragraph role="paragraph" id="par_id101713445258305">For more information, see <link href="text/scalc/guide/address_auto.xhp">Recognizing Names as Addressing</link>.</paragraph> <bookmark branch="hid/modules/scalc/ui/optcalculatepage/generalprec" id="bm_id315342901" localize="false"/> <h2 id="hd_id315634199">Limit decimals for general number format</h2> |