blob: fa424aaeded619aa4c271bac84091b0c59590590 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
<?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>
<embed href="text/scalc/01/common_func.xhp#array"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph role="code" id="par_id601738075517060">=EXPAND(Array; Rows [; Columns [; Pad_with]]) </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"/>
<embed href="text/scalc/01/func_chooserows.xhp#h1"/>
<embed href="text/scalc/01/func_choosecols.xhp#h1"/>
<embed href="text/scalc/01/func_vstack.xhp#h1"/>
<embed href="text/scalc/01/func_hstack.xhp#h1"/>
<embed href="text/scalc/01/func_drop.xhp#h1"/>
<embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/EXPAND">EXPAND wiki page</link>.</tip>
</section>
</body>
</helpdocument>
|
