AllLangHelp_scalc.mk | 1
source/text/scalc/01/func_expand.xhp | 90 +++++++++++++++++++++++++++++++++++
2 files changed, 91 insertions(+)
New commits:
commit 5d84a00730dc742b4a3aad3da9e5fc4ef0ec82fd
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Jan 28 16:32:34 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Jan 28 21:06:51 2025 +0100
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
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 52e514fd62..cebb19ab7c 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -228,6 +228,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>
