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: 12090101.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=
"textshared0212090101xml" indexer=
"include" status=
"PUBLISH">
41 <title id=
"tit" xml-lang=
"en-US">Comparison Operators
</title>
42 <filename>/text/shared/
02/
12090101.xhp
</filename>
46 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3148983"><bookmark_value>comparisons;operators in default filter dialog
</bookmark_value>
47 <bookmark_value>operators; default filters
</bookmark_value>
48 <bookmark_value>default filters; comparison operators
</bookmark_value>
49 <bookmark_value>filters; comparison operators
</bookmark_value>
50 <bookmark_value>equal sign, see also operators
</bookmark_value>
51 </bookmark><comment>mw added
"equal sign,..."</comment><paragraph role=
"heading" id=
"hd_id3148983" xml-lang=
"en-US" level=
"1" l10n=
"U" oldref=
"1">Comparison Operators
</paragraph>
52 <paragraph role=
"paragraph" id=
"par_id3155364" xml-lang=
"en-US" l10n=
"U" oldref=
"2">The following comparative operators can be set under
<emph>Condition
</emph> in the
<emph>Default Filter
</emph> dialog.
</paragraph>
53 <table id=
"tbl_id3149760">
55 <tablecell colspan=
"" rowspan=
"">
56 <paragraph role=
"paragraph" id=
"par_id3145313" xml-lang=
"en-US" l10n=
"U" oldref=
"3">
57 <emph>Comparative operator
</emph>
60 <tablecell colspan=
"" rowspan=
"">
61 <paragraph role=
"paragraph" id=
"par_id3147089" xml-lang=
"en-US" l10n=
"U" oldref=
"4">
67 <tablecell colspan=
"" rowspan=
"">
68 <paragraph role=
"paragraph" id=
"par_id3147209" xml-lang=
"en-US" l10n=
"U" oldref=
"5">Equal (=)
</paragraph>
70 <tablecell colspan=
"" rowspan=
"">
71 <paragraph role=
"paragraph" id=
"par_id3146797" xml-lang=
"en-US" l10n=
"U" oldref=
"6">Shows values equal to the condition.
</paragraph>
75 <tablecell colspan=
"" rowspan=
"">
76 <paragraph role=
"paragraph" id=
"par_id3143271" xml-lang=
"en-US" l10n=
"U" oldref=
"7">Less than (
<)
</paragraph>
78 <tablecell colspan=
"" rowspan=
"">
79 <paragraph role=
"paragraph" id=
"par_id3153761" xml-lang=
"en-US" l10n=
"U" oldref=
"8">Shows values less than the condition.
</paragraph>
83 <tablecell colspan=
"" rowspan=
"">
84 <paragraph role=
"paragraph" id=
"par_id3146807" xml-lang=
"en-US" l10n=
"U" oldref=
"9">Greater than (
>)
</paragraph>
86 <tablecell colspan=
"" rowspan=
"">
87 <paragraph role=
"paragraph" id=
"par_id3154852" xml-lang=
"en-US" l10n=
"U" oldref=
"10">Shows values greater than the condition.
</paragraph>
91 <tablecell colspan=
"" rowspan=
"">
92 <paragraph role=
"paragraph" id=
"par_id3155342" xml-lang=
"en-US" l10n=
"U" oldref=
"11">Less than or equal to (
< =)
</paragraph>
94 <tablecell colspan=
"" rowspan=
"">
95 <paragraph role=
"paragraph" id=
"par_id3154381" xml-lang=
"en-US" l10n=
"U" oldref=
"12">Shows values that are less than or equal to the condition.
</paragraph>
99 <tablecell colspan=
"" rowspan=
"">
100 <paragraph role=
"paragraph" id=
"par_id3153823" xml-lang=
"en-US" l10n=
"U" oldref=
"13">Greater than or equal to (
> =)
</paragraph>
102 <tablecell colspan=
"" rowspan=
"">
103 <paragraph role=
"paragraph" id=
"par_id3154143" xml-lang=
"en-US" l10n=
"U" oldref=
"14">Shows values that are greater than or equal to the condition.
</paragraph>
107 <tablecell colspan=
"" rowspan=
"">
108 <paragraph role=
"paragraph" id=
"par_id3154811" xml-lang=
"en-US" l10n=
"U" oldref=
"15">Not equal (
< >)
</paragraph>
110 <tablecell colspan=
"" rowspan=
"">
111 <paragraph role=
"paragraph" id=
"par_id3148944" xml-lang=
"en-US" l10n=
"U" oldref=
"16">Shows the values not equal to the condition.
</paragraph>
115 <tablecell colspan=
"" rowspan=
"">
116 <paragraph role=
"paragraph" id=
"par_id3149669" xml-lang=
"en-US" l10n=
"U" oldref=
"17">Largest
</paragraph>
118 <tablecell colspan=
"" rowspan=
"">
119 <paragraph role=
"paragraph" id=
"par_id3159413" xml-lang=
"en-US" l10n=
"U" oldref=
"18">Shows the N (numeric value as parameter) largest values.
</paragraph>
123 <tablecell colspan=
"" rowspan=
"">
124 <paragraph role=
"paragraph" id=
"par_id3151054" xml-lang=
"en-US" l10n=
"U" oldref=
"19">Smallest
</paragraph>
126 <tablecell colspan=
"" rowspan=
"">
127 <paragraph role=
"paragraph" id=
"par_id3161657" xml-lang=
"en-US" l10n=
"U" oldref=
"20">Shows the N (numeric value as parameter) smallest values.
</paragraph>
131 <tablecell colspan=
"" rowspan=
"">
132 <paragraph role=
"paragraph" id=
"par_id3150400" xml-lang=
"en-US" l10n=
"U" oldref=
"21">Largest %
</paragraph>
134 <tablecell colspan=
"" rowspan=
"">
135 <paragraph role=
"paragraph" id=
"par_id3161645" xml-lang=
"en-US" l10n=
"U" oldref=
"22">Shows the largest N% (numeric value as parameter) of the total values.
</paragraph>
139 <tablecell colspan=
"" rowspan=
"">
140 <paragraph role=
"paragraph" id=
"par_id3149202" xml-lang=
"en-US" l10n=
"U" oldref=
"23">Smallest %
</paragraph>
142 <tablecell colspan=
"" rowspan=
"">
143 <paragraph role=
"paragraph" id=
"par_id3151176" xml-lang=
"en-US" l10n=
"U" oldref=
"24">Shows the smallest N% (numeric value as parameter) of the entire values.
</paragraph>