source/text/scalc/guide/address_auto.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 761a64f3ca3e8f66c711bcadaa8c5ced105a99cd
Author: Stanislav Horacek <stanislav.hora...@gmail.com>
AuthorDate: Mon May 6 20:22:17 2024 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu May 9 01:52:46 2024 +0200
fix row/column type of labels in description of their recognizing
Change-Id: I4b9dcd95b432aea717eeb017fc94fa02a3bc84d5
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/167247
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/guide/address_auto.xhp
b/source/text/scalc/guide/address_auto.xhp
index f14b44d2f8..c946f723f0 100644
--- a/source/text/scalc/guide/address_auto.xhp
+++ b/source/text/scalc/guide/address_auto.xhp
@@ -43,7 +43,7 @@
<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">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 role="paragraph" id="par_id81713445694889">If the resulting cell is
below or above another cell containing text, %PRODUCTNAME Calc assumes the text
as a column label, else %PRODUCTNAME Calc assumes the text as a row
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>
