From 7b824f49fb1a71b173ed318241f99aeb7320eac0 Mon Sep 17 00:00:00 2001
From: Olivier Hallot <olivier.hallot@libreoffice.org>
Date: Mon, 27 May 2024 14:46:51 -0300
Subject: tdf#159872 Review Help for SORT/SORTBY function

+ Fix syntax definition

Change-Id: I9b24b25bdeb4298f6ba12f605b783324b3b921d1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168115
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
---
 source/text/scalc/01/func_sort.xhp   | 12 ++++++------
 source/text/scalc/01/func_sortby.xhp |  9 +++++----
 2 files changed, 11 insertions(+), 10 deletions(-)

(limited to 'source')

diff --git a/source/text/scalc/01/func_sort.xhp b/source/text/scalc/01/func_sort.xhp
index e0f9b694c8..a771ccbfa2 100644
--- a/source/text/scalc/01/func_sort.xhp
+++ b/source/text/scalc/01/func_sort.xhp
@@ -26,12 +26,12 @@
 </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_id211708281649651">SORT(Range [, SortIndex[, SortOrder[, ByCol]]])</paragraph>
-<paragraph role="paragraph" id="par_id551711457515235"><emph>Range:</emph> Required. The range or array to sort.</paragraph>
-<paragraph role="paragraph" id="par_id151711457520290"><emph>SortIndex:</emph> Optional. The number indicating the row or column to sort by.</paragraph>
-<paragraph role="paragraph" id="par_id131711457525811"><emph>SortOrder:</emph> Optional. A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order.</paragraph>
-<paragraph role="paragraph" id="par_id351711457531579"><emph>ByCol:</emph> Optional. A logical value indicating the desired sort direction; <emph>FALSE</emph> to sort by row (default), <emph>TRUE</emph> to sort by column.</paragraph>
-
+<paragraph role="code" id="par_id211708281649651">SORT(Range [; SortIndex [; SortOrder [; ByCol] ] ])</paragraph>
+<paragraph role="paragraph" id="par_id551711457515235"><emph>Range:</emph> the range or array to sort.</paragraph>
+<paragraph role="paragraph" id="par_id151711457520290"><emph>SortIndex:</emph> (optional). The number indicating the row or column to sort by.</paragraph>
+<paragraph role="paragraph" id="par_id131711457525811"><emph>SortOrder:</emph> (optional). A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order.</paragraph>
+<paragraph role="paragraph" id="par_id351711457531579"><emph>ByCol:</emph> (optional). A logical value indicating the desired sort direction; <emph>FALSE</emph> to sort by row (default), <emph>TRUE</emph> to sort by column.</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/ex_data_stat_func.xhp#ex_func_average_table"/>
 <h4 id="hd_id751711480783220">Example with ascending order</h4>
diff --git a/source/text/scalc/01/func_sortby.xhp b/source/text/scalc/01/func_sortby.xhp
index 332005731a..1f0f045a47 100644
--- a/source/text/scalc/01/func_sortby.xhp
+++ b/source/text/scalc/01/func_sortby.xhp
@@ -25,12 +25,13 @@
     <paragraph id="par_id771708806478128" role="paragraph">Sorts the contents of a range or array based on the values in a corresponding range or array.</paragraph>
 </section>
 <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
-<paragraph role="code" id="par_id211708281649651">SORTBY(Range, SortByRange1, SortOrder1[, SortByRange2, SortOrder2,[...]])</paragraph>
+<paragraph role="code" id="par_id211708281649651">SORTBY(Range; SortByRange1; SortOrder1 [; SortByRange2; SortOrder2,[...] ])</paragraph>
 <paragraph role="paragraph" id="par_id451711544450734"><emph>Range</emph>: The array or range to sort.</paragraph>
-<paragraph role="paragraph" id="par_id291711544460323"><emph>SortByRange1, SortByRange2,... </emph>: Range 1, range 2,... are the arrays or ranges to sort on.</paragraph>
-<paragraph role="paragraph" id="par_id501711544465886"><emph>SortOrder1, SortOrder2,...</emph> : Order 1, order 2,... are the orders to use for sorting. 1 for ascending, -1 for descending. Default is ascending.</paragraph>
+<paragraph role="paragraph" id="par_id291711544460323"><emph>SortByRange1, SortByRange2,... </emph>: range 1, range 2,... are the arrays or ranges to sort on.</paragraph>
+<paragraph role="paragraph" id="par_id501711544465886"><emph>SortOrder1, SortOrder2,...</emph> : order 1, order 2,... are the orders to use for sorting. 1 for ascending, -1 for descending. Default is ascending.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#optional_args"/>
 <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-<paragraph role="paragraph" id="par_id131711466000482"><input>{=SORTBY(A2:C7,A2:A7,1,C2:C7,-1)}</input></paragraph>
+<paragraph role="paragraph" id="par_id131711466000482"><input>{=SORTBY(A2:C7;A2:A7;1;C2:C7;-1)}</input></paragraph>
 <paragraph role="paragraph" id="par_id471711472262161">Sort the range A2:C7 based on the first column in ascending order and third column in descending order.</paragraph>
 <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
 <embed href="text/scalc/00/avail_release.xhp#24.8"/>
-- 
cgit