diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-04-18 10:13:15 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-04-18 16:38:36 +0200 |
| commit | 9e32990654d9b4ad397f6e0d21973483b1bf47f9 (patch) | |
| tree | 02f96ed01b37d51d85ec0c5d544f3f0dea325f9b | |
| parent | tdf#130185 Clarify font embedding properties. (diff) | |
| download | help-9e32990654d9b4ad397f6e0d21973483b1bf47f9.tar.gz help-9e32990654d9b4ad397f6e0d21973483b1bf47f9.zip | |
tdf#86427 automatic label detection explanation
+ refactor a warning and cross-link between option pages and guide.
Change-Id: I0f337c4999d41a96355422540da4d173f02b5a21
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/166252
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/01/04070400.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/address_auto.xhp | 26 | ||||
| -rw-r--r-- | source/text/scalc/guide/value_with_name.xhp | 40 | ||||
| -rw-r--r-- | source/text/shared/optionen/01060500.xhp | 8 |
4 files changed, 38 insertions, 38 deletions
diff --git a/source/text/scalc/01/04070400.xhp b/source/text/scalc/01/04070400.xhp index 60fef5b4a8..781a3f465d 100644 --- a/source/text/scalc/01/04070400.xhp +++ b/source/text/scalc/01/04070400.xhp @@ -35,7 +35,7 @@ <bookmark branch="hid/modules/scalc/ui/namerangesdialog/@@nowidget@@" id="bm_id3150447" localize="false"/> <section id="define_label_range"> - <h1 id="hd_id3150791"><link href="text/scalc/01/04070400.xhp">Define Label Range</link></h1> + <h1 id="hd_id3150791"><variable id="h1"><link href="text/scalc/01/04070400.xhp">Define Label Range</link></variable></h1> <paragraph role="paragraph" id="par_id3150868"><variable id="beschtext"><ahelp hid=".uno:DefineLabelRange">Opens a dialog in which you can define a label range.</ahelp></variable></paragraph> </section> diff --git a/source/text/scalc/guide/address_auto.xhp b/source/text/scalc/guide/address_auto.xhp index dfccbc2aee..f14b44d2f8 100644 --- a/source/text/scalc/guide/address_auto.xhp +++ b/source/text/scalc/guide/address_auto.xhp @@ -20,14 +20,13 @@ <meta> <topic id="textscalcguideaddress_autoxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Recognizing Names as Addressing</title> + <title id="tit">Recognizing Names as Addressing</title> <filename>/text/scalc/guide/address_auto.xhp</filename> </topic> </meta> <body> - -<bookmark xml-lang="en-US" branch="index" id="bm_id3148797"> +<bookmark branch="index" id="bm_id3148797"> <bookmark_value>automatic addressing in tables</bookmark_value> <bookmark_value>natural language addressing</bookmark_value> <bookmark_value>formulas; using row/column labels</bookmark_value> @@ -43,18 +42,19 @@ <comment>mw changes "names;..." entry to "text in cells;..."</comment><comment>mw inserted three index entries from text/shared/optionen/01060500.xhp. Changed "finding;..." entry to "recognizing;..." entry. Adding (Calc) is no longer necessary in this file.</comment> <h1 id="hd_id3148797"><variable id="address_auto"><link href="text/scalc/guide/address_auto.xhp">Recognizing Names as Addressing</link></variable></h1> -<paragraph id="par_id3152597" role="paragraph" xml-lang="en-US">You can use cells with text to refer to the rows or to the columns that contain the cells.</paragraph><comment>removed table as a workaround for issue 108715</comment> -<paragraph id="par_id3156283" role="paragraph" xml-lang="en-US"><image id="img_id3154942" src="media/helpimg/names_as_addressing.png" width="5.408cm" height="2.212cm" localize="true"><alt xml-lang="en-US" id="alt_id3154942">Example spreadsheet</alt></image></paragraph> -<paragraph id="par_id3154512" role="paragraph" xml-lang="en-US">In the example spreadsheet, you can use the string <item type="literal">'Column One'</item> in a formula to refer to the cell range <item type="literal">B3</item> to <item type="literal">B5</item>, or <item type="literal">'Column Two'</item> for the cell range <item type="literal">C2</item> to <item type="literal">C5</item>. You can also use <item type="literal">'Row One'</item> for the cell range <item type="literal">B3</item> to <item type="literal">D3</item>, or <item type="literal">'Row Two'</item> for the cell range <item type="literal">B4</item> to <item type="literal">D4</item>. The result of a formula that uses a cell name, for example, <item type="literal">SUM('Column One')</item>, is 600.</paragraph> -<paragraph id="par_id3155443" role="paragraph" xml-lang="en-US">Automatically finding labels is a legacy feature and deactivated by default as it can produce nondeterministic behavior depending on actual document content. To turn this function on, choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Calculate</emph> and mark the <emph>Automatically find column and row labels</emph> check box.</paragraph> -<paragraph id="par_id3155444" role="paragraph" xml-lang="en-US">Using defined labels instead is always possible and behaves similar but in a defined way.</paragraph> -<paragraph id="par_id3149210" role="tip" xml-lang="en-US">If you enter a label name in the formula yourself, enclose the name in single quotation marks ('). If a single quotation mark appears in a name, you must double it, for example, <item type="literal">'Harry''s Bar'</item>.</paragraph> +<paragraph id="par_id3152597" role="paragraph">You can use cells with text to refer to the rows or to the columns that contain the cells.</paragraph><comment>removed table as a workaround for issue 108715</comment> +<paragraph role="paragraph" id="par_id81713445694889">If the resulting cell is below or above another cell containing text, %PRODUCTNAME Calc assumes the text as a row label, else %PRODUCTNAME Calc assumes the text as a column label.</paragraph> +<paragraph id="par_id3156283" role="paragraph"><image id="img_id3154942" src="media/helpimg/names_as_addressing.png" width="380px" height="150px" localize="true"><alt id="alt_id3154942">Example spreadsheet</alt></image></paragraph> +<paragraph id="par_id3154512" role="paragraph">In the example spreadsheet, you can use the string <item type="literal">'Column One'</item> in a formula to refer to the cell range <item type="literal">B3</item> to <item type="literal">B5</item>, or <item type="literal">'Column Two'</item> for the cell range <item type="literal">C2</item> to <item type="literal">C5</item>. You can also use <item type="literal">'Row One'</item> for the cell range <item type="literal">B3</item> to <item type="literal">D3</item>, or <item type="literal">'Row Two'</item> for the cell range <item type="literal">B4</item> to <item type="literal">D4</item>. The result of a formula that uses a cell name, for example, <item type="literal">SUM('Column One')</item>, is 600.</paragraph> +<warning id="par_id3155443">Automatically finding labels is a legacy feature and deactivated by default as it can produce nondeterministic behavior depending on actual document content. To turn this function on, choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Calculate</emph> and mark the <emph>Automatically find column and row labels</emph> check box.</warning> +<paragraph id="par_id3155444" role="paragraph">Using defined labels instead is always possible and behaves similar but in a defined way.</paragraph> +<tip id="par_id3149210">If you enter a label name in the formula yourself, enclose the name in single quotation marks ('). If a single quotation mark appears in a name, you must double it, for example, <item type="literal">'Harry''s Bar'</item>.</tip> <section id="relatedtopics"><comment>mw changed reference to deleted Calc guide address_byname.xhp to refer to Calc guide value_with_name.xhp</comment><comment>UFI: changed embedvar links to embed links</comment> -<embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/> -<embed href="text/scalc/01/04070400.xhp#define_label_range"/> -<embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> + <paragraph role="paragraph" id="par_id671713443783478" localize="false"><embedvar href="text/scalc/guide/value_with_name.xhp#value_with_name" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id21713443788358" localize="false"><embedvar href="text/scalc/01/04070400.xhp#h1" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id61713443792677" localize="false"><embedvar href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref" markup="ignore"/></paragraph> </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/scalc/guide/value_with_name.xhp b/source/text/scalc/guide/value_with_name.xhp index 2b706ad593..e7d5017021 100644 --- a/source/text/scalc/guide/value_with_name.xhp +++ b/source/text/scalc/guide/value_with_name.xhp @@ -22,12 +22,12 @@ <meta> <topic id="textscalcguidevalue_with_namexml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Naming Cells</title> + <title id="tit">Naming Cells</title> <filename>/text/scalc/guide/value_with_name.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3147434"><bookmark_value>cells; defining names</bookmark_value> +<bookmark branch="index" id="bm_id3147434"><bookmark_value>cells; defining names</bookmark_value> <bookmark_value>names; defining for cells</bookmark_value> <bookmark_value>values; defining names</bookmark_value> <bookmark_value>constants definition</bookmark_value> @@ -41,43 +41,43 @@ <bookmark_value>allowed cell names</bookmark_value> <bookmark_value>renaming;cells</bookmark_value> </bookmark><comment>mw changed "names;...", "addressing;..." and "references,..." entries.</comment><comment>mw added "renaming;"</comment> -<paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1"><variable id="value_with_name"><link href="text/scalc/guide/value_with_name.xhp">Naming Cells</link> -</variable></paragraph> +<h1 id="hd_id3147434"><variable id="value_with_name"><link href="text/scalc/guide/value_with_name.xhp">Naming Cells</link> +</variable></h1> <h2 id="hd_id4391918">Allowed names</h2> - <paragraph xml-lang="en-US" id="par_id2129581" role="paragraph">Names in Calc can contain letters, numeric characters, and the underline character. Names must start with a letter or an underline character.</paragraph> - <paragraph xml-lang="en-US" id="par_id1120029" role="paragraph">Allowed special characters:</paragraph> + <paragraph id="par_id2129581" role="paragraph">Names in Calc can contain letters, numeric characters, and the underline character. Names must start with a letter or an underline character.</paragraph> + <paragraph id="par_id1120029" role="paragraph">Allowed special characters:</paragraph> <list type="unordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3362224" role="paragraph">underline (_) </paragraph> + <paragraph id="par_id3362224" role="paragraph">underline (_) </paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id328989" role="paragraph">Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell.</paragraph> - <paragraph xml-lang="en-US" id="par_id32898987" role="paragraph">Names must not start with the letters C or R followed by a number; also single characters C and R are not allowed as names. See the ADDRESS function for more information.</paragraph> - <paragraph xml-lang="en-US" id="par_id4769737" role="paragraph">Names for cell ranges must not include blanks. Blanks are allowed within names for sheets and documents.</paragraph> + <paragraph id="par_id328989" role="paragraph">Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell.</paragraph> + <paragraph id="par_id32898987" role="paragraph">Names must not start with the letters C or R followed by a number; also single characters C and R are not allowed as names. See the ADDRESS function for more information.</paragraph> + <paragraph id="par_id4769737" role="paragraph">Names for cell ranges must not include blanks. Blanks are allowed within names for sheets and documents.</paragraph> <h2 id="hd_id1226233">Naming cells and formulas</h2> - <paragraph xml-lang="en-US" id="par_id5489364" role="paragraph">A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as "=SUM(Start)". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces.</paragraph> - <paragraph xml-lang="en-US" id="par_id953398" role="paragraph">For example, it is much easier to read a formula for sales tax if you can write "= Amount * Tax_rate" instead of "= A5 * B12". In this case, you would name cell A5 "Amount" and cell B12 "Tax_rate."</paragraph> - <paragraph xml-lang="en-US" id="par_id4889675" role="paragraph">Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names,</paragraph> + <paragraph id="par_id5489364" role="paragraph">A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as "=SUM(Start)". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces.</paragraph> + <paragraph id="par_id953398" role="paragraph">For example, it is much easier to read a formula for sales tax if you can write "= Amount * Tax_rate" instead of "= A5 * B12". In this case, you would name cell A5 "Amount" and cell B12 "Tax_rate."</paragraph> + <paragraph id="par_id4889675" role="paragraph">Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names,</paragraph> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3153954" role="listitem">Select a cell or range of cells, then choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialog appears.</paragraph> + <paragraph id="par_id3153954" role="listitem">Select a cell or range of cells, then choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialog appears.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3156283" role="listitem">Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog.</paragraph> + <paragraph id="par_id3156283" role="listitem">Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id5774101" role="paragraph">You can also name other cell ranges in this dialog by entering the name in the field and then selecting the respective cells.</paragraph> - <paragraph xml-lang="en-US" id="par_id3154942" role="paragraph">If you type the name in a formula, after the first few characters entered you will see the entire name as a tip.</paragraph> + <paragraph id="par_id5774101" role="paragraph">You can also name other cell ranges in this dialog by entering the name in the field and then selecting the respective cells.</paragraph> + <paragraph id="par_id3154942" role="paragraph">If you type the name in a formula, after the first few characters entered you will see the entire name as a tip.</paragraph> <list type="unordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3154510" role="listitem">Press the Enter key in order to accept the name from the tip.</paragraph> + <paragraph id="par_id3154510" role="listitem">Press the Enter key in order to accept the name from the tip.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3150749" role="listitem">If more than one name starts with the same characters, you can scroll forward through all the names using the <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> <keycode>+ Tab keys</keycode> and backward using the <keycode>Shift +</keycode> <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> <keycode>+ Tab</keycode> keys.<comment>mw copied contents from Calc guide address_byname.xhp</comment></paragraph> + <paragraph id="par_id3150749" role="listitem">If more than one name starts with the same characters, you can scroll forward through all the names using the <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> <keycode>+ Tab keys</keycode> and backward using the <keycode>Shift +</keycode> <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> <keycode>+ Tab</keycode> keys.<comment>mw copied contents from Calc guide address_byname.xhp</comment></paragraph> </listitem> </list> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3153711" role="paragraph"><link href="text/scalc/01/04070100.xhp">Sheet - Named Ranges and Expressions - Define</link></paragraph> + <paragraph id="par_id3153711" role="paragraph"><link href="text/scalc/01/04070100.xhp">Sheet - Named Ranges and Expressions - Define</link></paragraph> <embed href="text/scalc/guide/goalseek.xhp#goalseek"/> <embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> <embed href="text/scalc/guide/address_auto.xhp#address_auto"/><comment>mw deleted one EMBED paragraph and copied two EMBED paragraphs from Calc guide address_byname.xhp</comment> 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> |