blob: a3e9b76d41c3191a14a4d12bc31868428b9b2528 (
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
71
72
73
|
<?xml version="1.0" encoding="UTF-8"?>
<!--***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: filters.xhp,v $
* $Revision: 1.10 $
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************-->
<helpdocument version="1.0">
<meta>
<topic id="textscalcguidefiltersxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Applying Filters</title>
<filename>/text/scalc/guide/filters.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
<lastedited date="2005-11-21T09:52:22">FPE: Removed dead link
UFI: changed text and note re spec http://specs.openoffice.org/calc/ease-of-use/editing_of_non-filtered_selections.sxw
YJ: checked</lastedited>
</history>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3153896"><bookmark_value>filters; introduction</bookmark_value>
<bookmark_value>advanced filters</bookmark_value>
<bookmark_value>rows; deleting with filters</bookmark_value>
</bookmark>
<paragraph role="heading" id="hd_id3153896" xml-lang="en-US" level="1" l10n="U" oldref="70"><variable id="filters"><link href="text/scalc/guide/filters.xhp" name="Applying Filters">Applying Filters</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3150869" xml-lang="en-US" l10n="CHG" oldref="2">Filters and advanced filters allow you to work on certain filtered rows (records) of a data range. In the spreadsheets in $[officename] there are various possibilities for applying filters.</paragraph>
<list type="unordered">
<listitem>
<paragraph role="listitem" id="par_id3155131" xml-lang="en-US" l10n="U" oldref="3">One use for the <emph>AutoFilter</emph> function is to quickly restrict the display to records with identical entries in a data field.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3146119" xml-lang="en-US" l10n="U" oldref="4">In the <emph>Filter</emph> dialog, you can also define ranges which contain the values in particular data fields. You can use the standard filter to connect up to three conditions with either a logical AND or a logical OR operator.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3150010" xml-lang="en-US" l10n="U" oldref="5">The <emph>Advanced filter</emph> exceeds the three condition limitation and allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet.</paragraph>
</listitem>
</list>
<paragraph role="note" id="par_idN10663" xml-lang="en-US" l10n="NEW">When you select filtered rows and then either apply formatting, or delete the selected rows, this action then applies only to the filtered rows. The hidden rows are not affected. This is the opposite to rows that you have hidden manually by the <emph>Format - Rows - Hide Rows</emph> command. Manually hidden rows are deleted when you delete a selection that contains them.</paragraph>
<section id="relatedtopics">
<embed href="text/scalc/guide/autofilter.xhp#autofilter"/>
<embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/>
<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/>
</section>
</body>
</helpdocument>
|
