1 <?xml version=
"1.0" encoding=
"UTF-8"?>
6 ***********************************************************************
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
10 * Copyright 2008 by Sun Microsystems, Inc.
12 * OpenOffice.org - a multi-platform office productivity suite
14 * $RCSfile: 12030000.xhp,v $
17 * This file is part of OpenOffice.org.
19 * OpenOffice.org is free software: you can redistribute it and/or modify
20 * it under the terms of the GNU Lesser General Public License version 3
21 * only, as published by the Free Software Foundation.
23 * OpenOffice.org is distributed in the hope that it will be useful,
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26 * GNU Lesser General Public License version 3 for more details
27 * (a copy is included in the LICENSE file that accompanied this code).
29 * You should have received a copy of the GNU Lesser General Public License
30 * version 3 along with OpenOffice.org. If not, see
31 * <http://www.openoffice.org/license.html>
32 * for a copy of the LGPLv3 License.
34 ************************************************************************
38 <helpdocument version=
"1.0">
40 <topic id=
"textshared0212030000xml" indexer=
"include" status=
"PUBLISH">
41 <title id=
"tit" xml-lang=
"en-US">AutoFilter
</title>
42 <filename>/text/shared/
02/
12030000.xhp
</filename>
46 <section id=
"autofilter">
47 <bookmark xml-lang=
"en-US" branch=
"hid/SID_FM_AUTOFILTER" id=
"bm_id8419293" localize=
"false"/>
48 <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>
49 <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>
51 <section id=
"syautofilter">
52 <table id=
"tbl_id3147143">
54 <tablecell colspan=
"" rowspan=
"">
55 <paragraph role=
"paragraph" id=
"par_id3151234" xml-lang=
"en-US" l10n=
"E">
56 <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>
59 <tablecell colspan=
"" rowspan=
"">
60 <paragraph role=
"paragraph" id=
"par_id3147043" xml-lang=
"en-US" l10n=
"U" oldref=
"3">AutoFilter
</paragraph>
65 <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>
66 <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>
67 <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>
68 <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>