summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/scalc/01/12040100.xhp
blob: 599def1e3ad540361de00f21828fa09687337eae (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<?xml version="1.0" encoding="UTF-8"?>
<!--
 * This file is part of the LibreOffice project.
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * This file incorporates work covered by the following license notice:
 *
 *   Licensed to the Apache Software Foundation (ASF) under one or more
 *   contributor license agreements. See the NOTICE file distributed
 *   with this work for additional information regarding copyright
 *   ownership. The ASF licenses this file to you under the Apache
 *   License, Version 2.0 (the "License"); you may not use this file
 *   except in compliance with the License. You may obtain a copy of
 *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
 -->
<helpdocument version="1.0">
<meta>
<topic id="textscalc0112040100xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">AutoFilter</title>
<filename>/text/scalc/01/12040100.xhp</filename>
</topic>
</meta>
<body>
<section id="autofilter">
<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"><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#autofilter"/>
</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>
</section>
</body>
</helpdocument>