blob: be34382093c47d64b96cab8c3f02e4943b7e56c0 (
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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* 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 .
-->
<meta>
<topic id="textshared0212090101xml" indexer="include" status="PUBLISH">
<title xml-lang="en-US" id="tit">Comparison Operators</title>
<filename>/text/shared/02/12090101.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3148983"><bookmark_value>comparisons;operators in standard filter dialog</bookmark_value>
<bookmark_value>operators;standard filters</bookmark_value>
<bookmark_value>standard filters;comparison operators</bookmark_value>
<bookmark_value>filters; comparison operators</bookmark_value>
<bookmark_value>equal sign, see also operators</bookmark_value>
</bookmark><comment>mw added "equal sign,..."</comment><comment>MW changed "default filters;" into "standard filters;"</comment><comment>mw changed "comparisons;" and "operators;"</comment>
<h1 id="hd_id3148983">Comparison Operators</h1>
<paragraph xml-lang="en-US" id="par_id3155364" role="paragraph">The following comparative operators can be set under <item type="menuitem">Condition</item> in the <item type="menuitem">Standard Filter</item> dialog.</paragraph>
<table id="tbl_id3149760">
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3145313" role="tablehead">
<emph>Comparative operator</emph>
</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3147089" role="tablehead">
<emph>Effect</emph>
</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3147209" role="paragraph">Equal (=)</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3146797" role="paragraph">Shows values equal to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3143271" role="paragraph">Less than (<)</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3153761" role="paragraph">Shows values less than the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3146807" role="paragraph">Greater than (>)</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3154852" role="paragraph">Shows values greater than the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3155342" role="paragraph">Less than or equal to (< =)</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3154381" role="paragraph">Shows values that are less than or equal to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3153823" role="paragraph">Greater than or equal to (> =)</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3154143" role="paragraph">Shows values that are greater than or equal to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3154811" role="paragraph">Not equal (< >)</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3148944" role="paragraph">Shows the values not equal to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3149669" role="paragraph">Largest</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3159413" role="paragraph">Shows the N (numeric value as parameter) largest values.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3151054" role="paragraph">Smallest</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3161657" role="paragraph">Shows the N (numeric value as parameter) smallest values.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3150400" role="paragraph">Largest %</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3161645" role="paragraph">Shows the largest N% (numeric value as parameter) of the total values.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3149202" role="paragraph">Smallest %</paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3151176" role="paragraph">Shows the smallest N% (numeric value as parameter) of the entire values.</paragraph>
</tablecell>
</tablerow>
</table>
</body>
</helpdocument>
|
