source/text/scalc/01/common_func.xhp | 8 +++++-
source/text/scalc/01/func_averageif.xhp | 2 -
source/text/scalc/01/func_choosecols.xhp | 9 +++++--
source/text/scalc/01/func_chooserows.xhp | 9 +++++--
source/text/scalc/01/func_drop.xhp | 11 ++++++--
source/text/scalc/01/func_expand.xhp | 10 ++++++--
source/text/scalc/01/func_filter.xhp | 2 -
source/text/scalc/01/func_hstack.xhp | 28 +++++++++++++---------
source/text/scalc/01/func_let.xhp | 2 -
source/text/scalc/01/func_sequence.xhp | 2 -
source/text/scalc/01/func_take.xhp | 13 ++++++----
source/text/scalc/01/func_tocol.xhp | 12 +++++++--
source/text/scalc/01/func_torow.xhp | 11 +++++++-
source/text/scalc/01/func_unique.xhp | 4 +--
source/text/scalc/01/func_vstack.xhp | 38 +++++++++++++++++--------------
source/text/scalc/01/func_wrapcols.xhp | 21 +++++++++++------
source/text/scalc/01/func_wraprows.xhp | 15 ++++++++----
17 files changed, 131 insertions(+), 66 deletions(-)
New commits:
commit 59b3b34772dc046c393d4b31570a4262cfd523ef
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun Feb 9 09:26:41 2025 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Feb 9 13:29:40 2025 +0100
Fix some new functions Help pages
+ Refactor for less translation
+ cross links between help pages
+ fix syntax definitions
+ other changes for readability
Change-Id: I1c93ad3ef7b65f88b02afecff2d1ac706f1c75ea
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/181314
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/common_func.xhp
b/source/text/scalc/01/common_func.xhp
index 1d8fb882e4..0298850942 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -31,7 +31,7 @@
<h3 id="hd_id371655560095924">See also</h3>
</section>
<section id="notODFF">
- <paragraph role="paragraph" id="par_id251640873774457">This function
is not part of the <emph>Open Document Format for Office Applications
(OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula)
Format</emph> standard. The name space is</paragraph>
+ <paragraph role="paragraph" id="par_id251640873774457">This function
is <emph>NOT</emph> part of the <emph>Open Document Format for Office
Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula
(OpenFormula) Format</emph> standard. The name space is</paragraph>
</section>
<section id="datenumbersequencenote">
<note id="par_id301616845402409">This function ignores any text or
empty cell within a data range. If you suspect wrong results from this
function, look for text in the data ranges. To highlight text contents in a
data range, use the <link href="text/scalc/01/03080000.xhp">value
highlighting</link> feature.</note>
@@ -39,5 +39,11 @@
<section id="optional_args">
<note id="par_id431716730587722">Any of the optional arguments can be
omitted. An optional argument requires all preceding separators to be
present.</note>
</section>
+ <section id="array">
+ <note id="par_id131711543270539">Enter the formula as an <link
href="text/scalc/01/04060107.xhp">array formula</link>. Hint: enter formula
using keys <keycode>Ctrl + Shift + Enter</keycode>.</note>
+ </section>
+ <section id="NAinTable">
+ <paragraph role="paragraph" id="par_id221739098585036"><variable
id="NA_in_table">#N/A</variable></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_averageif.xhp
b/source/text/scalc/01/func_averageif.xhp
index 9334626f56..e637b60f0a 100644
--- a/source/text/scalc/01/func_averageif.xhp
+++ b/source/text/scalc/01/func_averageif.xhp
@@ -28,7 +28,7 @@
</section>
<embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph id="par_id200801176228491" role="code">AVERAGEIF(Range; Criterion
[; Average_Range ])</paragraph>
+<paragraph id="par_id200801176228491" role="code">=AVERAGEIF(Range; Criterion
[; Average_Range ])</paragraph>
<paragraph id="par_id15226321619829" role="paragraph"><emph>Range</emph> –
required argument. An array, a name of named range or a label of a column or a
row containing numbers for averaging or numbers or text for the
condition.</paragraph>
<embed href="text/scalc/01/ex_data_stat_func.xhp#criterion"/>
<embed href="text/shared/00/00000001.xhp#regex"/>
diff --git a/source/text/scalc/01/func_choosecols.xhp
b/source/text/scalc/01/func_choosecols.xhp
index bb443da766..e5e88d73bf 100644
--- a/source/text/scalc/01/func_choosecols.xhp
+++ b/source/text/scalc/01/func_choosecols.xhp
@@ -24,9 +24,9 @@
<h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_choosecols.xhp">CHOOSECOLS</link></variable></h1>
<paragraph id="par_id771708806478128" role="paragraph">Returns the
specified columns from an 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/common_func.xhp#array"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code"
id="par_id601738075517060"><input>=CHOOSECOLS(Array;Column_1;[Column_2;[Column_3;[...]]])</input>
</paragraph>
+<paragraph role="code" id="par_id601738075517060">=CHOOSECOLS(Array; Column_1
[; Column_2 [; Column_3 [; ...]]]) </paragraph>
<paragraph role="paragraph" id="par_id81738076052161"><emph>Array</emph>: The
array containing the columns to be returned in a new array.</paragraph>
<paragraph role="paragraph" id="par_id191738076047602"><emph>Column_1</emph>:
The index of the first column to be returned. A negative value chooses from the
end of the array.</paragraph>
<paragraph role="paragraph" id="par_id1001738076043608"><emph>Column_2;
Column_3; ...</emph>: (optional) The list of other column indexes to be
returned. A negative value chooses from the end of the array.</paragraph>
@@ -81,6 +81,11 @@
<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"/>
+ <embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSECOLS";>CHOOSECOLS
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_chooserows.xhp
b/source/text/scalc/01/func_chooserows.xhp
index 2ba53cba4f..a9eed14113 100644
--- a/source/text/scalc/01/func_chooserows.xhp
+++ b/source/text/scalc/01/func_chooserows.xhp
@@ -24,9 +24,9 @@
<h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_chooserows.xhp">CHOOSEROWS</link></variable></h1>
<paragraph id="par_id771708806478128" role="paragraph">Returns the
specified rows from an 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/common_func.xhp#array"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code"
id="par_id601738075517060"><input>=CHOOSEROWS(Array;Row_1;[Row_2;[Row_3;[...]]])</input>
</paragraph>
+<paragraph role="code" id="par_id601738075517060">=CHOOSEROWS(Array; Row_1 [;
Row_2 [; Row_3 [; ...]]]) </paragraph>
<paragraph role="paragraph" id="par_id81738076052161"><emph>Array</emph>: The
array containing the rows to be returned in a new array.</paragraph>
<paragraph role="paragraph" id="par_id191738076047602"><emph>Row_1</emph>: The
index of the first row to be returned. A negative value chooses from the end of
the array.</paragraph>
<paragraph role="paragraph" id="par_id1001738076043608"><emph>Row_2; Row_3;
...</emph>: (optional) The list of other row indexes to be returned. A negative
value chooses from the end of the array.</paragraph>
@@ -82,6 +82,11 @@
<embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
<embed href="text/scalc/01/func_wraprows.xhp#h1"/>
<embed href="text/scalc/01/func_choosecols.xhp#h1"/>
+ <embed href="text/scalc/01/func_vstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSEROWS";>CHOOSEROWS
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_drop.xhp
b/source/text/scalc/01/func_drop.xhp
index 02edc3d751..c20e90a95c 100644
--- a/source/text/scalc/01/func_drop.xhp
+++ b/source/text/scalc/01/func_drop.xhp
@@ -24,9 +24,9 @@
<h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_drop.xhp">DROP</link></variable></h1>
<paragraph id="par_id771708806478128" role="paragraph">Drops a specified
number of contiguous rows or columns from the start or end of an
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/common_func.xhp#array"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id851737751444186">DROP(Array; Row;
[Column])</paragraph>
+<paragraph role="code" id="par_id851737751444186">DROP(Array; Rows [;
Columns])</paragraph>
<paragraph role="paragraph" id="par_id391737751833481"><emph>Array</emph>: the
array or range from which to drop rows or columns.</paragraph>
<paragraph role="paragraph" id="par_id111738104866763"><emph>Rows</emph>: the
number of rows to drop. A negative value drops from the end of the
array.</paragraph>
<paragraph role="paragraph" id="par_id111738104891522"><emph>Columns</emph>:
(optional) the number of columns to drop. A negative value drops from the end
of the array.</paragraph>
@@ -63,11 +63,16 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640870986703"
localize="false"><literal>COM.MICROSOFT.DROP</literal></paragraph>
<section id="relatedtopics">
- <embed href="text/scalc/01/func_take.xhp#h1"/>
<embed href="text/scalc/01/func_tocol.xhp#h1"/>
<embed href="text/scalc/01/func_torow.xhp#h1"/>
<embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
<embed href="text/scalc/01/func_wraprows.xhp#h1"/>
+ <embed href="text/scalc/01/func_chooserows.xhp#h1"/>
+ <embed href="text/scalc/01/func_choosecols.xhp#h1"/>
+ <embed href="text/scalc/01/func_vstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/DROP";>DROP
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_expand.xhp
b/source/text/scalc/01/func_expand.xhp
index 8058c054c3..fa424aaede 100644
--- a/source/text/scalc/01/func_expand.xhp
+++ b/source/text/scalc/01/func_expand.xhp
@@ -24,9 +24,9 @@
<h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_expand.xhp">EXPAND</link></variable></h1>
<paragraph id="par_id771708806478128" role="paragraph">Expand an array by
adding rows or columns.</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/common_func.xhp#array"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code"
id="par_id601738075517060"><input>=EXPAND(Array;Rows;[Columns];[Pad_with])</input>
</paragraph>
+<paragraph role="code" id="par_id601738075517060">=EXPAND(Array; Rows [;
Columns [; Pad_with]]) </paragraph>
<paragraph role="paragraph" id="par_id81738076052161"><emph>Array</emph>: the
array or range to expand by the number of rows and/or columns.</paragraph>
<paragraph role="paragraph" id="par_id191738076047602"><emph>Rows</emph>: the
final number of rows the array will expand. Default is total rows.</paragraph>
<paragraph role="paragraph" id="par_id1001738076043608"><emph>Columns</emph>:
(optional) The final number of columns the array will expand. Default is total
columns.</paragraph>
@@ -84,6 +84,12 @@
<embed href="text/scalc/01/func_torow.xhp#h1"/>
<embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
<embed href="text/scalc/01/func_wraprows.xhp#h1"/>
+ <embed href="text/scalc/01/func_chooserows.xhp#h1"/>
+ <embed href="text/scalc/01/func_choosecols.xhp#h1"/>
+ <embed href="text/scalc/01/func_vstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/EXPAND";>EXPAND
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_filter.xhp
b/source/text/scalc/01/func_filter.xhp
index 2fd955f164..410fa0a13e 100644
--- a/source/text/scalc/01/func_filter.xhp
+++ b/source/text/scalc/01/func_filter.xhp
@@ -25,7 +25,7 @@
<paragraph id="par_id771708806478128" role="paragraph">Filters a data
range or array based on specified conditions.</paragraph>
</section>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id211708281649651">FILTER( Range; Criteria [;
Return if empty])</paragraph>
+<paragraph role="code" id="par_id211708281649651">=FILTER( Range; Criteria [;
Return if empty])</paragraph>
<paragraph role="paragraph" id="par_id411709395137111"><emph>Range</emph>: The
array or range to filter.</paragraph>
<paragraph role="paragraph" id="par_id471709395141324"><emph>Criteria</emph>:
A boolean array whose height (filtering by columns) or width (filtering by
rows) is the same as the array, used to select data from the
<emph>Range</emph>.</paragraph>
<paragraph role="paragraph" id="par_id421709395146863"><emph>Result if
empty</emph>: (optional) the value to return if all values in the
<emph>Criteria</emph> array are empty (filter return nothing).</paragraph>
diff --git a/source/text/scalc/01/func_hstack.xhp
b/source/text/scalc/01/func_hstack.xhp
index e13c90056d..45500425e8 100644
--- a/source/text/scalc/01/func_hstack.xhp
+++ b/source/text/scalc/01/func_hstack.xhp
@@ -24,9 +24,9 @@
<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/common_func.xhp#array"/>
<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="code" id="par_id601738075517060">=HSTACK(Array [; Array_1 [;
Array_2;[...]]]) </paragraph>
<paragraph role="paragraph" id="par_id81738076052161"><emph>Array</emph>: The
first array to be returned in a new array.</paragraph>
<paragraph role="paragraph" id="par_id1001738076043608"><emph>Array_1;
Array_2; ...</emph>: (optional) the arrays to append sequentially after the
previous array.</paragraph>
<embed href="text/scalc/01/common_func.xhp#optional_args"/>
@@ -66,20 +66,20 @@
<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_id531739053910655" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id751739053913950" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id901739053919430" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id971739053922678" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id661739053925502" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id401739053928622" role="tablecontent"
localize="false">VVV</paragraph></tablecell>
<tablecell><paragraph id="par_id331739053931582" role="tablecontent"
localize="false">WWW</paragraph></tablecell>
</tablerow>
<tablerow>
- <tablecell><paragraph id="par_id21739053937150" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/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_id21739053937150" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id391739053940086" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id91739053943062" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id21739053946189" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id301739053949109" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
<tablecell><paragraph id="par_id841739053952093" role="tablecontent"
localize="false">XXX</paragraph></tablecell>
<tablecell><paragraph id="par_id121739053955061" role="tablecontent"
localize="false">YYY</paragraph></tablecell>
</tablerow>
@@ -95,7 +95,11 @@
<embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
<embed href="text/scalc/01/func_wraprows.xhp#h1"/>
<embed href="text/scalc/01/func_chooserows.xhp#h1"/>
+ <embed href="text/scalc/01/func_choosecols.xhp#h1"/>
<embed href="text/scalc/01/func_vstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/HSTACK";>HSTACK
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_let.xhp
b/source/text/scalc/01/func_let.xhp
index 610d883248..60216f2d2a 100644
--- a/source/text/scalc/01/func_let.xhp
+++ b/source/text/scalc/01/func_let.xhp
@@ -25,7 +25,7 @@
<paragraph id="par_id71717677746935" role="paragraph">Assigns names to
calculation results. This allows storing intermediate calculations, values, or
defining names inside a formula. These names only apply within the scope of the
LET function.</paragraph>
</section>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id211708281649651">LET(Name1; Name_value1;
Calculation_or_Name2; [Name_value2; Calculation_or_Name3 [; ...]])</paragraph>
+<paragraph role="code" id="par_id211708281649651">=LET(Name1; Name_value1;
Calculation_or_Name2 [; Name_value2; Calculation_or_Name3 [; ...]])</paragraph>
<paragraph role="paragraph" id="par_id301717681619674"><emph>Name1</emph>: the
first name to assign. Must start with a letter. Cannot be the output of a
formula or conflict with range syntax.</paragraph>
<note id="par_id721717688901981">Name1 must follow the <link
href="text/scalc/guide/value_with_name.xhp">naming rules of %PRODUCTNAME
Calc</link>.</note>
diff --git a/source/text/scalc/01/func_sequence.xhp
b/source/text/scalc/01/func_sequence.xhp
index 00537e7516..5fdf23d3c2 100644
--- a/source/text/scalc/01/func_sequence.xhp
+++ b/source/text/scalc/01/func_sequence.xhp
@@ -25,7 +25,7 @@
<paragraph id="par_id771708806478128" role="paragraph">Generate a list of
sequential numbers in an array.</paragraph>
</section>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id211708281649651">SEQUENCE(Rows; Columns [;
Start [; Step ] ])</paragraph>
+<paragraph role="code" id="par_id211708281649651">=SEQUENCE(Rows; Columns [;
Start [; Step ]])</paragraph>
<paragraph role="paragraph" id="par_id601714592655068"><emph>Rows</emph>: a
positive integer. The number of rows to return.</paragraph>
<paragraph role="paragraph" id="par_id521714592660164"><emph>Columns</emph>: a
positive integer. The number of columns to return.</paragraph>
<paragraph role="paragraph" id="par_id171714592664667"><emph>Start</emph>:
optional. The initial value of the sequence. If omitted, default is
1.</paragraph>
diff --git a/source/text/scalc/01/func_take.xhp
b/source/text/scalc/01/func_take.xhp
index 6f44b6efe3..5831661c17 100644
--- a/source/text/scalc/01/func_take.xhp
+++ b/source/text/scalc/01/func_take.xhp
@@ -24,17 +24,15 @@
<h1 id="hd_id901708806478126"><variable id="h1"><link
href="text/scalc/01/func_take.xhp">TAKE</link></variable></h1>
<paragraph id="par_id771708806478128" role="paragraph">Returns a specified
number of contiguous rows or columns from the start or end of an
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/common_func.xhp#array"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id851737751444186">TAKE(Array; Row;
[Column])</paragraph>
+<paragraph role="code" id="par_id851737751444186">=TAKE(Array; Rows [;
Columns])</paragraph>
<paragraph role="paragraph" id="par_id391737751833481"><emph>Array</emph>: the
array or range from which to take rows or columns.</paragraph>
<paragraph role="paragraph" id="par_id111738104866763"><emph>Rows</emph>: the
number of rows to take. A negative value takes from the end of the
array.</paragraph>
<paragraph role="paragraph" id="par_id111738104891522"><emph>Columns</emph>:
(optional) the number of columns to take. A negative value takes from the end
of the 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_id711737758586509">The formula
<input>{=TAKE(A1:E3;;1)}</input> returns the array with 3 rows (default) and 3
columns.</paragraph>
<table id="123">
<tablerow>
@@ -87,11 +85,16 @@
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
<paragraph role="paragraph" id="par_id341640870986703"
localize="false"><literal>COM.MICROSOFT.TAKE</literal></paragraph>
<section id="relatedtopics">
- <embed href="text/scalc/01/func_drop.xhp#h1"/>
<embed href="text/scalc/01/func_tocol.xhp#h1"/>
<embed href="text/scalc/01/func_torow.xhp#h1"/>
<embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
<embed href="text/scalc/01/func_wraprows.xhp#h1"/>
+ <embed href="text/scalc/01/func_chooserows.xhp#h1"/>
+ <embed href="text/scalc/01/func_choosecols.xhp#h1"/>
+ <embed href="text/scalc/01/func_vstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TAKE";>TAKE
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_tocol.xhp
b/source/text/scalc/01/func_tocol.xhp
index f2bc5ed733..a0593cac12 100644
--- a/source/text/scalc/01/func_tocol.xhp
+++ b/source/text/scalc/01/func_tocol.xhp
@@ -24,9 +24,9 @@
<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/common_func.xhp#array"/>
<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="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">
@@ -40,7 +40,6 @@
<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_id711737758586509">The formula
<input>{=TOCOL(A1:E3)}</input> returns the column</paragraph>
@@ -189,6 +188,13 @@
<embed href="text/scalc/01/func_torow.xhp#h1"/>
<embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
<embed href="text/scalc/01/func_wraprows.xhp#h1"/>
+ <embed href="text/scalc/01/func_chooserows.xhp#h1"/>
+ <embed href="text/scalc/01/func_choosecols.xhp#h1"/>
+ <embed href="text/scalc/01/func_vstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TOCOL";>TOCOL
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_torow.xhp
b/source/text/scalc/01/func_torow.xhp
index b246ca661a..2a05c2d29c 100644
--- a/source/text/scalc/01/func_torow.xhp
+++ b/source/text/scalc/01/func_torow.xhp
@@ -24,9 +24,9 @@
<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/common_func.xhp#array"/>
<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="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"/>
@@ -155,6 +155,13 @@
<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"/>
+ <embed href="text/scalc/01/func_chooserows.xhp#h1"/>
+ <embed href="text/scalc/01/func_choosecols.xhp#h1"/>
+ <embed href="text/scalc/01/func_vstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/TOROW";>TOROW
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_unique.xhp
b/source/text/scalc/01/func_unique.xhp
index 7177359c36..54ddd7499e 100644
--- a/source/text/scalc/01/func_unique.xhp
+++ b/source/text/scalc/01/func_unique.xhp
@@ -25,12 +25,12 @@
<paragraph id="par_id771708806478128" role="paragraph">Returns the array
of unique values from a range or array of values.</paragraph>
</section>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id211708281649651">UNIQUE(Array [; By col [;
Uniqueness] ])</paragraph>
+<paragraph role="code" id="par_id211708281649651">=UNIQUE(Array [; By col [;
Uniqueness] ])</paragraph>
<paragraph role="paragraph" id="par_id381715698113514"><emph>Array</emph>: the
range or array from which to return unique values.</paragraph>
<paragraph role="paragraph" id="par_id311715698119400"><emph>By col</emph>:
(optional) a logical value that indicates how to compare data: TRUE - compares
data horizontally for a match of all cells in each column, across all columns.
FALSE or omitted (default) - compares data vertically, for a match of all cells
of each row, across all rows.</paragraph>
<paragraph role="paragraph"
id="par_id531715698124705"><emph>Uniqueness</emph>: (optional) A logical value
that defines which values are considered unique. TRUE returns values that occur
only once. The default is FALSE or omitted, which returns all distinct values
in the range or array.</paragraph>
-<note id="par_id501715889339407">The UNIQUE function must be entered as an
<link href="text/scalc/01/04060107.xhp#creating_array_formulas">array
formula</link>.</note>
+<embed href="text/scalc/01/common_func.xhp#array"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
<paragraph role="paragraph" id="par_id471715980557106">Given the data table
below, the examples returns unique occurrences of grades and age.</paragraph>
<embed href="text/scalc/01/04060101.xhp#tbl_database_sample"/>
diff --git a/source/text/scalc/01/func_vstack.xhp
b/source/text/scalc/01/func_vstack.xhp
index 264cbc316b..269e33b460 100644
--- a/source/text/scalc/01/func_vstack.xhp
+++ b/source/text/scalc/01/func_vstack.xhp
@@ -24,9 +24,9 @@
<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/common_func.xhp#array"/>
<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="code" id="par_id601738075517060">=VSTACK(Array [; Array_1 [;
Array_2 [; ...]]]) </paragraph>
<paragraph role="paragraph" id="par_id81738076052161"><emph>Array</emph>: The
first array to be returned in a new array.</paragraph>
<paragraph role="paragraph" id="par_id1001738076043608"><emph>Array_1;
Array_2; ...</emph>: (optional) the arrays to append sequentially after the
previous array.</paragraph>
<embed href="text/scalc/01/common_func.xhp#optional_args"/>
@@ -62,37 +62,37 @@
<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>
+ <tablecell><paragraph id="par_id391739050327791" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id141739050331263" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id711739050335831" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
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>
+ <tablecell><paragraph id="par_id31739050380957" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id891739050384085" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id71739050387325" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
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>
+ <tablecell><paragraph id="par_id791739050429907" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id181739050433051" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id401739050436355" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
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>
+ <tablecell><paragraph id="par_id661739050485017" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id531739050488025" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id351739050492625" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
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>
+ <tablecell><paragraph id="par_id801739050502528" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id561739050505793" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
+ <tablecell><paragraph id="par_id491739050509352" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
</tablerow>
</table>
@@ -106,7 +106,11 @@
<embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
<embed href="text/scalc/01/func_wraprows.xhp#h1"/>
<embed href="text/scalc/01/func_chooserows.xhp#h1"/>
+ <embed href="text/scalc/01/func_choosecols.xhp#h1"/>
<embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/VSTACK";>VSTACK
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_wrapcols.xhp
b/source/text/scalc/01/func_wrapcols.xhp
index f3c5180cc2..2e3fa5b475 100644
--- a/source/text/scalc/01/func_wrapcols.xhp
+++ b/source/text/scalc/01/func_wrapcols.xhp
@@ -24,9 +24,9 @@
<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-dimensional 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/common_func.xhp#array"/>
<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="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>
@@ -55,17 +55,17 @@
<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>
+ <tablecell><paragraph id="par_id311738025193094" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></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>
+ <tablecell><paragraph id="par_id481738025205813" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></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>
+ <tablecell><paragraph id="par_id121738025224237" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
</tablerow>
</table>
@@ -74,9 +74,16 @@
<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"/>
+ <embed href="text/scalc/01/func_torow.xhp#h1"/>
+ <embed href="text/scalc/01/func_wraprows.xhp#h1"/>
+ <embed href="text/scalc/01/func_chooserows.xhp#h1"/>
+ <embed href="text/scalc/01/func_choosecols.xhp#h1"/>
+ <embed href="text/scalc/01/func_vstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WRAPCOLS";>WRAPCOLS
wiki page</link>.</tip>
</section>
</body>
diff --git a/source/text/scalc/01/func_wraprows.xhp
b/source/text/scalc/01/func_wraprows.xhp
index 653d9d5667..82d56ef66a 100644
--- a/source/text/scalc/01/func_wraprows.xhp
+++ b/source/text/scalc/01/func_wraprows.xhp
@@ -24,9 +24,9 @@
<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-dimensional 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/common_func.xhp#array"/>
<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="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>
@@ -59,7 +59,7 @@
<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>
+ <tablecell><paragraph id="par_id861738025129360" role="tablecontent"
localize="false"><embedvar href="text/scalc/01/common_func.xhp#NA_in_table"
markup="ignore"/></paragraph></tablecell>
</tablerow>
</table>
<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
@@ -67,9 +67,16 @@
<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"/>
+ <embed href="text/scalc/01/func_wrapcols.xhp#h1"/>
+ <embed href="text/scalc/01/func_chooserows.xhp#h1"/>
+ <embed href="text/scalc/01/func_choosecols.xhp#h1"/>
+ <embed href="text/scalc/01/func_vstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_hstack.xhp#h1"/>
+ <embed href="text/scalc/01/func_expand.xhp#h1"/>
+ <embed href="text/scalc/01/func_drop.xhp#h1"/>
+ <embed href="text/scalc/01/func_take.xhp#h1"/>
<tip id="par_id701677016751508"><link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/WRAPROWS";>WRAPROWS
wiki page</link>.</tip>
</section>
</body>
