source/text/scalc/01/04060107.xhp | 2 +-
source/text/scalc/01/04060109.xhp | 4 ++--
2 files changed, 3 insertions(+), 3 deletions(-)
New commits:
commit 7713a240a73b3ac5cc369d53cc6c968b7f669a16
Author: Johnny_M <kla...@partyheld.de>
AuthorDate: Sat Nov 13 14:36:46 2021 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Nov 16 09:47:26 2021 +0100
tdf#132643 Translate German section IDs
Change-Id: Id411b83ff1633c0c0122611ae2acc51f88b6e6a6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/125164
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060107.xhp
b/source/text/scalc/01/04060107.xhp
index 4a7b7592f..86514c411 100644
--- a/source/text/scalc/01/04060107.xhp
+++ b/source/text/scalc/01/04060107.xhp
@@ -117,7 +117,7 @@
<h2 id="hd_id3155588">Using Array Formulas in $[officename] Calc</h2>
<paragraph id="par_id3152876" role="paragraph" xml-lang="en-US">You can also
create a "normal" formula in which the reference range, such as parameters,
indicate an array formula. The result is obtained from the intersection of the
reference range and the rows or columns in which the formula is found. If there
is no intersection or if the range at the intersection covers several rows or
columns, a #VALUE! error message appears. The following example illustrates
this concept:</paragraph>
<h3 id="hd_id3151271">Creating Array Formulas</h3>
-<section id="somatrixformel">
+<section id="creating_array_formulas">
<paragraph id="par_id3149102" role="paragraph" xml-lang="en-US">If you
create an array formula using the <emph>Function Wizard</emph>, you must mark
the <emph>Array</emph> check box each time so that the results are returned in
an array. Otherwise, only the value in the upper-left cell of the array being
calculated is returned.</paragraph>
<paragraph id="par_id3153392" role="paragraph" xml-lang="en-US">If you enter
the array formula directly into the cell, you must use the key combination
<emph>Shift + </emph><switchinline select="sys"><caseinline
select="MAC"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>
+ Enter</emph> instead of the <emph>Enter</emph> key. Only then does the
formula become an array formula.</paragraph>
<note id="par_id3151120">Array formulas appear in braces in $[officename]
Calc. You cannot create array formulas by manually entering the braces.</note>
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 2a8ff6cd9..8457ba3f3 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -229,7 +229,7 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SPALTE" id="bm_id3156378"
localize="false"/>
<h2 id="hd_id3154818">COLUMN</h2>
- <paragraph xml-lang="en-US" id="par_id3149711"
role="paragraph"><ahelp hid="HID_FUNC_SPALTE">Returns the column number of a
cell reference.</ahelp> If the reference is a cell the column number of the
cell is returned; if the parameter is a cell area, the corresponding column
numbers are returned in a single-row <link
href="text/scalc/01/04060107.xhp#wasmatrix" name="array">array</link> if the
formula is entered <link href="text/scalc/01/04060107.xhp#somatrixformel"
name="as an array formula">as an array formula</link>. If the COLUMN function
with an area reference parameter is not used for an array formula, only the
column number of the first cell within the area is determined.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149711"
role="paragraph"><ahelp hid="HID_FUNC_SPALTE">Returns the column number of a
cell reference.</ahelp> If the reference is a cell the column number of the
cell is returned; if the parameter is a cell area, the corresponding column
numbers are returned in a single-row <link
href="text/scalc/01/04060107.xhp#wasmatrix" name="array">array</link> if the
formula is entered <link
href="text/scalc/01/04060107.xhp#creating_array_formulas" name="as an array
formula">as an array formula</link>. If the COLUMN function with an area
reference parameter is not used for an array formula, only the column number of
the first cell within the area is determined.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149447"
role="code">COLUMN([Reference])</paragraph>
<paragraph xml-lang="en-US" id="par_id3156310" role="paragraph">
@@ -588,7 +588,7 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEILE" id="bm_id3147333"
localize="false"/>
<h2 id="hd_id3147321">ROW</h2>
- <paragraph xml-lang="en-US" id="par_id3154564"
role="paragraph"><ahelp hid="HID_FUNC_ZEILE">Returns the row number of a cell
reference.</ahelp> If the reference is a cell, it returns the row number of the
cell. If the reference is a cell range, it returns the corresponding row
numbers in a one-column <link href="text/scalc/01/04060107.xhp#wasmatrix"
name="Array">Array</link> if the formula is entered <link
href="text/scalc/01/04060107.xhp#somatrixformel" name="as an array formula">as
an array formula</link>. If the ROW function with a range reference is not used
in an array formula, only the row number of the first range cell will be
returned.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3154564"
role="paragraph"><ahelp hid="HID_FUNC_ZEILE">Returns the row number of a cell
reference.</ahelp> If the reference is a cell, it returns the row number of the
cell. If the reference is a cell range, it returns the corresponding row
numbers in a one-column <link href="text/scalc/01/04060107.xhp#wasmatrix"
name="Array">Array</link> if the formula is entered <link
href="text/scalc/01/04060107.xhp#creating_array_formulas" name="as an array
formula">as an array formula</link>. If the ROW function with a range reference
is not used in an array formula, only the row number of the first range cell
will be returned.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3154916"
role="code">ROW([Reference])</paragraph>
<paragraph xml-lang="en-US" id="par_id3156336" role="paragraph">
