1<?xml version="1.0" encoding="UTF-8"?>
2
3
4
5<!--***********************************************************
6 *
7 * Licensed to the Apache Software Foundation (ASF) under one
8 * or more contributor license agreements.  See the NOTICE file
9 * distributed with this work for additional information
10 * regarding copyright ownership.  The ASF licenses this file
11 * to you under the Apache License, Version 2.0 (the
12 * "License"); you may not use this file except in compliance
13 * with the License.  You may obtain a copy of the License at
14 *
15 *   http://www.apache.org/licenses/LICENSE-2.0
16 *
17 * Unless required by applicable law or agreed to in writing,
18 * software distributed under the License is distributed on an
19 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
20 * KIND, either express or implied.  See the License for the
21 * specific language governing permissions and limitations
22 * under the License.
23 *
24 ***********************************************************-->
25
26
27
28
29		<helpdocument version="1.0">
30<meta>
31<topic id="textshared0212030000xml" indexer="include" status="PUBLISH">
32<title id="tit" xml-lang="en-US">AutoFilter</title>
33<filename>/text/shared/02/12030000.xhp</filename>
34</topic>
35</meta>
36<body>
37<section id="autofilter">
38<bookmark xml-lang="en-US" branch="hid/.uno:AutoFilter" id="bm_id8419293" localize="false"/>
39<bookmark xml-lang="en-US" branch="hid/.uno:AutoFilter" id="bm_id3153323" localize="false"/><paragraph role="heading" id="hd_id3149495" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/02/12030000.xhp" name="AutoFilter">AutoFilter</link></paragraph>
40<paragraph role="paragraph" id="par_id3148983" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:AutoFilter">Filters the records, based on the content of the currently selected data field.</ahelp></paragraph>
41</section>
42<section id="syautofilter">
43<table id="tbl_id3147143">
44<tablerow>
45<tablecell colspan="" rowspan="">
46<paragraph role="paragraph" id="par_id3151234" xml-lang="en-US" l10n="E">
47<image id="img_id3147261" src="res/commandimagelist/sc_formfiltered.png" width="0.222inch" height="0.222inch"><alt id="alt_id3147261" xml-lang="en-US">Icon</alt>
48	</image></paragraph>
49</tablecell>
50<tablecell colspan="" rowspan="">
51<paragraph role="paragraph" id="par_id3147043" xml-lang="en-US" l10n="U" oldref="3">AutoFilter</paragraph>
52</tablecell>
53</tablerow>
54</table>
55</section>
56<paragraph role="paragraph" id="par_id3155355" xml-lang="en-US" l10n="U" oldref="4">Place the cursor in a field name whose content you want to filter and then click the <emph>AutoFilter</emph> icon. Only those records with content identical to the selected field name are visible.</paragraph>
57<paragraph role="paragraph" id="par_id3159234" xml-lang="en-US" l10n="U" oldref="5">For example, to view all the customers from New York, click a field name with the entry "New York". AutoFilter then filters all customers from New York from the database.</paragraph>
58<paragraph role="paragraph" id="par_id3153577" xml-lang="en-US" l10n="U" oldref="6">You can remove the current AutoFilter with the <link href="text/shared/02/12040000.xhp" name="Remove Filter/Sorting">Remove Filter/Sorting</link> icon or with <emph>Data - Filter - Remove Filter</emph>.</paragraph>
59<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US" l10n="U" oldref="7">To filter with several field names simultaneously, click the <emph>Default Filter </emph>icon. The <link href="text/shared/02/12090000.xhp" name="Default Filter dialog">Default Filter</link> dialog appears, in which you can combine several filter criteria.</paragraph>
60</body>
61</helpdocument>
62