source/text/scalc/01/04070400.xhp | 2 -
source/text/scalc/guide/address_auto.xhp | 26 +++++++++---------
source/text/scalc/guide/value_with_name.xhp | 40 ++++++++++++++--------------
source/text/shared/optionen/01060500.xhp | 8 ++---
4 files changed, 38 insertions(+), 38 deletions(-)
New commits:
commit 9e32990654d9b4ad397f6e0d21973483b1bf47f9
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu Apr 18 10:13:15 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Apr 18 16:38:36 2024 +0200
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.hal...@libreoffice.org>
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>
