diff options
| author | Stanislav Horacek <stanislav.horacek@gmail.com> | 2024-05-06 20:22:17 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-05-09 01:52:46 +0200 |
| commit | 761a64f3ca3e8f66c711bcadaa8c5ced105a99cd (patch) | |
| tree | 4e12a9b5079df86a9b23b082803c13161cae75ae | |
| parent | 3bc0152a9ce77d7ac1c27331cc176cd80af96692 (diff) | |
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.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/guide/address_auto.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
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> |