AllLangHelp_scalc.mk | 3
source/text/scalc/01/func_hstack.xhp | 102 ++++++++++++++++++++++++++++
source/text/scalc/01/func_textjoin.xhp | 7 +
source/text/scalc/01/func_textsplit.xhp | 91 +++++++++++++++++++++++++
source/text/scalc/01/func_vstack.xhp | 113 ++++++++++++++++++++++++++++++++
source/text/scalc/01/stat_data.xhp | 42 +++++++++++
6 files changed, 354 insertions(+), 4 deletions(-)
New commits:
commit f8fa8fed40fc3b5cd841c58e8b130fef22c8dc6c
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun May 11 08:41:53 2025 -0300
Commit: Aron Budea <aron.bu...@collabora.com>
CommitDate: Tue Aug 26 22:13:24 2025 +0200
tdf#150866 TEXTSPLIT function Help page
Change-Id: I0dca2ce456c444ed043023e17f30ac12a8d88b87
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/185184
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
(cherry picked from commit 1cb48f1e2e8ff179d834a28a6f4eb9b011ce93d0)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/190250
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 fc6a2a4e9b..db77c7296f 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -314,6 +314,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_sumifs \
helpcontent2/source/text/scalc/01/func_switch \
helpcontent2/source/text/scalc/01/func_textjoin \
+ helpcontent2/source/text/scalc/01/func_textsplit \
helpcontent2/source/text/scalc/01/func_time \
helpcontent2/source/text/scalc/01/func_timevalue \
helpcontent2/source/text/scalc/01/func_today \
diff --git a/source/text/scalc/01/func_textjoin.xhp
b/source/text/scalc/01/func_textjoin.xhp
index e391da0f9a..5bf825d71b 100644
--- a/source/text/scalc/01/func_textjoin.xhp
+++ b/source/text/scalc/01/func_textjoin.xhp
@@ -11,14 +11,14 @@
<meta>
<topic id="textjoinfunc" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">TEXTJOIN function</title>
+ <title id="tit">TEXTJOIN function</title>
<filename>/text/scalc/01/func_textjoin.xhp</filename>
</topic>
</meta>
<body>
<section id="textjoin01">
- <bookmark id="bm_id681556227727944" xml-lang="en-US"
branch="hid/SC_HID_FUNC_TEXTJOIN_MS" localize="false"/>
- <bookmark xml-lang="en-US" branch="index" id="bm_id581556228060864">
+ <bookmark id="bm_id681556227727944"
branch="hid/SC_HID_FUNC_TEXTJOIN_MS" localize="false"/>
+ <bookmark branch="index" id="bm_id581556228060864">
<bookmark_value>TEXTJOIN function</bookmark_value>
</bookmark>
<h1 id="hd_id551556227727946"><variable id="textjoinfunct"><link
href="text/scalc/01/func_textjoin.xhp">TEXTJOIN</link></variable></h1>
@@ -44,6 +44,7 @@
<tip id="par_id761677014445916"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTJOIN";>TEXTJOIN
wiki page</link>.</tip>
<embed href="text/scalc/01/func_concat.xhp#concatfunct"/>
<paragraph role="paragraph" id="par_id781556244709752"><link
href="text/scalc/01/04060110.xhp#concatenate">CONCATENATE</link></paragraph>
+ <paragraph role="paragraph" id="par_id1001746970893891"
localize="false"><embedvar
href="text/scalc/01/func_textsplit.xhp#textsplitfunct"
markup="ignore"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_textsplit.xhp
b/source/text/scalc/01/func_textsplit.xhp
new file mode 100644
index 0000000000..9be60312c5
--- /dev/null
+++ b/source/text/scalc/01/func_textsplit.xhp
@@ -0,0 +1,91 @@
+<?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="textsplitfunc" indexer="include" status="PUBLISH">
+ <title id="tit">TEXTSPLIT function</title>
+ <filename>/text/scalc/01/func_textsplit.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="textsplit01">
+ <bookmark id="bm_id681556227727944"
branch="hid/SC_HID_FUNC_TEXTSPLIT_MS" localize="false"/>
+ <bookmark branch="index" id="bm_id581556228060864">
+ <bookmark_value>TEXTSPLIT function</bookmark_value>
+ </bookmark>
+ <h1 id="hd_id551556227727946"><variable id="textsplitfunct"><link
href="text/scalc/01/func_textsplit.xhp">TEXTSPLIT</link></variable></h1>
+ <paragraph id="par_id121556227727948" role="paragraph"><variable
id="textsplitfunction">Splits text by a given delimiter to an array of multiple
cells.</variable></paragraph>
+ </section>
+ <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
+ <paragraph role="code" id="par_id541556228253979">TEXTSPLIT(Text; Column
Delimiter; Row Delimiter; Ignore Empty; Match Mode; Pad With)</paragraph>
+ <paragraph role="paragraph" id="par_id741746962354423"><emph>Text</emph>:
the text to split.</paragraph>
+ <paragraph role="paragraph" id="par_id91746962359992"><emph>Column
Delimiter</emph>: the text to delimit the columns. Multiple delimiters can be
supplied.</paragraph>
+ <paragraph role="paragraph" id="par_id361746962365647"><emph>Row
Delimiter</emph>: the text to delimit the rows. Multiple delimiters can be
supplied.</paragraph>
+ <paragraph role="paragraph" id="par_id521746962371799"><emph>Ignore
Empty</emph>: set to TRUE to ignore consecutive delimiters otherwise creates an
empty cell. The default to FALSE.</paragraph>
+ <paragraph role="paragraph" id="par_id951746962377042"><emph>Match
mode</emph>: set to 1 to perform a case-insensitive match otherwise does a
case-sensitive match. The default to 0.</paragraph>
+ <paragraph role="paragraph" id="par_id651746962382871"><emph>Pad
with</emph>: the value with which to pad. The default is #N/A.</paragraph>
+
+ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
+ <paragraph role="paragraph" id="par_id521746970153871">If cell A1 contains
<literal>"AA,BB,,CC/DD,EE,FF/GG,HH,II,JJ"</literal>, then </paragraph>
+ <paragraph role="paragraph"
id="par_id541746969982707"><input>{=TEXTSPLIT(A1;",";"/";FALSE();1;"@@@")}</input>
returns the following array:</paragraph>
+ <table id="tab_id221746970000257">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id961746970000260" localize="false"
role="tablecontent">AA</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id281746970000262" localize="false"
role="tablecontent">BB</paragraph>
+ </tablecell>
+ <tablecell/>
+ <tablecell>
+ <paragraph id="par_id631746970000265" localize="false"
role="tablecontent">CC</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id571746970000268" localize="false"
role="tablecontent">DD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id711746970000270" localize="false"
role="tablecontent">EE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501746970000273" localize="false"
role="tablecontent">FF</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id641746970308265" localize="false"
role="tablecontent">@@@</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id881746970333109" localize="false"
role="tablecontent">GG</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id521746970333111" localize="false"
role="tablecontent">HH</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id911746970333114" localize="false"
role="tablecontent">II</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id651746970333116" localize="false"
role="tablecontent">JJ</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_id341640873986703"
localize="false"><literal>COM.MICROSOFT.TEXTSPLIT</literal></paragraph>
+ <section id="relatedtopics">
+ <tip id="par_id761677014445916"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTJOIN";>TEXTSPLIT
wiki page</link>.</tip>
+ <paragraph role="paragraph" id="par_id1001746970893891"
localize="false"><embedvar href="text/scalc/01/func_textjoin.xhp#textjoinfunct"
markup="ignore"/></paragraph>
+ </section>
+</body>
+</helpdocument>
+
commit ae48d824c6993e78c3021c846e3ab84b3d212592
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Feb 8 19:42:26 2025 -0300
Commit: Aron Budea <aron.bu...@collabora.com>
CommitDate: Tue Aug 26 22:13:14 2025 +0200
tdf#150867, tdf#150868 VSTACK, HSTACK Help pages
Change-Id: I99393f75184cabb9f8fd636c1e42efcf2e71ee38
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/181305
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
(cherry picked from commit ffb89373324e64c4753ffd41d98bbd7f70b336ea)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/190249
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 eda12e41cc..fc6a2a4e9b 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -245,6 +245,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_fourier \
helpcontent2/source/text/scalc/01/exponsmooth_embd \
helpcontent2/source/text/scalc/01/func_hour \
+ helpcontent2/source/text/scalc/01/func_hstack \
helpcontent2/source/text/scalc/01/func_ifs \
helpcontent2/source/text/scalc/01/func_imcot \
helpcontent2/source/text/scalc/01/func_imcos \
@@ -319,6 +320,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_trunc \
helpcontent2/source/text/scalc/01/func_unique \
helpcontent2/source/text/scalc/01/func_value \
+ helpcontent2/source/text/scalc/01/func_vstack \
helpcontent2/source/text/scalc/01/func_xlookup \
helpcontent2/source/text/scalc/01/func_xmatch \
helpcontent2/source/text/scalc/01/func_weekday \
diff --git a/source/text/scalc/01/func_hstack.xhp
b/source/text/scalc/01/func_hstack.xhp
new file mode 100644
index 0000000000..e13c90056d
--- /dev/null
+++ b/source/text/scalc/01/func_hstack.xhp
@@ -0,0 +1,102 @@
+<?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>
+<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>=HSTACK(Array;[Array_1;[Array_2;[...]]])</input>
</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"><variable id="NA">#N/A</variable></paragraph></tablecell>
+ <tablecell><paragraph id="par_id751739053913950" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_hstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id901739053919430" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_hstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id971739053922678" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_hstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id661739053925502" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_hstack.xhp#NA"
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/func_hstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id391739053940086" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_hstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id91739053943062" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_hstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id21739053946189" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_hstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id301739053949109" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_hstack.xhp#NA"
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_vstack.xhp#h1"/>
+ <tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/HSTACK";>HSTACK
wiki page</link>.</tip>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_vstack.xhp
b/source/text/scalc/01/func_vstack.xhp
new file mode 100644
index 0000000000..264cbc316b
--- /dev/null
+++ b/source/text/scalc/01/func_vstack.xhp
@@ -0,0 +1,113 @@
+<?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_vstackxhp" indexer="include" status="PUBLISH">
+ <title id="tit">VSTACK function</title>
+ <filename>/text/scalc/01/func_vstack.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_VSTACK_MS"
localize="false"/>
+<bookmark branch="index" id="bm_id361708283183878">
+<bookmark_value>VSTACK function</bookmark_value>
+</bookmark>
+<section id="vstack">
+ <h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_vstack.xhp">VSTACK</link></variable></h1>
+ <paragraph id="par_id771708806478128" role="paragraph">Appends arrays
vertically to create a larger 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>=VSTACK(Array;[Array_1;[Array_2;[...]]])</input>
</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>{=VSTACK(A1:E3;N15:O19)}</input> returns the array below, with data of
array N15:O19 below data of array A1:E3, and extra cells filled with #N/A
error:</paragraph>
+<table id="123">
+<tablerow>
+ <tablecell><paragraph id="par_id431739051359416" role="tablecontent"
localize="false">AAA</paragraph></tablecell>
+ <tablecell><paragraph id="par_id591739050197212" role="tablecontent"
localize="false">BBB</paragraph></tablecell>
+ <tablecell><paragraph id="par_id911739050200116" role="tablecontent"
localize="false">CCC</paragraph></tablecell>
+ <tablecell><paragraph id="par_id371739050203148" role="tablecontent"
localize="false">DDD</paragraph></tablecell>
+ <tablecell><paragraph id="par_id891739050206163" role="tablecontent"
localize="false">EEE</paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id691739050232906" 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_id541739050245050" role="tablecontent"
localize="false">III</paragraph></tablecell>
+ <tablecell><paragraph id="par_id821739050248466" role="tablecontent"
localize="false">JJJ</paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id761739050268065" role="tablecontent"
localize="false">KKK</paragraph></tablecell>
+ <tablecell><paragraph id="par_id61739050272145" role="tablecontent"
localize="false">LLL</paragraph></tablecell>
+ <tablecell><paragraph id="par_id691739050275593" role="tablecontent"
localize="false">MMM</paragraph></tablecell>
+ <tablecell><paragraph id="par_id791739050279329" role="tablecontent"
localize="false">NNN</paragraph></tablecell>
+ <tablecell><paragraph id="par_id801739050282777" role="tablecontent"
localize="false">OOO</paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id521739050321695" role="tablecontent"
localize="false">PPP</paragraph></tablecell>
+ <tablecell><paragraph id="par_id421739050324631" role="tablecontent"
localize="false">QQQ</paragraph></tablecell>
+ <tablecell><paragraph id="par_id391739050327791"
role="tablecontent"><variable id="NA">#N/A</variable></paragraph></tablecell>
+ <tablecell><paragraph id="par_id141739050331263" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id711739050335831" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id741739050374973" role="tablecontent"
localize="false">RRR</paragraph></tablecell>
+ <tablecell><paragraph id="par_id551739050378109" role="tablecontent"
localize="false">SSS</paragraph></tablecell>
+ <tablecell><paragraph id="par_id31739050380957" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id891739050384085" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id71739050387325" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id481739050423803" role="tablecontent"
localize="false">TTT</paragraph></tablecell>
+ <tablecell><paragraph id="par_id901739050426932" role="tablecontent"
localize="false">UUU</paragraph></tablecell>
+ <tablecell><paragraph id="par_id791739050429907" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id181739050433051" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id401739050436355" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id301739050478281" role="tablecontent"
localize="false">VVV</paragraph></tablecell>
+ <tablecell><paragraph id="par_id291739050481385" role="tablecontent"
localize="false">WWW</paragraph></tablecell>
+ <tablecell><paragraph id="par_id661739050485017" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id531739050488025" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id351739050492625" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+</tablerow>
+<tablerow>
+ <tablecell><paragraph id="par_id441739050496137" role="tablecontent"
localize="false">XXX</paragraph></tablecell>
+ <tablecell><paragraph id="par_id311739050499049" role="tablecontent"
localize="false">YYY</paragraph></tablecell>
+ <tablecell><paragraph id="par_id801739050502528" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id561739050505793" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id491739050509352" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/func_vstack.xhp#NA"
markup="ignore"/></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.VSTACK</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_hstack.xhp#h1"/>
+ <tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/VSTACK";>VSTACK
wiki page</link>.</tip>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/stat_data.xhp
b/source/text/scalc/01/stat_data.xhp
index f7e662f83b..7802fd11e2 100644
--- a/source/text/scalc/01/stat_data.xhp
+++ b/source/text/scalc/01/stat_data.xhp
@@ -1332,7 +1332,7 @@
</table>
</section>
<section id="tocolrowxmpl">
-<paragraph role="paragraph" id="par_id71737757692138">Consider the array
<literal>A1:E3</literal> below.</paragraph>
+<paragraph role="paragraph" id="par_id71737757692138">Consider the array
<literal>A1:E3</literal> below:</paragraph>
<table id="tab_id831737756798511">
<tablerow>
<tablecell>
@@ -1471,5 +1471,45 @@
</tablerow>
</table>
</section>
+ <section id="hvstack_data">
+ <table id="tab_id191739049060652">
+ <tablerow>
+ <tablecell>
+ <paragraph localize="false" role="tablehead"
id="par_id381739049583941"> </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id791739049060653"
role="tablehead">N</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id671739049060653"
role="tablehead">O</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id211739049589646"
role="tablehead" localize="false">15</paragraph></tablecell>
+ <tablecell><paragraph id="par_id591739049592710"
role="tablecontent" localize="false">PPP</paragraph></tablecell>
+ <tablecell><paragraph id="par_id171739049598541"
role="tablecontent" localize="false">QQQ</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id511739049601413"
role="tablehead" localize="false">16</paragraph></tablecell>
+ <tablecell><paragraph id="par_id651739049604286"
role="tablecontent" localize="false">RRR</paragraph></tablecell>
+ <tablecell><paragraph id="par_id181739049606941"
role="tablecontent" localize="false">SSS</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id461739049609653"
role="tablehead" localize="false">17</paragraph></tablecell>
+ <tablecell><paragraph id="par_id421739049612605"
role="tablecontent" localize="false">TTT</paragraph></tablecell>
+ <tablecell><paragraph id="par_id831739049615773"
role="tablecontent" localize="false">UUU</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id691739049618628"
role="tablehead" localize="false">18</paragraph></tablecell>
+ <tablecell><paragraph id="par_id401739049622236"
role="tablecontent" localize="false">VVV</paragraph></tablecell>
+ <tablecell><paragraph id="par_id981739049625260"
role="tablecontent" localize="false">WWW</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id621739049631268"
role="tablehead" localize="false">19</paragraph></tablecell>
+ <tablecell><paragraph id="par_id131739049634756"
role="tablecontent" localize="false">XXX</paragraph></tablecell>
+ <tablecell><paragraph id="par_id271739049638587"
role="tablecontent" localize="false">YYY</paragraph></tablecell>
+ </tablerow>
+ </table>
+ </section>
</body>
</helpdocument>
