source/text/scalc/01/func_choosecols.xhp | 6 +++--- source/text/scalc/01/func_chooserows.xhp | 6 +++--- 2 files changed, 6 insertions(+), 6 deletions(-)
New commits: commit a2278aff0167edacbfd9767fe19e2dea01c7e79d Author: Olivier Hallot <[email protected]> AuthorDate: Wed Dec 31 12:19:56 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Wed Dec 31 21:53:32 2025 +0100 Add precision on indexes for CHOOSECOLS and CHOOSEROWS Change-Id: I4a73dcefbc0f7ad94e08d2ca0f5cbc125b21eaa4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/196369 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/scalc/01/func_choosecols.xhp b/source/text/scalc/01/func_choosecols.xhp index e5e88d73bf..fb82eba5a2 100644 --- a/source/text/scalc/01/func_choosecols.xhp +++ b/source/text/scalc/01/func_choosecols.xhp @@ -30,7 +30,9 @@ <paragraph role="paragraph" id="par_id81738076052161"><emph>Array</emph>: The array containing the columns to be returned in a new array.</paragraph> <paragraph role="paragraph" id="par_id191738076047602"><emph>Column_1</emph>: The index of the first column to be returned. A negative value chooses from the end of the array.</paragraph> <paragraph role="paragraph" id="par_id1001738076043608"><emph>Column_2; Column_3; ...</emph>: (optional) The list of other column indexes to be returned. A negative value chooses from the end of the array.</paragraph> -<embed href="text/scalc/01/common_func.xhp#optional_args"/> +<paragraph role="paragraph" id="par_id141767192556919">None of the value of <emph>Column_1; Column_2; ...</emph> can be zero.</paragraph> +<paragraph role="paragraph" id="par_id301767192606989">The absolute value of each of <emph>Column_1; Column_2; ...</emph> must be less than or equal to the number of columns of <emph>Array</emph>.</paragraph> +<tip id="par_id481738974778935">Use the function CHOOSECOLS to reorder the columns of an array. You can also replicate columns by repeating the column index.</tip> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/stat_data.xhp#tocolrowxmpl"/> @@ -69,8 +71,6 @@ </tablerow> </table> -<tip id="par_id481738974778935">Use the function CHOOSECOLS to reorder the columns of an array. You can also replicate columns by repeating the column index.</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"/> diff --git a/source/text/scalc/01/func_chooserows.xhp b/source/text/scalc/01/func_chooserows.xhp index a9eed14113..830370882c 100644 --- a/source/text/scalc/01/func_chooserows.xhp +++ b/source/text/scalc/01/func_chooserows.xhp @@ -30,7 +30,9 @@ <paragraph role="paragraph" id="par_id81738076052161"><emph>Array</emph>: The array containing the rows to be returned in a new array.</paragraph> <paragraph role="paragraph" id="par_id191738076047602"><emph>Row_1</emph>: The index of the first row to be returned. A negative value chooses from the end of the array.</paragraph> <paragraph role="paragraph" id="par_id1001738076043608"><emph>Row_2; Row_3; ...</emph>: (optional) The list of other row indexes to be returned. A negative value chooses from the end of the array.</paragraph> -<embed href="text/scalc/01/common_func.xhp#optional_args"/> +<paragraph role="paragraph" id="par_id141767192556919">None of the values of <emph>Row_1; Row_2; ...</emph> can be zero.</paragraph> +<paragraph role="paragraph" id="par_id301767192606989">The absolute value of each of <emph>Row_1; Row_2; ...</emph> must be less than or equal to the number of rows of <emph>Array</emph>.</paragraph> +<tip id="par_id481738974778935">Use the function CHOOSEROWS to reorder the rows of an array. You can also replicate rows by repeating the row index.</tip> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/stat_data.xhp#tocolrowxmpl"/> @@ -70,8 +72,6 @@ </tablerow> </table> -<tip id="par_id481738974778935">Use the function CHOOSEROWS to reorder the rows of an array. You can also replicate rows by repeating the row index.</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"/>
