diff options
| -rw-r--r-- | AllLangHelp_scalc.mk | 2 | ||||
| -rw-r--r-- | source/text/scalc/01/func_hstack.xhp | 102 | ||||
| -rw-r--r-- | source/text/scalc/01/func_vstack.xhp | 113 | ||||
| -rw-r--r-- | source/text/scalc/01/stat_data.xhp | 42 |
4 files changed, 258 insertions, 1 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 760f46c78c..f4ba1c742f 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> |