summaryrefslogtreecommitdiff
path: root/source/text/scalc
diff options
context:
space:
mode:
authorJohnny_M <klasse@partyheld.de>2021-11-13 14:36:46 +0100
committerOlivier Hallot <olivier.hallot@libreoffice.org>2021-11-16 09:47:26 +0100
commit7713a240a73b3ac5cc369d53cc6c968b7f669a16 (patch)
tree41b8e30605dc8eaf5125abaacb06e3836d02dc7a /source/text/scalc
parentf04dd65cd08f3ee1319d2722816ff88d75d42b68 (diff)
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.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
-rw-r--r--source/text/scalc/01/04060107.xhp2
-rw-r--r--source/text/scalc/01/04060109.xhp4
2 files changed, 3 insertions, 3 deletions
diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp
index 4a7b7592f7..86514c4116 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 2a8ff6cd9e..8457ba3f3c 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">