AllLangHelp_scalc.mk | 3 +
source/text/scalc/01/func_choosecols.xhp | 87 +++++++++++++++++++++++++++++
source/text/scalc/01/func_chooserows.xhp | 88 ++++++++++++++++++++++++++++++
source/text/scalc/01/func_expand.xhp | 90 +++++++++++++++++++++++++++++++
4 files changed, 268 insertions(+)
New commits:
commit fe99e461132dd12d11afb9374549241c010df676
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Feb 7 22:40:08 2025 -0300
Commit: Aron Budea <aron.bu...@collabora.com>
CommitDate: Tue Aug 26 22:13:06 2025 +0200
tdf#150999, tdf#151000 CHOOSECOLS, CHOOSEROWS Help page
Change-Id: Ib520e10b17f34eff8fcdc71c008c22ca150341f6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/181283
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
(cherry picked from commit 69e7134a2cbf10aa1acda3515fa78f7d48d35fe9)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/190248
Reviewed-by: Aron Budea <aron.bu...@collabora.com>
Tested-by: Aron Budea <aron.bu...@collabora.com>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index d4d7488e0b..eda12e41cc 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>
commit 0870626edf11ce1bf3552b61b2c0790f376f4ef9
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Jan 28 16:32:34 2025 -0300
Commit: Aron Budea <aron.bu...@collabora.com>
CommitDate: Tue Aug 26 22:12:58 2025 +0200
tdf#151001 EXPAND() Help page
Change-Id: I345b2866343ba3f56795af3428c2fc749e487844
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/180858
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
(cherry picked from commit 5d84a00730dc742b4a3aad3da9e5fc4ef0ec82fd)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/190247
Tested-by: Aron Budea <aron.bu...@collabora.com>
Reviewed-by: Aron Budea <aron.bu...@collabora.com>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 7a9dac6593..d4d7488e0b 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -229,6 +229,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_edate \
helpcontent2/source/text/scalc/01/func_eomonth \
helpcontent2/source/text/scalc/01/func_error_type \
+ helpcontent2/source/text/scalc/01/func_expand \
helpcontent2/source/text/scalc/01/func_filter \
helpcontent2/source/text/scalc/01/func_findb \
helpcontent2/source/text/scalc/01/func_floor \
diff --git a/source/text/scalc/01/func_expand.xhp
b/source/text/scalc/01/func_expand.xhp
new file mode 100644
index 0000000000..8058c054c3
--- /dev/null
+++ b/source/text/scalc/01/func_expand.xhp
@@ -0,0 +1,90 @@
+<?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_expandxhp" indexer="include" status="PUBLISH">
+ <title id="tit">EXPAND function</title>
+ <filename>/text/scalc/01/func_expand.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_EXPAND_MS"
localize="false"/>
+<bookmark branch="index" id="bm_id361708283183878">
+<bookmark_value>EXPAND function</bookmark_value>
+</bookmark>
+<section id="expand">
+ <h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_expand.xhp">EXPAND</link></variable></h1>
+ <paragraph id="par_id771708806478128" role="paragraph">Expand an array by
adding rows or columns.</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>=EXPAND(Array;Rows;[Columns];[Pad_with])</input>
</paragraph>
+<paragraph role="paragraph" id="par_id81738076052161"><emph>Array</emph>: the
array or range to expand by the number of rows and/or columns.</paragraph>
+<paragraph role="paragraph" id="par_id191738076047602"><emph>Rows</emph>: the
final number of rows the array will expand. Default is total rows.</paragraph>
+<paragraph role="paragraph" id="par_id1001738076043608"><emph>Columns</emph>:
(optional) The final number of columns the array will expand. Default is total
columns.</paragraph>
+<paragraph role="paragraph" id="par_id411737825456380"><emph>Pad_with</emph>:
(optional) a specified value to pad in new cells. By default, #N/A is used to
fill the new cells.</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>{=EXPAND(A1:E3;4;7;"@@@")}</input> expands the array
<literal>A1:E3</literal> to 7 columns and 4 rows, padding the extra cells with
the string "@@@".</paragraph>
+<table id="123">
+<tablerow>
+ <tablecell><paragraph id="par_id891738091951629" role="tablecontent"
localize="false">AAA</paragraph></tablecell>
+ <tablecell><paragraph id="par_id601738091955318" role="tablecontent"
localize="false">BBB</paragraph></tablecell>
+ <tablecell><paragraph id="par_id141738091958814" role="tablecontent"
localize="false">CCC</paragraph></tablecell>
+ <tablecell><paragraph id="par_id961738091961782" role="tablecontent"
localize="false">DDD</paragraph></tablecell>
+ <tablecell><paragraph id="par_id31738091964581" role="tablecontent"
localize="false">EEE</paragraph></tablecell>
+ <tablecell><paragraph id="par_id451738091967925" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+ <tablecell><paragraph id="par_id641738091971821" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id311738091977125" role="tablecontent"
localize="false">FFF</paragraph></tablecell>
+ <tablecell><paragraph localize="false" role="tablecontent"
id="par_id481737759439442"> </paragraph></tablecell>
+ <tablecell><paragraph localize="false" role="tablecontent"
id="par_id601737759486665"> </paragraph></tablecell>
+ <tablecell><paragraph id="par_id651738091980157" role="tablecontent"
localize="false">III</paragraph></tablecell>
+ <tablecell><paragraph id="par_id61738091983397" role="tablecontent"
localize="false">JJJ</paragraph></tablecell>
+ <tablecell><paragraph id="par_id201738091990332" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+ <tablecell><paragraph id="par_id921738091987148" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id261738091993516" role="tablecontent"
localize="false">KKK</paragraph></tablecell>
+ <tablecell><paragraph id="par_id521738091999420" role="tablecontent"
localize="false">LLL</paragraph></tablecell>
+ <tablecell><paragraph id="par_id631738092002556" role="tablecontent"
localize="false">MMM</paragraph></tablecell>
+ <tablecell><paragraph id="par_id551738092005580" role="tablecontent"
localize="false">NNN</paragraph></tablecell>
+ <tablecell><paragraph id="par_id1001738092008628" role="tablecontent"
localize="false">OOO</paragraph></tablecell>
+ <tablecell><paragraph id="par_id711738092011668" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+ <tablecell><paragraph id="par_id1001738092025564" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id951738092032531" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+ <tablecell><paragraph id="par_id501738092035859" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+ <tablecell><paragraph id="par_id361738092038987" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+ <tablecell><paragraph id="par_id971738092042643" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+ <tablecell><paragraph id="par_id601738092047915" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+ <tablecell><paragraph id="par_id291738092050803" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+ <tablecell><paragraph id="par_id211738092053731" role="tablecontent"
localize="false">@@@</paragraph></tablecell>
+</tablerow>
+</table>
+
+<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.EXPAND</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"/>
+ <tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/EXPAND";>EXPAND
wiki page</link>.</tip>
+</section>
+</body>
+</helpdocument>
