summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2021-05-20 20:00:39 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2021-05-22 17:02:39 +0200
commit6a10fe0b51b53d9dc097e420c65f86590800ca22 (patch)
tree449326b3faaf498a5d1b38a7e7ed78f31daee9ff
parentFix typo (diff)
downloadhelp-6a10fe0b51b53d9dc097e420c65f86590800ca22.tar.gz
help-6a10fe0b51b53d9dc097e420c65f86590800ca22.zip
tdf#142389 (final) update autofilter Help
- Add definitions for each autofilter command - Add info on fitering by color Special collaboration by Steve Fanning. Change-Id: I51e8e6e495736d0d5e1b5d40e74a926c813fb49a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115895 Tested-by: Jenkins Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/12040100.xhp30
-rw-r--r--source/text/scalc/guide/autofilter.xhp11
2 files changed, 36 insertions, 5 deletions
diff --git a/source/text/scalc/01/12040100.xhp b/source/text/scalc/01/12040100.xhp
index 94d48c48b..99883dbd8 100644
--- a/source/text/scalc/01/12040100.xhp
+++ b/source/text/scalc/01/12040100.xhp
@@ -28,12 +28,40 @@
<bookmark xml-lang="en-US" branch="hid/.uno:DataFilterAutoFilter" id="bm_id5427750" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filterdropdown/FilterDropDown" id="bm_id361621531206029" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filterdropdown/@@nowidget@@" id="bm_id151621531292577" localize="false"/>
-<h1 id="hd_id3153541"><link href="text/scalc/01/12040100.xhp" name="AutoFilter">AutoFilter</link></h1>
+<h1 id="hd_id3153541"><variable id="autofilterh1"><link href="text/scalc/01/12040100.xhp" name="AutoFilter">AutoFilter</link></variable></h1>
<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp hid=".uno:DataFilterAutoFilter">Automatically filters the selected cell range, and creates one-row list boxes where you can choose the items that you want to display.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#dnfiafi"/>
</section>
+<embed href="text/scalc/guide/autofilter.xhp#autofiltertip"/>
+
+<h3 id="hd_id101621534096986">Sort Ascending</h3>
+<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>
+<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>
+<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>
+<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>
+<h3 id="hd_id851621534131430">Standard Filter</h3>
+<paragraph role="paragraph" id="par_id171621544405886">Opens the <link href="text/shared/02/12090000.xhp" name="standard filter">Standard Filter</link> dialog.</paragraph>
+<h3 id="hd_id551621534136181">Search text box</h3>
+<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>
+<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>
+<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>
+<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>
+<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"/>
<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"><link href="text/shared/02/12090000.xhp" name="Default filter">Default filter</link></paragraph>
diff --git a/source/text/scalc/guide/autofilter.xhp b/source/text/scalc/guide/autofilter.xhp
index 6e204cd84..9d7f1b5a0 100644
--- a/source/text/scalc/guide/autofilter.xhp
+++ b/source/text/scalc/guide/autofilter.xhp
@@ -34,8 +34,8 @@
<bookmark_value>drop-down menus in sheet columns</bookmark_value>
<bookmark_value>database ranges; AutoFilter function</bookmark_value>
</bookmark><comment>mw made "drop-down..." a one level entry and added a "see also" reference</comment>
-<paragraph xml-lang="en-US" id="hd_id3156423" role="heading" level="1"><variable id="autofilter"><link href="text/scalc/guide/autofilter.xhp" name="Applying AutoFilter">Applying AutoFilter</link>
-</variable></paragraph>
+<h1 id="hd_id3156423"><variable id="autofilter"><link href="text/scalc/guide/autofilter.xhp" name="Applying AutoFilter">Applying AutoFilter</link>
+</variable></h1>
<paragraph xml-lang="en-US" id="par_id3147427" role="paragraph">The <emph>AutoFilter</emph> function inserts a combo box on one or more data columns that lets you select the records (rows) to be displayed.</paragraph>
<section id="autofiltertext">
<list type="ordered">
@@ -53,10 +53,13 @@
<paragraph xml-lang="en-US" id="par_id9216589" role="paragraph">When you apply an additional AutoFilter on another column of a filtered data range, then the other combo boxes list only the filtered data.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153714" role="paragraph">To display all records again, select the <emph>all</emph> entry in the AutoFilter combo box. If you choose <emph>Standard</emph>, the <item type="menuitem">Standard Filter</item> dialog appears, allowing you to set up a standard filter. Choose "Top 10" to display the highest 10 values only. </paragraph>
<paragraph xml-lang="en-US" id="par_id3147340" role="paragraph">To stop using AutoFilter, reselect all cells selected in step 1 and once again choose <emph>Data - Filter - AutoFilter</emph>.</paragraph>
- <paragraph xml-lang="en-US" id="par_id4303415" role="tip">To assign different AutoFilters to different sheets, you must first define a database range on each sheet.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3159236" role="warning">The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href="text/scalc/01/04060106.xhp" name="SUBTOTAL">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account.</paragraph>
+ <section id="autofiltertip">
+ <tip id="par_id4303415">To assign different AutoFilters to different sheets, you must first define a database range on each sheet.</tip>
+ </section>
+ <warning id="par_id3159236">The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href="text/scalc/01/04060106.xhp" name="SUBTOTAL">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account.</warning>
</section>
<section id="relatedtopics">
+ <embed href="text/scalc/01/12040100.xhp#autofilterh1"/>
<embed href="text/scalc/guide/filters.xhp#filters"/>
<embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/>
<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/>