source/text/scalc/01/12030200.xhp | 42 +++++++++++++++++++++-----------------
1 file changed, 24 insertions(+), 18 deletions(-)
New commits:
commit d97287d7f83c7e48c27d2541895a7230f09b0ee8
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Jan 15 22:38:28 2021 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sat Jan 16 13:55:48 2021 +0100
tdf#139543 Update Calc sort Option page
- Add missing checkbox
- Refactor headings
Change-Id: Id88cba0bd89db3ad3265f7e4088de1a29252a053
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109424
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/12030200.xhp
b/source/text/scalc/01/12030200.xhp
index 013f65f58..2dbd0cb88 100644
--- a/source/text/scalc/01/12030200.xhp
+++ b/source/text/scalc/01/12030200.xhp
@@ -45,45 +45,51 @@
</section>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sortoptionspage/case"
id="bm_id3149664" localize="false"/>
<h2 id="hd_id3146976" xml-lang="en-US">Case sensitive</h2>
-<paragraph role="paragraph" id="par_id3153091" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/case"> Sorts first by uppercase letters
and then by lowercase letters. For Asian languages, special handling
applies.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153091" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/case">Sorts first by uppercase letters
and then by lowercase letters. For Asian languages, special handling
applies.</ahelp></paragraph>
<note id="par_idN10637" xml-lang="en-US">For Asian languages: Check <emph>Case
Sensitive</emph> to apply multi-level collation. With multi-level collation,
entries are first compared in their primitive forms with their cases and
diacritics ignored. If they evaluate as the same, their diacritics are taken
into account for the second-level comparison. If they still evaluate as the
same, their cases, character widths, and Japanese Kana difference are
considered for the third-level comparison.<comment>UFI: see #112590# and
#112507#</comment></note>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/header" id="bm_id3145271"
localize="false"/>
-<paragraph role="heading" id="hd_id3155856" xml-lang="en-US" level="2"> Range
contains column/row labels</paragraph>
+<h2 id="hd_id3155856">Range contains row/column labels</h2>
<paragraph role="paragraph" id="par_id3154014" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/header"> Omits the first row or the first
column in the selection from the sort.</ahelp> The <emph>Direction</emph>
setting at the bottom of the dialog defines the name and function of this check
box.</paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/formats" id="bm_id3149410"
localize="false"/>
-<paragraph role="heading" id="hd_id3147436" xml-lang="en-US" level="2">
Include formats</paragraph>
+<h2 id="hd_id3147436"> Include formats</h2>
<paragraph role="paragraph" id="par_id3149377" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/formats"> Preserves the current cell
formatting.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/naturalsort" id="bm_id3149412"
localize="false"/>
-<paragraph role="heading" id="hd_id3147438" xml-lang="en-US" level="2">Enable
natural sort</paragraph>
+<h2 id="hd_id3147438">Enable natural sort</h2>
<paragraph role="paragraph" id="par_id3149378" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/naturalsort">Natural sort is a sort
algorithm that sorts string-prefixed numbers based on the value of the
numerical element in each sorted number, instead of the traditional way of
sorting them as ordinary strings.</ahelp> For instance, let's assume you have a
series of values such as, A1, A2, A3, A4, A5, A6, ..., A19, A20, A21. When you
put these values into a range of cells and run the sort, it will become A1,
A11, A12, A13, ..., A19, A2, A20, A21, A3, A4, A5, ..., A9. While this sorting
behavior may make sense to those who understand the underlying sorting
mechanism, to the rest of the population it seems completely bizarre, if not
outright inconvenient. With the natural sort feature enabled, values such as
the ones in the above example get sorted "properly", which improves the
convenience of sorting operations in general.</paragraph>
+<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/includenotes"
id="bm_id331610760238867" localize="false"/>
+<h2 id="hd_id71610757096466">Include boundary column(s)/row(s) containing only
comments</h2>
+<paragraph role="paragraph" id="par_id431610757186031">Range boundary columns
(for sorting rows) or boundary rows (for sorting columns) of a sorting range
are not sorted by default if they are empty. Check this option if boundary
columns or boundary rows containing comments are also to be sorted.</paragraph>
+<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/includeimages"
id="bm_id331610760238867" localize="false"/>
+<h2 id="hd_id161610757296697">Include boundary column(s)/row(s) containing
only images</h2>
+<paragraph role="paragraph" id="par_id181610758875786">Border columns (for
sorting rows) or border rows (for sorting columns) of a sorting area are not
sorted by default if they are empty. Check this option if boundary columns or
boundary rows containing images are also to be sorted.</paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/copyresult" id="bm_id3147124"
localize="false"/>
-<paragraph role="heading" id="hd_id3153878" xml-lang="en-US" level="2"> Copy
sort results to:</paragraph>
+<h2 id="hd_id3153878"> Copy sort results to:</h2>
<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/copyresult"> Copies the sorted list to
the cell range that you specify.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/outarealb" id="bm_id3149403"
localize="false"/>
-<paragraph role="heading" id="hd_id3153418" xml-lang="en-US" level="3"> Sort
results</paragraph>
-<paragraph role="paragraph" id="par_id3155602" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/outarealb"> Select a named <link
href="text/scalc/01/12010000.xhp" name="cell range"> cell range</link> where
you want to display the sorted list, or enter a cell range in the input
box.</ahelp></paragraph>
+<h3 id="hd_id3153418"> Sort results (named ranges list)</h3>
+<paragraph role="paragraph" id="par_id3155602" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/outarealb"> Select a named <link
href="text/scalc/01/12010000.xhp" name="cell range"> cell range</link> where
you want to display the sorted list.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/outareaed" id="bm_id3153767"
localize="false"/>
-<paragraph role="heading" id="hd_id3153707" xml-lang="en-US" level="3"> Sort
results</paragraph>
-<paragraph role="paragraph" id="par_id3145642" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/outareaed"> Enter the cell range where
you want to display the sorted list, or select a named range from the
list.</ahelp></paragraph>
+<h3 id="hd_id3153707"> Sort results (input box)</h3>
+<paragraph role="paragraph" id="par_id3145642" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/outareaed">Enter the cell range where you
want to display the sorted list.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/sortuser" id="bm_id3147339"
localize="false"/>
-<paragraph role="heading" id="hd_id3155445" xml-lang="en-US" level="2"> Custom
sort order</paragraph>
+<h2 id="hd_id3155445"> Custom sort order</h2>
<paragraph role="paragraph" id="par_id3156385" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/sortuser"> Click here and then select the
custom sort order that you want.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/sortuserlb" id="bm_id3146917"
localize="false"/>
-<paragraph role="heading" id="hd_id3154704" xml-lang="en-US" level="3"> Custom
sort order</paragraph>
-<paragraph role="paragraph" id="par_id3155962" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/sortuserlb"> Select the custom sort order
that you want to apply. To define a custom sort order, choose <switchinline
select="sys"><caseinline select="MAC">%PRODUCTNAME -
Preferences</caseinline><defaultinline>Tools -
Options</defaultinline></switchinline> - <link
href="text/shared/optionen/01060400.xhp" name="%PRODUCTNAME Calc - Sort
Lists">%PRODUCTNAME Calc - Sort Lists</link> .</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3149257" xml-lang="en-US" level="2">
Language</paragraph>
+<h3 id="hd_id3154704"> Custom sort order list</h3>
+<paragraph role="paragraph" id="par_id3155962" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/sortuserlb"> Select the custom sort order
that you want to apply. To define a custom sort order, choose <switchinline
select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME -
Preferences</menuitem></caseinline><defaultinline><menuitem>Tools -
Options</menuitem></defaultinline></switchinline> - <link
href="text/shared/optionen/01060400.xhp" name="%PRODUCTNAME Calc - Sort
Lists"><menuitem>%PRODUCTNAME Calc - Sort
Lists</menuitem></link>.</ahelp></paragraph>
+<h2 id="hd_id3149257"> Language</h2>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/language" id="bm_id3150299"
localize="false"/>
-<paragraph role="heading" id="hd_id3147004" xml-lang="en-US" level="3">
Language</paragraph>
+<h3 id="hd_id3147004"> Language</h3>
<paragraph role="paragraph" id="par_id3150787" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/language"> Select the language for the
sorting rules.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/algorithmlb" id="bm_id3150304"
localize="false"/>
-<paragraph role="heading" id="hd_id3150344" xml-lang="en-US" level="3">
Options</paragraph>
+<h3 id="hd_id3150344"> Options</h3>
<paragraph role="paragraph" id="par_id3155113" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/algorithmlb"> Select a sorting option for
the language.</ahelp> For example, select the "phonebook" option for German to
include the umlaut special character in the sorting.</paragraph>
-<paragraph role="heading" id="hd_id3152580" xml-lang="en-US" level="2">
Direction</paragraph>
+<h2 id="hd_id3152580"> Direction</h2>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/topdown" id="bm_id3155507"
localize="false"/>
-<paragraph role="heading" id="hd_id3154201" xml-lang="en-US" level="3"> Top to
Bottom (Sort Rows)</paragraph>
+<h3 id="hd_id3154201"> Top to Bottom (Sort Rows)</h3>
<paragraph role="paragraph" id="par_id3166430" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/topdown"> Sorts rows by the values in the
active columns of the selected range.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/sortoptionspage/leftright" id="bm_id3155529"
localize="false"/>
-<paragraph role="heading" id="hd_id3145588" xml-lang="en-US" level="3"> Left
to Right (Sort Columns)</paragraph>
+<h3 id="hd_id3145588"> Left to Right (Sort Columns)</h3>
<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/sortoptionspage/leftright"> Sorts columns by the values
in the active rows of the selected range.</ahelp></paragraph>
</body>
</helpdocument>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
