diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2025-01-28 16:32:34 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2025-01-28 21:06:51 +0100 |
| commit | 5d84a00730dc742b4a3aad3da9e5fc4ef0ec82fd (patch) | |
| tree | 069cba06f75740e999e067a78a3bd7f76e43cfbe /source | |
| parent | b1c6f6063d9174be03a4ed9485b802dab26c4ffc (diff) | |
tdf#151001 EXPAND() Help page
Change-Id: I345b2866343ba3f56795af3428c2fc749e487844
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/180858
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Tested-by: Jenkins
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/func_expand.xhp | 90 |
1 files changed, 90 insertions, 0 deletions
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> |