AllLangHelp_scalc.mk | 2
source/text/scalc/00/avail_release.xhp | 6
source/text/scalc/01/func_tocol.xhp | 272 +++++++++++++++++++++++++++++++++
source/text/scalc/01/func_torow.xhp | 184 ++++++++++++++++++++++
4 files changed, 464 insertions(+)
New commits:
commit c0ab5d8cbdbf455565c655539e50dd7669a02b59
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Jan 24 21:58:40 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Jan 26 20:41:18 2025 +0100
tdf#150879, tdf#150878 TOROW() + TOCOL() Help pages
Change-Id: Ib23a32caf6c652fd8d8f3e490465062a8c3c9d12
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/180733
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 3d1111f6eb..4581269333 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -283,6 +283,8 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_substitute \
helpcontent2/source/text/scalc/01/func_t \
helpcontent2/source/text/scalc/01/func_text \
+ helpcontent2/source/text/scalc/01/func_tocol \
+ helpcontent2/source/text/scalc/01/func_torow \
helpcontent2/source/text/scalc/01/func_trim \
helpcontent2/source/text/scalc/01/func_unichar \
helpcontent2/source/text/scalc/01/func_unicode \
diff --git a/source/text/scalc/00/avail_release.xhp
b/source/text/scalc/00/avail_release.xhp
index d0b17175bc..a764e90b20 100644
--- a/source/text/scalc/00/avail_release.xhp
+++ b/source/text/scalc/00/avail_release.xhp
@@ -101,5 +101,11 @@
<section id="24.8">
<tip id="par_id491708280768121">This function is available since
%PRODUCTNAME 24.8.</tip>
</section>
+ <section id="25.2">
+ <tip id="par_id491708380768121">This function is available since
%PRODUCTNAME 25.2.</tip>
+ </section>
+ <section id="25.8">
+ <tip id="par_id491738280768121">This function is available since
%PRODUCTNAME 25.8.</tip>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_tocol.xhp
b/source/text/scalc/01/func_tocol.xhp
new file mode 100644
index 0000000000..a6c93b517f
--- /dev/null
+++ b/source/text/scalc/01/func_tocol.xhp
@@ -0,0 +1,272 @@
+<?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_tocolxhp" indexer="include" status="PUBLISH">
+ <title id="tit">TOCOL function</title>
+ <filename>/text/scalc/01/func_tocol.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_TOCOL_MS"
localize="false"/>
+<bookmark branch="index" id="bm_id361708283183878">
+<bookmark_value>TOCOL function</bookmark_value>
+</bookmark>
+<section id="tocol">
+ <h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_tocol.xhp">TOCOL</link></variable></h1>
+ <paragraph id="par_id771708806478128" role="paragraph">Transforms an array
or range into a single 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_id851737751444186">TOCOL(Array; [Ignore];
[By_column])</paragraph>
+<paragraph role="paragraph" id="par_id391737751833481"><emph>Array</emph>: the
array or range to return as a single column.</paragraph>
+
+<section id="tocolrowargs">
+<paragraph role="paragraph" id="par_id31737751839305"><emph>Ignore</emph>:
(optional) Whether to ignore certain types of values. By default, no values are
ignored. Specify one of the following:</paragraph>
+<paragraph id="par_id971737751690332" role="paragraph"><emph>0</emph>: Keep
all values (default)</paragraph>
+<paragraph id="par_id381737751703531" role="paragraph"><emph>1</emph>: Ignore
blank cells</paragraph>
+<paragraph id="par_id931737751715731" role="paragraph"><emph>2</emph>: Ignore
cells with errors</paragraph>
+<paragraph id="par_id101737751728979" role="paragraph"><emph>3</emph>: Ignore
both blank cells and error cells</paragraph>
+<paragraph role="paragraph" id="par_id771737751844889"><emph>By_column</emph>:
(optional) Scan the array by column. By default, the array is scanned by row.
Scanning determines whether the values are ordered by row or by
column.</paragraph>
+</section>
+
+<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>
+<table id="123">
+ <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">FFF</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id41737757317170" localize="false"
role="tablecontent">GGG</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph localize="false" role="paragraph"
id="par_id481737759439442"> </paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph localize="false" role="paragraph"
id="par_id601737759486665"> </paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id171737757323410" localize="false"
role="tablecontent">JJJ</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id11737757372330" localize="false"
role="tablecontent">KKK</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id101737757485391" localize="false"
role="tablecontent">LLL</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id481737757510679" localize="false"
role="tablecontent">MMM</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id501737757523171" localize="false"
role="tablecontent">NNN</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id551737757538390" localize="false"
role="tablecontent">OOO</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id61537757587797" localize="false"
role="tablecontent">PPP</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>
+<table id="456">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id641737758609870" localize="false"
role="tablecontent">AAA</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id531737357177927" localize="false"
role="tablecontent">BBB</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id631737457194454" localize="false"
role="tablecontent">CCC</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id781737557200438" localize="false"
role="tablecontent">DDD</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id111737657268636" localize="false"
role="tablecontent">FFF</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id41737857307170" localize="false"
role="tablecontent">GGG</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id171739757353410" localize="false"
role="tablecontent">JJJ</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id11737057378330" localize="false"
role="tablecontent">KKK</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id101737707481391" localize="false"
role="tablecontent">LLL</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id481737717510079" localize="false"
role="tablecontent">MMM</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id501737727523191" localize="false"
role="tablecontent">NNN</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id541737637538390" localize="false"
role="tablecontent">OOO</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id61737754587797" localize="false"
role="tablecontent">PPP</paragraph>
+ </tablecell></tablerow>
+</table>
+
+<paragraph role="paragraph" id="par_id31737760079923">The formula
<input>=TOCOL(A1:E3;1;TRUE())</input> returns the column 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></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id41737857302170" localize="false"
role="tablecontent">GGG</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id101737707431391" localize="false"
role="tablecontent">LLL</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>
+ </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>
+ </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>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id351737757538390" localize="false"
role="tablecontent">OOO</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id311787757268636" localize="false"
role="tablecontent">FFF</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id31737057378330" localize="false"
role="tablecontent">KKK</paragraph>
+ </tablecell></tablerow><tablerow>
+ <tablecell>
+ <paragraph id="par_id31737754587797" localize="false"
role="tablecontent">PPP</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.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"/>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_torow.xhp
b/source/text/scalc/01/func_torow.xhp
new file mode 100644
index 0000000000..4f90ecefa9
--- /dev/null
+++ b/source/text/scalc/01/func_torow.xhp
@@ -0,0 +1,184 @@
+<?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_torowxhp" indexer="include" status="PUBLISH">
+ <title id="tit">TOROW function</title>
+ <filename>/text/scalc/01/func_torow.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_TOROW_MS"
localize="false"/>
+<bookmark branch="index" id="bm_id361708283183878">
+<bookmark_value>TOROW function</bookmark_value>
+</bookmark>
+<section id="torow">
+ <h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_torow.xhp">TOROW</link></variable></h1>
+ <paragraph id="par_id771708806478128" role="paragraph">Transforms an array
or range into a single 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_id851737751444186">TOROW(Array, [Ignore],
[By_column])</paragraph>
+<paragraph role="paragraph" id="par_id391737751833481"><emph>Array</emph>: the
array or range to return as a single row.</paragraph>
+<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"/>
+
+<paragraph role="paragraph" id="par_id711737758586509">The formula
<input>=TOROW(A1:E3)</input> returns the row</paragraph>
+<table id="123">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id641747758609870" localize="false"
role="tablecontent">AAA</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id531757757177927" localize="false"
role="tablecontent">BBB</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id631767757194454" localize="false"
role="tablecontent">CCC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id781777757200438" localize="false"
role="tablecontent">DDD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111787757268636" localize="false"
role="tablecontent">FFF</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id41737757317170" localize="false"
role="tablecontent">GGG</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph localize="false" role="paragraph"
id="par_id481737759439442"> </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph localize="false" role="paragraph"
id="par_id601737759486665"> </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id171737757323410" localize="false"
role="tablecontent">JJJ</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id11737757372330" localize="false"
role="tablecontent">KKK</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id101737757485391" localize="false"
role="tablecontent">LLL</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id481737757510679" localize="false"
role="tablecontent">MMM</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501737757523171" localize="false"
role="tablecontent">NNN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id551737757538390" localize="false"
role="tablecontent">OOO</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id61537757587797" localize="false"
role="tablecontent">PPP</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+
+<paragraph role="paragraph" id="par_id351737760079923">The formula
<input>=TOROW(A1:E3;1)</input> returns the row below without the blank
cells.</paragraph>
+<table id="456">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id641737758609870" localize="false"
role="tablecontent">AAA</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id531737357177927" localize="false"
role="tablecontent">BBB</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id631737457194454" localize="false"
role="tablecontent">CCC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id781737557200438" localize="false"
role="tablecontent">DDD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111737657268636" localize="false"
role="tablecontent">FFF</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id41737857307170" localize="false"
role="tablecontent">GGG</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id171739757353410" localize="false"
role="tablecontent">JJJ</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id11737057378330" localize="false"
role="tablecontent">KKK</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id101737707481391" localize="false"
role="tablecontent">LLL</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id481737717510079" localize="false"
role="tablecontent">MMM</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501737727523191" localize="false"
role="tablecontent">NNN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id541737637538390" localize="false"
role="tablecontent">OOO</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id61737754587797" localize="false"
role="tablecontent">PPP</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>
+<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>
+ </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.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"/>
+</section>
+</body>
+</helpdocument>
