source/text/scalc/01/04060109.xhp | 4 +++- source/text/scalc/01/func_choosecols.xhp | 5 ++++- source/text/scalc/01/func_chooserows.xhp | 5 +++-- 3 files changed, 10 insertions(+), 4 deletions(-)
New commits: commit b0ff87d9fbdb460e5abecc43cca3dbeccdfd2bcd Author: Olivier Hallot <[email protected]> AuthorDate: Wed Jan 7 12:51:49 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Wed Jan 7 16:56:30 2026 +0100 Add info for CHOOSECOLS, CHOOSEROWS and INDEX Change-Id: If8c6a8abb66e0b3974ae0b774a68579408b4306d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/196779 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 34cdfef0d7..4dce5280b9 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -174,7 +174,7 @@ <bookmark branch="index" id="bm_id3151221"><bookmark_value>INDEX function</bookmark_value> </bookmark> <bookmark branch="hid/SC_HID_FUNC_INDEX" id="bm_id3157989" localize="false"/> -<h2 id="hd_id3151221">INDEX</h2> +<h2 id="hd_id3151221"><variable id="indexh1"><link href="text/scalc/01/04060109.xhp#Section5">INDEX</link></variable></h2> <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> @@ -205,6 +205,8 @@ <paragraph id="par_id9960020" role="paragraph"> <input>{=INDEX((A1:B6;C1:D6);0;0;2)}</input> returns the values of the second range C1:D6 of the multiple range. Enter the formula as an <link href="text/scalc/01/04060107.xhp">array formula</link>.</paragraph> <section id="relatedtopics"> + <embed href="text/scalc/01/func_choosecols.xhp#h1"/> + <embed href="text/scalc/01/func_chooserows.xhp#h1"/> <tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDEX";>INDEX wiki page</link>.</tip> </section> </section> diff --git a/source/text/scalc/01/func_choosecols.xhp b/source/text/scalc/01/func_choosecols.xhp index fb82eba5a2..3455cdd92a 100644 --- a/source/text/scalc/01/func_choosecols.xhp +++ b/source/text/scalc/01/func_choosecols.xhp @@ -22,7 +22,7 @@ </bookmark> <section id="choosecols"> <h1 id="hd_id901708806478126"><variable id="h1"><link href="text/scalc/01/func_choosecols.xhp">CHOOSECOLS</link></variable></h1> - <paragraph id="par_id771708806478128" role="paragraph">Returns the specified columns from an array.</paragraph> + <description id="par_id771708806478128">Returns the specified columns from an array.</description> </section> <embed href="text/scalc/01/common_func.xhp#array"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> @@ -71,11 +71,14 @@ </tablerow> </table> +<tip id="par_id991767800254154">CHOOSECOLS(Array; Column<sub>n</sub>) is equivalent to INDEX(Array; ; Column<sub>n</sub>).</tip> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/00/avail_release.xhp#25.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.CHOOSECOLS</literal></paragraph> <section id="relatedtopics"> + <embed href="text/scalc/01/04060109.xhp#indexh1"/> <embed href="text/scalc/01/func_tocol.xhp#h1"/> <embed href="text/scalc/01/func_torow.xhp#h1"/> <embed href="text/scalc/01/func_wrapcols.xhp#h1"/> diff --git a/source/text/scalc/01/func_chooserows.xhp b/source/text/scalc/01/func_chooserows.xhp index 830370882c..fc284f50ea 100644 --- a/source/text/scalc/01/func_chooserows.xhp +++ b/source/text/scalc/01/func_chooserows.xhp @@ -22,7 +22,7 @@ </bookmark> <section id="chooserows"> <h1 id="hd_id901708806478126"><variable id="h1"><link href="text/scalc/01/func_chooserows.xhp">CHOOSEROWS</link></variable></h1> - <paragraph id="par_id771708806478128" role="paragraph">Returns the specified rows from an array.</paragraph> + <description id="par_id771708806478128">Returns the specified rows from an array.</description> </section> <embed href="text/scalc/01/common_func.xhp#array"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> @@ -71,12 +71,13 @@ <tablecell><paragraph id="par_id51738976617144" role="tablecontent" localize="false">OOO</paragraph></tablecell> </tablerow> </table> - +<tip id="par_id991767800254154">CHOOSEROWS(Array; Row<sub>n</sub>) is equivalent to INDEX(Array; Row<sub>n</sub>).</tip> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/00/avail_release.xhp#25.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.CHOOSEROWS</literal></paragraph> <section id="relatedtopics"> + <embed href="text/scalc/01/04060109.xhp#indexh1"/> <embed href="text/scalc/01/func_tocol.xhp#h1"/> <embed href="text/scalc/01/func_torow.xhp#h1"/> <embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
