blob: 45500425e8be5a83bf9d13f2e2c4bec23b38362b (
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
97
98
99
100
101
102
103
104
105
106
|
<?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_hstackxhp" indexer="include" status="PUBLISH">
<title id="tit">HSTACK function</title>
<filename>/text/scalc/01/func_hstack.xhp</filename>
</topic>
</meta>
<body>
<bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_HSTACK_MS" localize="false"/>
<bookmark branch="index" id="bm_id361708283183878">
<bookmark_value>HSTACK function</bookmark_value>
</bookmark>
<section id="hstack">
<h1 id="hd_id901708806478126"><variable id="h1"><link href="text/scalc/01/func_hstack.xhp">HSTACK</link></variable></h1>
<paragraph id="par_id771708806478128" role="paragraph">Appends arrays horizontally to create a larger array.</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">=HSTACK(Array [; Array_1 [; Array_2;[...]]]) </paragraph>
<paragraph role="paragraph" id="par_id81738076052161"><emph>Array</emph>: The first array to be returned in a new array.</paragraph>
<paragraph role="paragraph" id="par_id1001738076043608"><emph>Array_1; Array_2; ...</emph>: (optional) the arrays to append sequentially after the previous 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_id471739049807951">And the second array as:</paragraph>
<embed href="text/scalc/01/stat_data.xhp#hvstack_data"/>
<paragraph role="paragraph" id="par_id821738091480292">The formula <input>{=HSTACK(A1:E3;N15:O19)}</input> returns the array below, with data of array N15:O19 on the right of the data of array A1:E3, and extra cells filled with #N/A error:</paragraph>
<table id="123">
<tablerow>
<tablecell><paragraph id="par_id341739053819865" role="tablecontent" localize="false">AAA</paragraph></tablecell>
<tablecell><paragraph id="par_id271739053823945" role="tablecontent" localize="false">BBB</paragraph></tablecell>
<tablecell><paragraph id="par_id521739053826745" role="tablecontent" localize="false">CCC</paragraph></tablecell>
<tablecell><paragraph id="par_id661739053829769" role="tablecontent" localize="false">DDD</paragraph></tablecell>
<tablecell><paragraph id="par_id911739053833601" role="tablecontent" localize="false">EEE</paragraph></tablecell>
<tablecell><paragraph id="par_id561739053837057" role="tablecontent" localize="false">PPP</paragraph></tablecell>
<tablecell><paragraph id="par_id711739053840770" role="tablecontent" localize="false">QQQ</paragraph></tablecell>
</tablerow>
<tablerow>
<tablecell><paragraph id="par_id581739053844272" role="tablecontent" localize="false">FFF</paragraph></tablecell>
<tablecell><paragraph localize="false" role="tablecontent" id="par_id941739051444163"> </paragraph></tablecell>
<tablecell><paragraph localize="false" role="tablecontent" id="par_id381739049583941"> </paragraph></tablecell>
<tablecell><paragraph id="par_id181739053847984" role="tablecontent" localize="false">III</paragraph></tablecell>
<tablecell><paragraph id="par_id991739053850961" role="tablecontent" localize="false">JJJ</paragraph></tablecell>
<tablecell><paragraph id="par_id861739053880791" role="tablecontent" localize="false">RRR</paragraph></tablecell>
<tablecell><paragraph id="par_id51739053883999" role="tablecontent" localize="false">SSS</paragraph></tablecell>
</tablerow>
<tablerow>
<tablecell><paragraph id="par_id871739053888255" role="tablecontent" localize="false">KKK</paragraph></tablecell>
<tablecell><paragraph id="par_id291739053891231" role="tablecontent" localize="false">LLL</paragraph></tablecell>
<tablecell><paragraph id="par_id591739053894135" role="tablecontent" localize="false">MMM</paragraph></tablecell>
<tablecell><paragraph id="par_id491739053897230" role="tablecontent" localize="false">NNN</paragraph></tablecell>
<tablecell><paragraph id="par_id111739053900543" role="tablecontent" localize="false">OOO</paragraph></tablecell>
<tablecell><paragraph id="par_id71739053903574" role="tablecontent" localize="false">TTT</paragraph></tablecell>
<tablecell><paragraph id="par_id921739053906534" role="tablecontent" localize="false">UUU</paragraph></tablecell>
</tablerow>
<tablerow>
<tablecell><paragraph id="par_id531739053910655" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id751739053913950" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id901739053919430" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id971739053922678" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id661739053925502" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id401739053928622" role="tablecontent" localize="false">VVV</paragraph></tablecell>
<tablecell><paragraph id="par_id331739053931582" role="tablecontent" localize="false">WWW</paragraph></tablecell>
</tablerow>
<tablerow>
<tablecell><paragraph id="par_id21739053937150" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id391739053940086" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id91739053943062" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id21739053946189" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id301739053949109" role="tablecontent" localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table" markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id841739053952093" role="tablecontent" localize="false">XXX</paragraph></tablecell>
<tablecell><paragraph id="par_id121739053955061" role="tablecontent" localize="false">YYY</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.HSTACK</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_expand.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/HSTACK">HSTACK wiki page</link>.</tip>
</section>
</body>
</helpdocument>
|
