summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060109.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'source/text/scalc/01/04060109.xhp')
-rw-r--r--source/text/scalc/01/04060109.xhp4
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index 8c9688f76..109fbb42c 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -205,13 +205,13 @@
<paragraph xml-lang="en-US" id="par_id3159112" role="paragraph" l10n="U" oldref="56">
<item type="input">=INDEX(Prices;4;1)</item> returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>.</paragraph>
<paragraph xml-lang="en-US" id="par_id3150691" role="paragraph" l10n="U" oldref="57">
- <item type="input">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Insert - Names - Define</emph>.</paragraph>
+ <item type="input">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Sheet - Named Ranges and Expressions - Define</emph>.</paragraph>
<paragraph xml-lang="en-US" id="par_id4109012" role="paragraph" l10n="NEW">
<item type="input">=INDEX(A1:B6;1)</item> returns a reference to the first row of A1:B6.</paragraph>
<paragraph xml-lang="en-US" id="par_id9272133" role="paragraph" l10n="NEW">
<item type="input">=INDEX(A1:B6;0;1)</item> returns a reference to the first column of A1:B6.</paragraph>
<paragraph xml-lang="en-US" id="par_id3158419" role="paragraph" l10n="U" oldref="58">
- <item type="input">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Insert - Names - Define</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type="input">2</item> as the <emph>range</emph> parameter.</paragraph>
+ <item type="input">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Sheet - Named Ranges and Expressions - Define</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type="input">2</item> as the <emph>range</emph> parameter.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148595" role="paragraph" l10n="U" oldref="59">
<item type="input">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range.</paragraph>
<paragraph xml-lang="en-US" id="par_id9960020" role="paragraph" l10n="NEW">