AllLangHelp_scalc.mk | 2
source/text/scalc/01/func_tocol.xhp | 145 +++++-------------------
source/text/scalc/01/func_torow.xhp | 97 ++++++----------
source/text/scalc/01/func_wrapcols.xhp | 83 +++++++++++++
source/text/scalc/01/func_wraprows.xhp | 76 ++++++++++++
source/text/scalc/01/stat_data.xhp | 162 +++++++++++++++++++++++++--
source/text/scalc/01/statistics_sampling.xhp | 1
7 files changed, 383 insertions(+), 183 deletions(-)
New commits:
commit 9400a3e9696e67e24560695969877e2e30199918
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Jan 27 22:26:10 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Jan 28 18:10:01 2025 +0100
tdf#150880, tdf#150881 WRAPROWS() + WRAPCOLS() Help pages
+ refactor to reuse sample data
+ Adjust data for TOCOL and TOROW
Change-Id: I6d4661a9c044d414d4142aa159900b699ccb2192
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/180811
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 4581269333..52e514fd62 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -322,6 +322,8 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_weeknum_ooo \
helpcontent2/source/text/scalc/01/func_weeknumadd \
helpcontent2/source/text/scalc/01/func_workday \
+ helpcontent2/source/text/scalc/01/func_wrapcols \
+ helpcontent2/source/text/scalc/01/func_wraprows \
helpcontent2/source/text/scalc/01/func_year \
helpcontent2/source/text/scalc/01/func_yearfrac \
helpcontent2/source/text/scalc/01/HandleDuplicateRecords \
diff --git a/source/text/scalc/01/func_tocol.xhp
b/source/text/scalc/01/func_tocol.xhp
index a6c93b517f..f2bc5ed733 100644
--- a/source/text/scalc/01/func_tocol.xhp
+++ b/source/text/scalc/01/func_tocol.xhp
@@ -40,89 +40,10 @@
<embed href="text/scalc/01/common_func.xhp#optional_args"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<section id="tocolrowxmpl">
-<paragraph role="paragraph" id="par_id71737757692138"> Consider the array
<literal>A1:E3</literal> below.</paragraph>
-<table id="tab_id831737756798511">
- <tablerow>
- <tablecell>
- </tablecell>
- <tablecell>
- <paragraph id="par_id581737756798511" localize="false"
role="tablehead">A</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id211747756798511" localize="false"
role="tablehead">B</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id211737756798511" localize="false"
role="tablehead">C</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id211757756798511" localize="false"
role="tablehead">D</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id211737756598511" localize="false"
role="tablehead">E</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id941737757138103" localize="false"
role="tablehead">1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id811737757160471" localize="false"
role="tablecontent">AAA</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id531737757177927" localize="false"
role="tablecontent">BBB</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id631737757194454" localize="false"
role="tablecontent">CCC</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id781737757200438" localize="false"
role="tablecontent">DDD</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id111737757268636" localize="false"
role="tablecontent">FFF</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id291737757283307" localize="false"
role="tablehead">2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id41737757307170" localize="false"
role="tablecontent">GGG</paragraph>
- </tablecell>
- <tablecell>
- </tablecell>
- <tablecell>
- </tablecell>
- <tablecell>
- <paragraph id="par_id171737757353410" localize="false"
role="tablecontent">JJJ</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id11737757378330" localize="false"
role="tablecontent">KKK</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id951737757455696" localize="false"
role="tablehead">3</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id101737757481391" localize="false"
role="tablecontent">LLL</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id481737757510079" localize="false"
role="tablecontent">MMM</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id501737757523191" localize="false"
role="tablecontent">NNN</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id541737757538390" localize="false"
role="tablecontent">OOO</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id61737757587797" localize="false"
role="tablecontent">PPP</paragraph>
- </tablecell>
- </tablerow>
-</table>
-</section>
-<paragraph role="paragraph" id="par_id711737758586509">The formula
<input>=TOCOL(A1:E3)</input> returns the column</paragraph>
+
+<embed href="text/scalc/01/stat_data.xhp#tocolrowxmpl"/>
+
+<paragraph role="paragraph" id="par_id711737758586509">The formula
<input>{=TOCOL(A1:E3)}</input> returns the column</paragraph>
<table id="123">
<tablerow>
<tablecell>
@@ -138,10 +59,10 @@
<paragraph id="par_id781777757200438" localize="false"
role="tablecontent">DDD</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id111787757268636" localize="false"
role="tablecontent">FFF</paragraph>
+ <paragraph id="par_id111787757268636" localize="false"
role="tablecontent">EEE</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id41737757317170" localize="false"
role="tablecontent">GGG</paragraph>
+ <paragraph id="par_id41737757317170" localize="false"
role="tablecontent">FFF</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
<paragraph localize="false" role="paragraph"
id="par_id481737759439442"> </paragraph>
@@ -150,25 +71,25 @@
<paragraph localize="false" role="paragraph"
id="par_id601737759486665"> </paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id171737757323410" localize="false"
role="tablecontent">JJJ</paragraph>
+ <paragraph id="par_id171737757323410" localize="false"
role="tablecontent">III</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id11737757372330" localize="false"
role="tablecontent">KKK</paragraph>
+ <paragraph id="par_id11737757372330" localize="false"
role="tablecontent">JJJ</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id101737757485391" localize="false"
role="tablecontent">LLL</paragraph>
+ <paragraph id="par_id101737757485391" localize="false"
role="tablecontent">KKK</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id481737757510679" localize="false"
role="tablecontent">MMM</paragraph>
+ <paragraph id="par_id481737757510679" localize="false"
role="tablecontent">LLL</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id501737757523171" localize="false"
role="tablecontent">NNN</paragraph>
+ <paragraph id="par_id501737757523171" localize="false"
role="tablecontent">MMM</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id551737757538390" localize="false"
role="tablecontent">OOO</paragraph>
+ <paragraph id="par_id551737757538390" localize="false"
role="tablecontent">NNN</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id61537757587797" localize="false"
role="tablecontent">PPP</paragraph>
+ <paragraph id="par_id61537757587797" localize="false"
role="tablecontent">OOO</paragraph>
</tablecell></tablerow>
</table>
<paragraph role="paragraph" id="par_id351737760079923">The formula
<input>=TOCOL(A1:E3;1)</input> returns the column below without the blank
cells.</paragraph>
@@ -187,31 +108,31 @@
<paragraph id="par_id781737557200438" localize="false"
role="tablecontent">DDD</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id111737657268636" localize="false"
role="tablecontent">FFF</paragraph>
+ <paragraph id="par_id111737657268636" localize="false"
role="tablecontent">EEE</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id41737857307170" localize="false"
role="tablecontent">GGG</paragraph>
+ <paragraph id="par_id41737857307170" localize="false"
role="tablecontent">FFF</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id171739757353410" localize="false"
role="tablecontent">JJJ</paragraph>
+ <paragraph id="par_id171739757353410" localize="false"
role="tablecontent">III</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id11737057378330" localize="false"
role="tablecontent">KKK</paragraph>
+ <paragraph id="par_id11737057378330" localize="false"
role="tablecontent">JJJ</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id101737707481391" localize="false"
role="tablecontent">LLL</paragraph>
+ <paragraph id="par_id101737707481391" localize="false"
role="tablecontent">KKK</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id481737717510079" localize="false"
role="tablecontent">MMM</paragraph>
+ <paragraph id="par_id481737717510079" localize="false"
role="tablecontent">LLL</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id501737727523191" localize="false"
role="tablecontent">NNN</paragraph>
+ <paragraph id="par_id501737727523191" localize="false"
role="tablecontent">MMM</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id541737637538390" localize="false"
role="tablecontent">OOO</paragraph>
+ <paragraph id="par_id541737637538390" localize="false"
role="tablecontent">NNN</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id61737754587797" localize="false"
role="tablecontent">PPP</paragraph>
+ <paragraph id="par_id61737754587797" localize="false"
role="tablecontent">OOO</paragraph>
</tablecell></tablerow>
</table>
@@ -222,40 +143,40 @@
<paragraph id="par_id641737758619870" localize="false"
role="tablecontent">AAA</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id41737857302170" localize="false"
role="tablecontent">GGG</paragraph>
+ <paragraph id="par_id41737857302170" localize="false"
role="tablecontent">FFF</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id101737707431391" localize="false"
role="tablecontent">LLL</paragraph>
+ <paragraph id="par_id101737707431391" localize="false"
role="tablecontent">KKK</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
<paragraph id="par_id531737357147927" localize="false"
role="tablecontent">BBB</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id481737717550079" localize="false"
role="tablecontent">MMM</paragraph>
+ <paragraph id="par_id481737717550079" localize="false"
role="tablecontent">LLL</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
<paragraph id="par_id631737457164454" localize="false"
role="tablecontent">CCC</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id501437727523191" localize="false"
role="tablecontent">NNN</paragraph>
+ <paragraph id="par_id501437727523191" localize="false"
role="tablecontent">MMM</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
<paragraph id="par_id781737557208438" localize="false"
role="tablecontent">DDD</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id371739757353410" localize="false"
role="tablecontent">JJJ</paragraph>
+ <paragraph id="par_id371739757353410" localize="false"
role="tablecontent">III</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id351737757538390" localize="false"
role="tablecontent">OOO</paragraph>
+ <paragraph id="par_id351737757538390" localize="false"
role="tablecontent">NNN</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id311787757268636" localize="false"
role="tablecontent">FFF</paragraph>
+ <paragraph id="par_id311787757268636" localize="false"
role="tablecontent">EEE</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id31737057378330" localize="false"
role="tablecontent">KKK</paragraph>
+ <paragraph id="par_id31737057378330" localize="false"
role="tablecontent">JJJ</paragraph>
</tablecell></tablerow><tablerow>
<tablecell>
- <paragraph id="par_id31737754587797" localize="false"
role="tablecontent">PPP</paragraph>
+ <paragraph id="par_id31737754587797" localize="false"
role="tablecontent">OOO</paragraph>
</tablecell>
</tablerow>
</table>
@@ -265,8 +186,10 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640870986703"
localize="false"><literal>COM.MICROSOFT.TOCOL</literal></paragraph>
<section id="relatedtopics">
- <tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TOCOL";>TOCOL
wiki page</link>.</tip>
<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/TOCOL";>TOCOL
wiki page</link>.</tip>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_torow.xhp
b/source/text/scalc/01/func_torow.xhp
index 4f90ecefa9..90140e268f 100644
--- a/source/text/scalc/01/func_torow.xhp
+++ b/source/text/scalc/01/func_torow.xhp
@@ -31,7 +31,8 @@
<embed href="text/scalc/01/func_tocol.xhp#tocolrowargs"/>
<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/func_tocol.xhp#tocolrowxmpl"/>
+
+<embed href="text/scalc/01/stat_data.xhp#tocolrowxmpl"/>
<paragraph role="paragraph" id="par_id711737758586509">The formula
<input>=TOROW(A1:E3)</input> returns the row</paragraph>
<table id="123">
@@ -49,10 +50,10 @@
<paragraph id="par_id781777757200438" localize="false"
role="tablecontent">DDD</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id111787757268636" localize="false"
role="tablecontent">FFF</paragraph>
+ <paragraph id="par_id111787757268636" localize="false"
role="tablecontent">EEE</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id41737757317170" localize="false"
role="tablecontent">GGG</paragraph>
+ <paragraph id="par_id41737757317170" localize="false"
role="tablecontent">FFF</paragraph>
</tablecell>
<tablecell>
<paragraph localize="false" role="paragraph"
id="par_id481737759439442"> </paragraph>
@@ -61,25 +62,25 @@
<paragraph localize="false" role="paragraph"
id="par_id601737759486665"> </paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id171737757323410" localize="false"
role="tablecontent">JJJ</paragraph>
+ <paragraph id="par_id171737757323410" localize="false"
role="tablecontent">III</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id11737757372330" localize="false"
role="tablecontent">KKK</paragraph>
+ <paragraph id="par_id11737757372330" localize="false"
role="tablecontent">JJJ</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id101737757485391" localize="false"
role="tablecontent">LLL</paragraph>
+ <paragraph id="par_id101737757485391" localize="false"
role="tablecontent">KKK</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id481737757510679" localize="false"
role="tablecontent">MMM</paragraph>
+ <paragraph id="par_id481737757510679" localize="false"
role="tablecontent">LLL</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id501737757523171" localize="false"
role="tablecontent">NNN</paragraph>
+ <paragraph id="par_id501737757523171" localize="false"
role="tablecontent">MMM</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id551737757538390" localize="false"
role="tablecontent">OOO</paragraph>
+ <paragraph id="par_id551737757538390" localize="false"
role="tablecontent">NNN</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id61537757587797" localize="false"
role="tablecontent">PPP</paragraph>
+ <paragraph id="par_id61537757587797" localize="false"
role="tablecontent">OOO</paragraph>
</tablecell>
</tablerow>
</table>
@@ -100,75 +101,49 @@
<paragraph id="par_id781737557200438" localize="false"
role="tablecontent">DDD</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id111737657268636" localize="false"
role="tablecontent">FFF</paragraph>
+ <paragraph id="par_id111737657268636" localize="false"
role="tablecontent">EEE</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id41737857307170" localize="false"
role="tablecontent">GGG</paragraph>
+ <paragraph id="par_id41737857307170" localize="false"
role="tablecontent">FFF</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id171739757353410" localize="false"
role="tablecontent">JJJ</paragraph>
+ <paragraph id="par_id171739757353410" localize="false"
role="tablecontent">III</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id11737057378330" localize="false"
role="tablecontent">KKK</paragraph>
+ <paragraph id="par_id11737057378330" localize="false"
role="tablecontent">JJJ</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id101737707481391" localize="false"
role="tablecontent">LLL</paragraph>
+ <paragraph id="par_id101737707481391" localize="false"
role="tablecontent">KKK</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id481737717510079" localize="false"
role="tablecontent">MMM</paragraph>
+ <paragraph id="par_id481737717510079" localize="false"
role="tablecontent">LLL</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id501737727523191" localize="false"
role="tablecontent">NNN</paragraph>
+ <paragraph id="par_id501737727523191" localize="false"
role="tablecontent">MMM</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id541737637538390" localize="false"
role="tablecontent">OOO</paragraph>
+ <paragraph id="par_id541737637538390" localize="false"
role="tablecontent">NNN</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id61737754587797" localize="false"
role="tablecontent">PPP</paragraph>
+ <paragraph id="par_id61737754587797" localize="false"
role="tablecontent">OOO</paragraph>
</tablecell></tablerow>
</table>
-<paragraph role="paragraph" id="par_id31737760079923">The formula
<input>=TOROW(A1:E3;1;TRUE())</input> returns the row below without the blank
cells, scanned by columns.</paragraph>
+<paragraph role="paragraph" id="par_id31737760079923">The formula
<input>{=TOROW(A1:E3;1;TRUE())}</input> returns the row below without the blank
cells, scanned by columns.</paragraph>
<table id="789">
<tablerow>
- <tablecell>
- <paragraph id="par_id641737758619870" localize="false"
role="tablecontent">AAA</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id41737857302170" localize="false"
role="tablecontent">GGG</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id101737707431391" localize="false"
role="tablecontent">LLL</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id531737357147927" localize="false"
role="tablecontent">BBB</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id481737717550079" localize="false"
role="tablecontent">MMM</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id631737457164454" localize="false"
role="tablecontent">CCC</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id501437727523191" localize="false"
role="tablecontent">NNN</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id781737557208438" localize="false"
role="tablecontent">DDD</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id371739757353410" localize="false"
role="tablecontent">JJJ</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id351737757538390" localize="false"
role="tablecontent">OOO</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id311787757268636" localize="false"
role="tablecontent">FFF</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id31737057378330" localize="false"
role="tablecontent">KKK</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id31737754587797" localize="false"
role="tablecontent">PPP</paragraph>
- </tablecell>
+ <tablecell><paragraph id="par_id641737758619870" localize="false"
role="tablecontent">AAA</paragraph></tablecell>
+ <tablecell><paragraph id="par_id41737857302170" localize="false"
role="tablecontent">FFF</paragraph></tablecell>
+ <tablecell><paragraph id="par_id101737707431391" localize="false"
role="tablecontent">KKK</paragraph></tablecell>
+ <tablecell><paragraph id="par_id531737357147927" localize="false"
role="tablecontent">BBB</paragraph></tablecell>
+ <tablecell><paragraph id="par_id481737717550079" localize="false"
role="tablecontent">LLL</paragraph></tablecell>
+ <tablecell><paragraph id="par_id631737457164454" localize="false"
role="tablecontent">CCC</paragraph></tablecell>
+ <tablecell><paragraph id="par_id501437727523191" localize="false"
role="tablecontent">MMM</paragraph></tablecell>
+ <tablecell><paragraph id="par_id781737557208438" localize="false"
role="tablecontent">DDD</paragraph></tablecell>
+ <tablecell><paragraph id="par_id371739757353410" localize="false"
role="tablecontent">III</paragraph></tablecell>
+ <tablecell><paragraph id="par_id351737757538390" localize="false"
role="tablecontent">NNN</paragraph></tablecell>
+ <tablecell><paragraph id="par_id311787757268636" localize="false"
role="tablecontent">EEE</paragraph></tablecell>
+ <tablecell><paragraph id="par_id31737057378330" localize="false"
role="tablecontent">JJJ</paragraph></tablecell>
+ <tablecell><paragraph id="par_id31737754587797" localize="false"
role="tablecontent">OOO</paragraph></tablecell>
</tablerow>
</table>
@@ -177,8 +152,10 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640870986703"
localize="false"><literal>COM.MICROSOFT.TOROW</literal></paragraph>
<section id="relatedtopics">
- <tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TOROW";>TOROW
wiki page</link>.</tip>
<embed href="text/scalc/01/func_tocol.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/TOROW";>TOROW
wiki page</link>.</tip>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_wrapcols.xhp
b/source/text/scalc/01/func_wrapcols.xhp
new file mode 100644
index 0000000000..15988454df
--- /dev/null
+++ b/source/text/scalc/01/func_wrapcols.xhp
@@ -0,0 +1,83 @@
+<?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_wrapcolsxhp" indexer="include" status="PUBLISH">
+ <title id="tit">WRAPCOLS function</title>
+ <filename>/text/scalc/01/func_wrapcols.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_WRAPCOLS_MS"
localize="false"/>
+<bookmark branch="index" id="bm_id361708283183878">
+ <bookmark_value>WRAPCOLS function</bookmark_value>
+</bookmark>
+<section id="wrapcols">
+ <h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_wrapcols.xhp">WRAPCOLS</link></variable></h1>
+ <paragraph id="par_id771708806478128" role="paragraph">Converts a single
row or column into multiple columns (a 2-demensional array) by specifying the
number of values in each column.</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_id871737825179033">=WRAPCOLS(Range, Wrap_count,
[Pad_with])</paragraph>
+<paragraph role="paragraph" id="par_id701737825446850"><emph>Range</emph>: the
range to wrap.</paragraph>
+<paragraph role="paragraph"
id="par_id441737825452403"><emph>Wrap_count</emph>: the maximum number of
values in each column.</paragraph>
+<paragraph role="paragraph" id="par_id411737825456380"><emph>Pad_with</emph>:
(optional) a specified value to pad if there are insufficient number of values.
By default, it returns #N/A to fill in the 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#wrapcolrowxmpl"/>
+<paragraph role="paragraph" id="par_id771738021783517">The formula
<input>{=WRAPCOLS(A1:A15;6)}</input> returns the array below. The missing
values are replaced by #N/A.</paragraph>
+<table id="123">
+ <tablerow>
+ <tablecell><paragraph id="par_id31738025144950" role="tablecontent"
localize="false">AAA</paragraph></tablecell>
+ <tablecell><paragraph id="par_id991738025148078" role="tablecontent"
localize="false">GGG</paragraph></tablecell>
+ <tablecell><paragraph id="par_id671738025154303" role="tablecontent"
localize="false">MMM</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id871738025158742" role="tablecontent"
localize="false">BBB</paragraph></tablecell>
+ <tablecell><paragraph id="par_id261738025162559" role="tablecontent"
localize="false">HHH</paragraph></tablecell>
+ <tablecell><paragraph id="par_id471738025165934" role="tablecontent"
localize="false">NNN</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id551738025169046" role="tablecontent"
localize="false">CCC</paragraph></tablecell>
+ <tablecell><paragraph id="par_id531738025172494" role="tablecontent"
localize="false">III</paragraph></tablecell>
+ <tablecell><paragraph id="par_id701738025177446" role="tablecontent"
localize="false">OOO</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id581738025181166" role="tablecontent"
localize="false">DDD</paragraph></tablecell>
+ <tablecell><paragraph id="par_id201738025186198" role="tablecontent"
localize="false">JJJ</paragraph></tablecell>
+ <tablecell><paragraph id="par_id311738025193094" role="tablecontent"
localize="false">#N/A</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id791738025198069" role="tablecontent"
localize="false">EEE</paragraph></tablecell>
+ <tablecell><paragraph id="par_id11738025202077" role="tablecontent"
localize="false">KKK</paragraph></tablecell>
+ <tablecell><paragraph id="par_id481738025205813" role="tablecontent"
localize="false">#N/A</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id911738025209068" role="tablecontent"
localize="false">FFF</paragraph></tablecell>
+ <tablecell><paragraph id="par_id261738025213589" role="tablecontent"
localize="false">LLL</paragraph></tablecell>
+ <tablecell><paragraph id="par_id121738025224237" role="tablecontent"
localize="false">#N/A</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.WRAPCOLS</literal></paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/func_wraprows.xhp#h1"/>
+ <embed href="text/scalc/01/func_torow.xhp#h1"/>
+ <embed href="text/scalc/01/func_tocol.xhp#h1"/>
+ <tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WRAPCOLS";>WRAPCOLS
wiki page</link>.</tip>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_wraprows.xhp
b/source/text/scalc/01/func_wraprows.xhp
new file mode 100644
index 0000000000..ea20f5504d
--- /dev/null
+++ b/source/text/scalc/01/func_wraprows.xhp
@@ -0,0 +1,76 @@
+<?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_wraprowsxhp" indexer="include" status="PUBLISH">
+ <title id="tit">WRAPROWS function</title>
+ <filename>/text/scalc/01/func_wraprows.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_WRAPROWS_MS"
localize="false"/>
+<bookmark branch="index" id="bm_id361708283183878">
+<bookmark_value>WRAPROWS function</bookmark_value>
+</bookmark>
+<section id="wraprows">
+ <h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_wraprows.xhp">WRAPROWS</link></variable></h1>
+ <paragraph id="par_id771708806478128" role="paragraph">Converts a single
row or column into multiple rows (a 2-demensional array) by specifying the
number of values in each row.</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_id871737825179033">=WRAPROWS(Range, Wrap_count,
[Pad_with])</paragraph>
+<paragraph role="paragraph" id="par_id701737825446850"><emph>Range</emph>: the
range to wrap.</paragraph>
+<paragraph role="paragraph"
id="par_id441737825452403"><emph>Wrap_count</emph>: the maximum number of
values in each column.</paragraph>
+<paragraph role="paragraph" id="par_id411737825456380"><emph>Pad_with</emph>:
(optional) a specified value to pad if there are insufficient number of values.
By default, it returns #N/A to fill in the 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#wrapcolrowxmpl"/>
+<paragraph role="paragraph" id="par_id771738021783517">The formula
<input>{=WRAPROWS(A1:A15;4)}</input> returns the array below. The missing
values are replaced by #N/A.</paragraph>
+<table id="123">
+ <tablerow>
+ <tablecell><paragraph id="par_id171738025039817" role="tablecontent"
localize="false">AAA</paragraph></tablecell>
+ <tablecell><paragraph id="par_id71738025044433" role="tablecontent"
localize="false">BBB</paragraph></tablecell>
+ <tablecell><paragraph id="par_id211738025049474" role="tablecontent"
localize="false">CCC</paragraph></tablecell>
+ <tablecell><paragraph id="par_id761738025053633" role="tablecontent"
localize="false">DDD</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id301738025081985" role="tablecontent"
localize="false">EEE</paragraph></tablecell>
+ <tablecell><paragraph id="par_id641738025075185" role="tablecontent"
localize="false">FFF</paragraph></tablecell>
+ <tablecell><paragraph id="par_id181738025070658" role="tablecontent"
localize="false">GGG</paragraph></tablecell>
+ <tablecell><paragraph id="par_id611738025064337" role="tablecontent"
localize="false">HHH</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id851738025092321" role="tablecontent"
localize="false">III</paragraph></tablecell>
+ <tablecell><paragraph id="par_id51738025098112" role="tablecontent"
localize="false">JJJ</paragraph></tablecell>
+ <tablecell><paragraph id="par_id491738025103320" role="tablecontent"
localize="false">KKK</paragraph></tablecell>
+ <tablecell><paragraph id="par_id941738025107272" role="tablecontent"
localize="false">LLL</paragraph></tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell><paragraph id="par_id471738025115008" role="tablecontent"
localize="false">MMM</paragraph></tablecell>
+ <tablecell><paragraph id="par_id581738025119728" role="tablecontent"
localize="false">NNN</paragraph></tablecell>
+ <tablecell><paragraph id="par_id671738025124487" role="tablecontent"
localize="false">OOO</paragraph></tablecell>
+ <tablecell><paragraph id="par_id861738025129360" role="tablecontent"
localize="false">#N/A</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.WRAPROWS</literal></paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
+ <embed href="text/scalc/01/func_tocol.xhp#h1"/>
+ <embed href="text/scalc/01/func_torow.xhp#h1"/>
+ <tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WRAPROWS";>WRAPROWS
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 3d8a5baf55..f7e662f83b 100644
--- a/source/text/scalc/01/stat_data.xhp
+++ b/source/text/scalc/01/stat_data.xhp
@@ -27,7 +27,7 @@
<h3 id="hd_id1000020">Grouped By</h3>
<paragraph id="par_id1000030" role="paragraph">Select whether the
input data has <emph>columns</emph> or <emph>rows</emph> layout.</paragraph>
</section>
-
+
<section id="otherstat">
<embed href="text/scalc/01/statistics_sampling.xhp#datasamplingh1"/>
<embed
href="text/scalc/01/statistics_descriptive.xhp#descriptivestatisticsh1"/>
@@ -43,15 +43,13 @@
<embed href="text/scalc/01/statistics_test_chisqr.xhp#chisqtesth1"/>
<embed href="text/scalc/01/statistics_fourier.xhp#fourieranalysysh1"/>
</section>
-
<section id="sampledata01">
-
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id1000040" role="paragraph">The following data will
be used as example </paragraph>
-
<table id="Tabela3">
<tablerow>
<tablecell>
+ <paragraph localize="false" role="tablehead"
id="par_id501438013481906"> </paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1000050" localize="false"
role="tablehead">A</paragraph>
@@ -138,6 +136,7 @@
<paragraph id="par_id1000280" role="tablehead"
localize="false">6</paragraph>
</tablecell>
<tablecell>
+ <paragraph localize="false" role="tablecontent"
id="par_id503738013481906"> </paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1000290" role="tablecontent"
localize="false">38</paragraph>
@@ -224,8 +223,10 @@
<paragraph id="par_id1000520" role="tablecontent"
localize="false">57</paragraph>
</tablecell>
<tablecell>
+ <paragraph localize="false" role="tablecontent"
id="par_id511738013481906"> </paragraph>
</tablecell>
<tablecell>
+ <paragraph localize="false" role="tablecontent"
id="par_id501738013489906"> </paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -236,22 +237,22 @@
<paragraph id="par_id1000540" role="tablecontent"
localize="false">26</paragraph>
</tablecell>
<tablecell>
+ <paragraph localize="false" role="tablecontent"
id="par_id501638013481906"> </paragraph>
</tablecell>
<tablecell>
+ <paragraph localize="false" role="tablecontent"
id="par_id501738013481907"> </paragraph>
</tablecell>
</tablerow>
</table>
-
</section>
-
<section id="timeseries01">
-
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id1000550" role="paragraph">The following table has
two time series, one representing an impulse function at time t=0 and the other
an impulse function at time t=2.</paragraph>
<table id="Tabela8">
<tablerow>
<tablecell>
+ <paragraph localize="false" role="tablehead"
id="par_id501735513481906"> </paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1000560" role="tablehead"
localize="false">A</paragraph>
@@ -404,17 +405,14 @@
</tablecell>
</tablerow>
</table>
-
</section>
-
<section id="datafortests">
-
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id1000970" role="paragraph">The following table has
two data sets.</paragraph>
-
<table id="Tabela9">
<tablerow>
<tablecell>
+ <paragraph localize="false" role="tablehead"
id="par_id501738013466906"> </paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1000980" role="tablehead"
localize="false">A</paragraph>
@@ -577,6 +575,7 @@
<table id="table regression">
<tablerow>
<tablecell>
+ <paragraph localize="false" role="tablehead"
id="par_id501738013481886"> </paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id170120161940524" role="tablehead"
localize="false">A</paragraph>
@@ -1332,6 +1331,145 @@
</tablerow>
</table>
</section>
+ <section id="tocolrowxmpl">
+<paragraph role="paragraph" id="par_id71737757692138">Consider the array
<literal>A1:E3</literal> below.</paragraph>
+<table id="tab_id831737756798511">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id21738043463851" localize="false"
role="tablehead"> </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id581737756798511" localize="false"
role="tablehead">A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211747756798511" localize="false"
role="tablehead">B</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211737756798511" localize="false"
role="tablehead">C</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211757756798511" localize="false"
role="tablehead">D</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211737756598511" localize="false"
role="tablehead">E</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id941737757138103" localize="false"
role="tablehead">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id811737757160471" localize="false"
role="tablecontent">AAA</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id531737757177927" localize="false"
role="tablecontent">BBB</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id631737757194454" localize="false"
role="tablecontent">CCC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id781737757200438" localize="false"
role="tablecontent">DDD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111737757268636" localize="false"
role="tablecontent">EEE</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id291737757283307" localize="false"
role="tablehead">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id41737757307170" localize="false"
role="tablecontent">FFF</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph localize="false" role="tablecontent"
id="par_id501738013481906"> </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph localize="false" role="tablecontent"
id="par_id311738013491010"> </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id171737757353410" localize="false"
role="tablecontent">III</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id11737757378330" localize="false"
role="tablecontent">JJJ</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id951737757455696" localize="false"
role="tablehead">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id101737757481391" localize="false"
role="tablecontent">KKK</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id481737757510079" localize="false"
role="tablecontent">LLL</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501737757523191" localize="false"
role="tablecontent">MMM</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id541737757538390" localize="false"
role="tablecontent">NNN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id61737757587797" localize="false"
role="tablecontent">OOO</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+</section>
+<section id="wrapcolrowxmpl">
+ <paragraph role="paragraph" id="par_id71737753692138"> Consider the array
<literal>A1:A15</literal> below.</paragraph>
+ <table id="tab_id501738022561700">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id21738013463851" localize="false"
role="tablehead">A</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id641747758609870" localize="false"
role="tablecontent">AAA</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id531757757177927" localize="false"
role="tablecontent">BBB</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id631767757194454" localize="false"
role="tablecontent">CCC</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id781777757200438" localize="false"
role="tablecontent">DDD</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id111787757268636" localize="false"
role="tablecontent">EEE</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id41737757317170" localize="false"
role="tablecontent">FFF</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id481737759439442" localize="false"
role="tablecontent">GGG</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id601737759486665" localize="false"
role="tablecontent">HHH</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id171737757323410" localize="false"
role="tablecontent">III</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id11737757372330" localize="false"
role="tablecontent">JJJ</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id101737757485391" localize="false"
role="tablecontent">KKK</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id481737757510679" localize="false"
role="tablecontent">LLL</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id501737757523171" localize="false"
role="tablecontent">MMM</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id551737757538390" localize="false"
role="tablecontent">NNN</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id61537757587797" localize="false"
role="tablecontent">OOO</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
</body>
-
</helpdocument>
diff --git a/source/text/scalc/01/statistics_sampling.xhp
b/source/text/scalc/01/statistics_sampling.xhp
index 4550c5b828..35d34bb101 100644
--- a/source/text/scalc/01/statistics_sampling.xhp
+++ b/source/text/scalc/01/statistics_sampling.xhp
@@ -52,6 +52,7 @@
<table id="Tabela1">
<tablerow>
<tablecell>
+<paragraph id="par_id1100120" role="tablehead"
localize="false"> </paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1000120" role="tablehead" localize="false">A</paragraph>
