source/text/scalc/01/12040100.xhp | 33 ++++++++++++++++++++-------------
1 file changed, 20 insertions(+), 13 deletions(-)
New commits:
commit 7fc1be9c61cf8d19c7982dc6a407b7eca2ad5b93
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Jan 28 14:28:09 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Jan 29 09:53:30 2023 +0000
Update Autofilter help page
+ Autofilter options were changed, the patch synchs with current menu
+ Missing bookmarks for filtering by color
Change-Id: I96d5af98dd9c70bfd4e8c376891b67dbd5853767
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146299
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/12040100.xhp
b/source/text/scalc/01/12040100.xhp
index e613fea938..585994104c 100644
--- a/source/text/scalc/01/12040100.xhp
+++ b/source/text/scalc/01/12040100.xhp
@@ -36,31 +36,38 @@
</section>
<embed href="text/scalc/guide/autofilter.xhp#autofiltertip"/>
-<h3 id="hd_id101621534096986">Sort Ascending</h3>
+<h2 id="hd_id101621534096986">Sort Ascending</h2>
<paragraph role="paragraph" id="par_id31621544435954">Displays the rows of the
cell range in ascending order, based on the values in the cells of the current
column.</paragraph>
-<h3 id="hd_id561621534101425">Sort Descending</h3>
+<h2 id="hd_id561621534101425">Sort Descending</h2>
<paragraph role="paragraph" id="par_id861621544431393">Displays the rows of
the cell range in descending order, based on the values in the cells of the
current column.</paragraph>
-<h3 id="hd_id401621534105620">Top 10</h3>
-<paragraph role="paragraph" id="par_id341621544426925">Displays the 10 rows of
the cell range that contain the largest values in the cells of the current
column. If these values are unique then no more than 10 rows will be visible,
but if the values are not unique then it is possible for more than 10 rows to
be shown.</paragraph>
-<h3 id="hd_id541621534109912">Empty</h3>
-<paragraph role="paragraph" id="par_id941621544422352">Displays only the rows
of the cell range that have an empty cell in the current column.</paragraph>
-<h3 id="hd_id821621534116893">Not Empty</h3>
-<paragraph role="paragraph" id="par_id71621544418559">Displays only the rows
of the cell range that have a non-empty cell in the current column.</paragraph>
+<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/filtersubdropdown/menu" id="bm_id101674925465966"
localize="false"/>
+<h2 id="hd_id391674926239837">Filter by Color</h2>
+<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/filtersubdropdown/textcolor"
id="bm_id331674925567744" localize="false"/>
<h3 id="hd_id271621534120995">Text color</h3>
<paragraph role="paragraph" id="par_id691621544414646">Displays only the rows
of the cell range for which the text color of the cell in the current column
matches the color selected.</paragraph>
+<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/filtersubdropdown/background"
id="bm_id341674925655898" localize="false"/>
<h3 id="hd_id151621534125831">Background color</h3>
<paragraph role="paragraph" id="par_id491621544410605">Displays only the rows
of the cell range for which the background color of the cell in the current
column matches the color selected.</paragraph>
+<h2 id="hd_id771674926517261">Filter by Condition</h2>
+<h3 id="hd_id541621534109912">Empty</h3>
+<paragraph role="paragraph" id="par_id941621544422352">Displays only the rows
of the cell range that have an empty cell in the current column.</paragraph>
+<h3 id="hd_id821621534116893">Not Empty</h3>
+<paragraph role="paragraph" id="par_id71621544418559">Displays only the rows
of the cell range that have a non-empty cell in the current column.</paragraph>
+<h3 id="hd_id401621534105620">Top 10</h3>
+<paragraph role="paragraph" id="par_id341621544426925">Displays the 10 rows of
the cell range that contain the largest values in the cells of the current
column. If these values are unique then no more than 10 rows will be visible,
but if the values are not unique then it is possible for more than 10 rows to
be shown.</paragraph>
+<h3 id="hd_id91674926632440">Bottom 10</h3>
+<paragraph role="paragraph" id="par_id791674926643175">Displays the 10 rows of
the cell range that contain the lowest values in the cells of the current
column. If these values are unique then no more than 10 rows will be visible,
but if the values are not unique then it is possible for more than 10 rows to
be shown.</paragraph>
<h3 id="hd_id851621534131430">Standard Filter</h3>
<paragraph role="paragraph" id="par_id171621544405886">Opens the <link
href="text/shared/02/12090000.xhp">Standard Filter</link> dialog.</paragraph>
-<h3 id="hd_id551621534136181">Search text box</h3>
+<h2 id="hd_id551621534136181">Search text box</h2>
<paragraph role="paragraph" id="par_id421621544399700">Search for a specific
entry in the list of values found in the current column. As characters are
typed in the text box, this list is updated to show only matching
entries.</paragraph>
-<h3 id="hd_id581621534140892">All</h3>
+<h2 id="hd_id581621534140892">All</h2>
<paragraph role="paragraph" id="par_id641621544394836">Click once to select to
show all rows and click again to select to hide all rows.</paragraph>
-<h3 id="hd_id731621534146408">Show only current</h3>
+<h2 id="hd_id731621534146408">Show only current item</h2>
<paragraph role="paragraph" id="par_id71621544390147">Display only rows
containing the value highlighted in the <emph>Value</emph> box.</paragraph>
-<h3 id="hd_id11621534151081">Hide only current</h3>
+<h2 id="hd_id11621534151081">Hide only current item</h2>
<paragraph role="paragraph" id="par_id491621544384770">Hide all rows
containing the value highlighted in the <emph>Value</emph> box and display all
other rows.</paragraph>
-<h3 id="hd_id621621534155662">Values</h3>
+<h2 id="hd_id621621534155662">Values</h2>
<paragraph role="paragraph" id="par_id331621544378745">List of unique values
found in the current column.</paragraph>
<section id="relatedtopics">
<embed href="text/scalc/guide/autofilter.xhp#autofilter"/>
