AllLangHelp_scalc.mk | 2 source/text/scalc/01/func_choosecols.xhp | 87 ++++++++++++++++++++++++++++++ source/text/scalc/01/func_chooserows.xhp | 88 +++++++++++++++++++++++++++++++ 3 files changed, 177 insertions(+)
New commits: commit 69e7134a2cbf10aa1acda3515fa78f7d48d35fe9 Author: Olivier Hallot <[email protected]> AuthorDate: Fri Feb 7 22:40:08 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Sat Feb 8 14:08:17 2025 +0100 tdf#150999, tdf#151000 CHOOSECOLS, CHOOSEROWS Help page Change-Id: Ib520e10b17f34eff8fcdc71c008c22ca150341f6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/181283 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 400e082c72..760f46c78c 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -204,6 +204,8 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_char \ helpcontent2/source/text/scalc/01/func_clean \ helpcontent2/source/text/scalc/01/func_ceiling \ + helpcontent2/source/text/scalc/01/func_choosecols \ + helpcontent2/source/text/scalc/01/func_chooserows \ helpcontent2/source/text/scalc/01/func_countifs \ helpcontent2/source/text/scalc/01/func_color \ helpcontent2/source/text/scalc/01/func_code \ diff --git a/source/text/scalc/01/func_choosecols.xhp b/source/text/scalc/01/func_choosecols.xhp new file mode 100644 index 0000000000..bb443da766 --- /dev/null +++ b/source/text/scalc/01/func_choosecols.xhp @@ -0,0 +1,87 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + +<meta> + <topic id="textscalc01func_choosecolsxhp" indexer="include" status="PUBLISH"> + <title id="tit">CHOOSECOLS function</title> + <filename>/text/scalc/01/func_choosecols.xhp</filename> + </topic> +</meta> +<body> +<bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_CHOOSECOLS_MS" localize="false"/> +<bookmark branch="index" id="bm_id361708283183878"> +<bookmark_value>CHOOSECOLS function</bookmark_value> +</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> +</section> +<note id="par_id131711543270539">Enter the formula as an <link href="text/scalc/01/04060107.xhp">array formula</link>.</note> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> +<paragraph role="code" id="par_id601738075517060"><input>=CHOOSECOLS(Array;Column_1;[Column_2;[Column_3;[...]]])</input> </paragraph> +<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"/> + +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> +<embed href="text/scalc/01/stat_data.xhp#tocolrowxmpl"/> +<paragraph role="paragraph" id="par_id821738091480292">The formula <input>{=CHOOSECOLS(A1:E3;2;4;5)}</input> returns the array below with columns 2,4 and 5 chosen.</paragraph> +<table id="123"> +<tablerow> + <tablecell><paragraph id="par_id631738974033199" role="tablecontent" localize="false">BBB</paragraph></tablecell> + <tablecell><paragraph id="par_id261738974036376" role="tablecontent" localize="false">DDD</paragraph></tablecell> + <tablecell><paragraph id="par_id241738974039175" role="tablecontent" localize="false">EEE</paragraph></tablecell> +</tablerow> +<tablerow> + <tablecell><paragraph localize="false" role="tablecontent" id="par_id481737759439442"> </paragraph></tablecell> + <tablecell><paragraph id="par_id941738974042759" role="tablecontent" localize="false">III</paragraph></tablecell> + <tablecell><paragraph id="par_id281738974046127" role="tablecontent" localize="false">JJJ</paragraph></tablecell> +</tablerow> +<tablerow> + <tablecell><paragraph id="par_id831738974049191" role="tablecontent" localize="false">LLL</paragraph></tablecell> + <tablecell><paragraph id="par_id231738974052943" role="tablecontent" localize="false">NNN</paragraph></tablecell> + <tablecell><paragraph id="par_id751738974056414" role="tablecontent" localize="false">OOO</paragraph></tablecell> +</tablerow> +</table> +<paragraph role="paragraph" id="par_id21738975515099">The formula <input>=CHOOSECOLS(A1:E3;1;-1)</input> returns the array below with column 1 and column 5 chosen, note that column 5 is chosen from the end of the array.</paragraph> + +<table id="tab_id661738975561112"> +<tablerow> + <tablecell><paragraph id="par_id721738976232753" role="tablecontent" localize="false">AAA</paragraph></tablecell> + <tablecell><paragraph id="par_id201738976235938" role="tablecontent" localize="false">EEE</paragraph></tablecell> +</tablerow> +<tablerow> + <tablecell><paragraph id="par_id921738976239601" role="tablecontent" localize="false">FFF</paragraph></tablecell> + <tablecell><paragraph id="par_id151738976242594" role="tablecontent" localize="false">JJJ</paragraph></tablecell> +</tablerow> +<tablerow> + <tablecell><paragraph id="par_id401738976245569" role="tablecontent" localize="false">KKK</paragraph></tablecell> + <tablecell><paragraph id="par_id241738976248585" role="tablecontent" localize="false">OOO</paragraph></tablecell> +</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"/> +<paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.CHOOSECOLS</literal></paragraph> +<section id="relatedtopics"> + <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"/> + <embed href="text/scalc/01/func_wraprows.xhp#h1"/> + <embed href="text/scalc/01/func_chooserows.xhp#h1"/> + <tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSECOLS";>CHOOSECOLS wiki page</link>.</tip> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/func_chooserows.xhp b/source/text/scalc/01/func_chooserows.xhp new file mode 100644 index 0000000000..2ba53cba4f --- /dev/null +++ b/source/text/scalc/01/func_chooserows.xhp @@ -0,0 +1,88 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + +<meta> + <topic id="textscalc01func_chooserowsxhp" indexer="include" status="PUBLISH"> + <title id="tit">CHOOSEROWS function</title> + <filename>/text/scalc/01/func_chooserows.xhp</filename> + </topic> +</meta> +<body> +<bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_CHOOSEROWS_MS" localize="false"/> +<bookmark branch="index" id="bm_id361708283183878"> +<bookmark_value>CHOOSEROWS function</bookmark_value> +</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> +</section> +<note id="par_id131711543270539">Enter the formula as an <link href="text/scalc/01/04060107.xhp">array formula</link>.</note> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> +<paragraph role="code" id="par_id601738075517060"><input>=CHOOSEROWS(Array;Row_1;[Row_2;[Row_3;[...]]])</input> </paragraph> +<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"/> + +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> +<embed href="text/scalc/01/stat_data.xhp#tocolrowxmpl"/> +<paragraph role="paragraph" id="par_id821738091480292">The formula <input>{=CHOOSEROWS(A1:E3;2;3)}</input> returns the array below with rows 2 and 3 chosen.</paragraph> +<table id="123"> +<tablerow> + <tablecell><paragraph id="par_id921738976562770" role="tablecontent" localize="false">FFF</paragraph></tablecell> + <tablecell><paragraph localize="false" role="tablecontent" id="par_id91738976358391"> </paragraph></tablecell> + <tablecell><paragraph localize="false" role="tablecontent" id="par_id481737759439442"> </paragraph></tablecell> + <tablecell><paragraph id="par_id511738976567618" role="tablecontent" localize="false">III</paragraph></tablecell> + <tablecell><paragraph id="par_id111738976570353" role="tablecontent" localize="false">JJJ</paragraph></tablecell> +</tablerow> +<tablerow> + <tablecell><paragraph id="par_id151738976573169" role="tablecontent" localize="false">KKK</paragraph></tablecell> + <tablecell><paragraph id="par_id231738976575969" role="tablecontent" localize="false">LLL</paragraph></tablecell> + <tablecell><paragraph id="par_id501738976578881" role="tablecontent" localize="false">MMM</paragraph></tablecell> + <tablecell><paragraph id="par_id401738976581705" role="tablecontent" localize="false">NNN</paragraph></tablecell> + <tablecell><paragraph id="par_id611738976584913" role="tablecontent" localize="false">OOO</paragraph></tablecell> +</tablerow> +</table> +<paragraph role="paragraph" id="par_id21738975515099">The formula <input>=CHOOSEROWS(A1:E3;1;-1)</input> returns the array below with row 1 and row 3 chosen, note that row 3 is chosen from the end of the array.</paragraph> + +<table id="tab_id661738975561112"> +<tablerow> + <tablecell><paragraph id="par_id861738976588289" role="tablecontent" localize="false">AAA</paragraph></tablecell> + <tablecell><paragraph id="par_id481738976591129" role="tablecontent" localize="false">BBB</paragraph></tablecell> + <tablecell><paragraph id="par_id611738976593905" role="tablecontent" localize="false">CCC</paragraph></tablecell> + <tablecell><paragraph id="par_id631738976598065" role="tablecontent" localize="false">DDD</paragraph></tablecell> + <tablecell><paragraph id="par_id361738976601433" role="tablecontent" localize="false">EEE</paragraph></tablecell> +</tablerow> +<tablerow> + <tablecell><paragraph id="par_id821738976604368" role="tablecontent" localize="false">KKK</paragraph></tablecell> + <tablecell><paragraph id="par_id521738976607568" role="tablecontent" localize="false">LLL</paragraph></tablecell> + <tablecell><paragraph id="par_id931738976611040" role="tablecontent" localize="false">MMM</paragraph></tablecell> + <tablecell><paragraph id="par_id991738976614064" role="tablecontent" localize="false">NNN</paragraph></tablecell> + <tablecell><paragraph id="par_id51738976617144" role="tablecontent" localize="false">OOO</paragraph></tablecell> +</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"/> +<paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.CHOOSEROWS</literal></paragraph> +<section id="relatedtopics"> + <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"/> + <embed href="text/scalc/01/func_wraprows.xhp#h1"/> + <embed href="text/scalc/01/func_choosecols.xhp#h1"/> + <tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSEROWS";>CHOOSEROWS wiki page</link>.</tip> +</section> +</body> +</helpdocument>
