diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-04-28 14:50:14 -0300 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2023-04-28 23:19:53 +0200 |
| commit | cac49fecf0b35af451fd0e043b21f86a8a46b38d (patch) | |
| tree | 9163c5eda85c3cee8212363e74f3e89796f151ef /source | |
| parent | c8a6e326f6207982fd507161d48f7793cfe82c26 (diff) | |
tdf#139027 More on INDEX() function
+ Review after erack comments
Change-Id: Ibc294c35dd98cbd5c9f2b638db4e9cf31e768edd
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/151175
Tested-by: Jenkins
Reviewed-by: Eike Rathke <erack@redhat.com>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 8cc30c75f9..fe95792bbd 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -175,11 +175,13 @@ </bookmark> <bookmark branch="hid/SC_HID_FUNC_INDEX" id="bm_id3157989" localize="false"/> <h2 id="hd_id3151221">INDEX</h2> -<paragraph id="par_id3150268" role="paragraph"><ahelp hid="HID_FUNC_INDEX">INDEX returns a value or an array of values from a reference range, specified by row and column index number or array of row and array of columns index numbers, and an optional range index.</ahelp></paragraph> + <paragraph id="par_id3150268" role="paragraph"><ahelp hid="HID_FUNC_INDEX">INDEX returns a reference, a value or an array of values from a reference range, specified by row and column index number or array of row and array of columns index numbers, and an optional range index.</ahelp></paragraph> + + <paragraph role="paragraph" id="par_id901682701069280">INDEX() returns a reference if the argument is one or more references. When used in a cell in the form =INDEX(), the reference is resolved and the values displayed. When INDEX() is used in arguments of other functions, =FUNCTION(INDEX()...), the function gets the reference passed that was returned by INDEX(). Returning a reference is different from returning an array of values for functions that handles them differently.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3149007" role="code">INDEX(Reference [; [Row] [; [Column] [; Range]]])</paragraph> - <paragraph id="par_id3153260" role="paragraph"> - <emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the list of references or range names in parentheses, or use the tilde (~) <link href="text/scalc/01/04060199.xhp#referenceoperators">range concatenation operator</link>.</paragraph> + <paragraph id="par_id3153260" role="paragraph"><emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the list of references or range names in parentheses, or either use the tilde (~) <link href="text/scalc/01/04060199.xhp#referenceoperators">range concatenation operator</link> or define a named range with multiple areas.</paragraph> <paragraph id="par_id3145302" role="paragraph"> <emph>Row</emph> (optional) represents the row or the array of row indexes of the reference range, for which to return a value. In case of zero or omitted (no specific row) all referenced rows are returned.</paragraph> <paragraph id="par_id3154628" role="paragraph"> |