1<?xml version="1.0" encoding="UTF-8"?>
| 1<?xml version="1.0" encoding="UTF-8"?>
|
2<helpdocument version="1.0">
| |
3
4<!--***********************************************************
| 2
3<!--***********************************************************
|
5 *
| 4 *
|
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information
9 * regarding copyright ownership. The ASF licenses this file
10 * to you under the Apache License, Version 2.0 (the
11 * "License"); you may not use this file except in compliance
12 * with the License. You may obtain a copy of the License at
| 5 * Licensed to the Apache Software Foundation (ASF) under one
6 * or more contributor license agreements. See the NOTICE file
7 * distributed with this work for additional information
8 * regarding copyright ownership. The ASF licenses this file
9 * to you under the Apache License, Version 2.0 (the
10 * "License"); you may not use this file except in compliance
11 * with the License. You may obtain a copy of the License at
|
13 *
| 12 *
|
14 * http://www.apache.org/licenses/LICENSE-2.0
| 13 * http://www.apache.org/licenses/LICENSE-2.0
|
15 *
| 14 *
|
16 * Unless required by applicable law or agreed to in writing,
17 * software distributed under the License is distributed on an
18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19 * KIND, either express or implied. See the License for the
20 * specific language governing permissions and limitations
21 * under the License.
| 15 * Unless required by applicable law or agreed to in writing,
16 * software distributed under the License is distributed on an
17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
18 * KIND, either express or implied. See the License for the
19 * specific language governing permissions and limitations
20 * under the License.
|
22 *
| 21 *
|
23 ***********************************************************-->
24
| 22 ***********************************************************-->
23
|
25
26
27
| 24<helpdocument version="1.0">
|
28<meta>
| 25<meta>
|
29 <topic id="textshared0212090101xml" indexer="include" status="PUBLISH">
30 <title xml-lang="en-US" id="tit">Comparison Operators</title>
31 <filename>/text/shared/02/12090101.xhp</filename>
32 </topic>
33 </meta>
34 <body>
35<bookmark xml-lang="en-US" branch="index" id="bm_id3148983"><bookmark_value>comparisons;operators in standard filter dialog</bookmark_value>
36 <bookmark_value>operators;standard filters</bookmark_value>
37 <bookmark_value>standard filters;comparison operators</bookmark_value>
38 <bookmark_value>filters; comparison operators</bookmark_value>
39 <bookmark_value>equal sign, see also operators</bookmark_value>
| 26<topic id="textshared0212090101xml" indexer="include" status="PUBLISH">
27<title xml-lang="en-US" id="tit">Comparison Operators</title>
28<filename>/text/shared/02/12090101.xhp</filename>
29</topic>
30</meta>
31<body>
32<bookmark xml-lang="en-US" branch="index" id="bm_id3148983">
33<bookmark_value>comparisons;operators in standard filter dialog</bookmark_value>
34<bookmark_value>operators;standard filters</bookmark_value>
35<bookmark_value>standard filters;comparison operators</bookmark_value>
36<bookmark_value>filters; comparison operators</bookmark_value>
37<bookmark_value>equal sign, see also operators</bookmark_value>
|
40</bookmark><comment>mw added "equal sign,..."</comment><comment>MW changed "default filters;" into "standard filters;"</comment><comment>mw changed "comparisons;" and "operators;"</comment>
41<paragraph xml-lang="en-US" id="hd_id3148983" role="heading" level="1" l10n="U" oldref="1">Comparison Operators</paragraph>
| 38</bookmark><comment>mw added "equal sign,..."</comment><comment>MW changed "default filters;" into "standard filters;"</comment><comment>mw changed "comparisons;" and "operators;"</comment>
39<paragraph xml-lang="en-US" id="hd_id3148983" role="heading" level="1" l10n="U" oldref="1">Comparison Operators</paragraph>
|
42 <paragraph xml-lang="en-US" id="par_id3155364" role="paragraph" l10n="U" oldref="2">The following comparative operators can be set under <item type="menuitem">Condition</item> in the <item type="menuitem">Standard Filter</item> dialog.</paragraph>
43 <table id="tbl_id3149760">
44 <tablerow>
45 <tablecell>
46 <paragraph xml-lang="en-US" id="par_id3145313" role="paragraph" l10n="U" oldref="3">
47 <emph>Comparative operator</emph>
48 </paragraph>
49 </tablecell>
50 <tablecell>
51 <paragraph xml-lang="en-US" id="par_id3147089" role="paragraph" l10n="U" oldref="4">
52 <emph>Effect</emph>
53 </paragraph>
54 </tablecell>
55 </tablerow>
56 <tablerow>
57 <tablecell>
58 <paragraph xml-lang="en-US" id="par_id3147209" role="paragraph" l10n="U" oldref="5">Equal (=)</paragraph>
59 </tablecell>
60 <tablecell>
61 <paragraph xml-lang="en-US" id="par_id3146797" role="paragraph" l10n="U" oldref="6">Shows values equal to the condition.</paragraph>
62 </tablecell>
63 </tablerow>
64 <tablerow>
65 <tablecell>
66 <paragraph xml-lang="en-US" id="par_id3143271" role="paragraph" l10n="U" oldref="7">Less than (<)</paragraph>
67 </tablecell>
68 <tablecell>
69 <paragraph xml-lang="en-US" id="par_id3153761" role="paragraph" l10n="U" oldref="8">Shows values less than the condition.</paragraph>
70 </tablecell>
71 </tablerow>
72 <tablerow>
73 <tablecell>
74 <paragraph xml-lang="en-US" id="par_id3146807" role="paragraph" l10n="U" oldref="9">Greater than (>)</paragraph>
75 </tablecell>
76 <tablecell>
77 <paragraph xml-lang="en-US" id="par_id3154852" role="paragraph" l10n="U" oldref="10">Shows values greater than the condition.</paragraph>
78 </tablecell>
79 </tablerow>
80 <tablerow>
81 <tablecell>
82 <paragraph xml-lang="en-US" id="par_id3155342" role="paragraph" l10n="U" oldref="11">Less than or equal to (< =)</paragraph>
83 </tablecell>
84 <tablecell>
85 <paragraph xml-lang="en-US" id="par_id3154381" role="paragraph" l10n="U" oldref="12">Shows values that are less than or equal to the condition.</paragraph>
86 </tablecell>
87 </tablerow>
88 <tablerow>
89 <tablecell>
90 <paragraph xml-lang="en-US" id="par_id3153823" role="paragraph" l10n="U" oldref="13">Greater than or equal to (> =)</paragraph>
91 </tablecell>
92 <tablecell>
93 <paragraph xml-lang="en-US" id="par_id3154143" role="paragraph" l10n="U" oldref="14">Shows values that are greater than or equal to the condition.</paragraph>
94 </tablecell>
95 </tablerow>
96 <tablerow>
97 <tablecell>
98 <paragraph xml-lang="en-US" id="par_id3154811" role="paragraph" l10n="U" oldref="15">Not equal (< >)</paragraph>
99 </tablecell>
100 <tablecell>
101 <paragraph xml-lang="en-US" id="par_id3148944" role="paragraph" l10n="U" oldref="16">Shows the values not equal to the condition.</paragraph>
102 </tablecell>
103 </tablerow>
104 <tablerow>
105 <tablecell>
106 <paragraph xml-lang="en-US" id="par_id3149669" role="paragraph" l10n="U" oldref="17">Largest</paragraph>
107 </tablecell>
108 <tablecell>
109 <paragraph xml-lang="en-US" id="par_id3159413" role="paragraph" l10n="U" oldref="18">Shows the N (numeric value as parameter) largest values.</paragraph>
110 </tablecell>
111 </tablerow>
112 <tablerow>
113 <tablecell>
114 <paragraph xml-lang="en-US" id="par_id3151054" role="paragraph" l10n="U" oldref="19">Smallest</paragraph>
115 </tablecell>
116 <tablecell>
117 <paragraph xml-lang="en-US" id="par_id3161657" role="paragraph" l10n="U" oldref="20">Shows the N (numeric value as parameter) smallest values.</paragraph>
118 </tablecell>
119 </tablerow>
120 <tablerow>
121 <tablecell>
122 <paragraph xml-lang="en-US" id="par_id3150400" role="paragraph" l10n="U" oldref="21">Largest %</paragraph>
123 </tablecell>
124 <tablecell>
125 <paragraph xml-lang="en-US" id="par_id3161645" role="paragraph" l10n="U" oldref="22">Shows the largest N% (numeric value as parameter) of the total values.</paragraph>
126 </tablecell>
127 </tablerow>
128 <tablerow>
129 <tablecell>
130 <paragraph xml-lang="en-US" id="par_id3149202" role="paragraph" l10n="U" oldref="23">Smallest %</paragraph>
131 </tablecell>
132 <tablecell>
133 <paragraph xml-lang="en-US" id="par_id3151176" role="paragraph" l10n="U" oldref="24">Shows the smallest N% (numeric value as parameter) of the entire values.</paragraph>
134 </tablecell>
135 </tablerow>
136 </table>
137
138 </body>
| 40<paragraph xml-lang="en-US" id="par_id3155364" role="paragraph" l10n="U" oldref="2">The following comparative operators can be set under <item type="menuitem">Condition</item> in the <item type="menuitem">Standard Filter</item> dialog.</paragraph>
41<table id="tbl_id3149760">
42<tablerow>
43<tablecell>
44<paragraph xml-lang="en-US" id="par_id3145313" role="paragraph" l10n="U" oldref="3">
45<emph>Comparative operator</emph>
46</paragraph>
47</tablecell>
48<tablecell>
49<paragraph xml-lang="en-US" id="par_id3147089" role="paragraph" l10n="U" oldref="4">
50<emph>Effect</emph>
51</paragraph>
52</tablecell>
53</tablerow>
54<tablerow>
55<tablecell>
56<paragraph xml-lang="en-US" id="par_id3147209" role="paragraph" l10n="U" oldref="5">Equal (=)</paragraph>
57</tablecell>
58<tablecell>
59<paragraph xml-lang="en-US" id="par_id3146797" role="paragraph" l10n="U" oldref="6">Shows values equal to the condition.</paragraph>
60</tablecell>
61</tablerow>
62<tablerow>
63<tablecell>
64<paragraph xml-lang="en-US" id="par_id3143271" role="paragraph" l10n="U" oldref="7">Less than (<)</paragraph>
65</tablecell>
66<tablecell>
67<paragraph xml-lang="en-US" id="par_id3153761" role="paragraph" l10n="U" oldref="8">Shows values less than the condition.</paragraph>
68</tablecell>
69</tablerow>
70<tablerow>
71<tablecell>
72<paragraph xml-lang="en-US" id="par_id3146807" role="paragraph" l10n="U" oldref="9">Greater than (>)</paragraph>
73</tablecell>
74<tablecell>
75<paragraph xml-lang="en-US" id="par_id3154852" role="paragraph" l10n="U" oldref="10">Shows values greater than the condition.</paragraph>
76</tablecell>
77</tablerow>
78<tablerow>
79<tablecell>
80<paragraph xml-lang="en-US" id="par_id3155342" role="paragraph" l10n="U" oldref="11">Less than or equal to (< =)</paragraph>
81</tablecell>
82<tablecell>
83<paragraph xml-lang="en-US" id="par_id3154381" role="paragraph" l10n="U" oldref="12">Shows values that are less than or equal to the condition.</paragraph>
84</tablecell>
85</tablerow>
86<tablerow>
87<tablecell>
88<paragraph xml-lang="en-US" id="par_id3153823" role="paragraph" l10n="U" oldref="13">Greater than or equal to (> =)</paragraph>
89</tablecell>
90<tablecell>
91<paragraph xml-lang="en-US" id="par_id3154143" role="paragraph" l10n="U" oldref="14">Shows values that are greater than or equal to the condition.</paragraph>
92</tablecell>
93</tablerow>
94<tablerow>
95<tablecell>
96<paragraph xml-lang="en-US" id="par_id3154811" role="paragraph" l10n="U" oldref="15">Not equal (< >)</paragraph>
97</tablecell>
98<tablecell>
99<paragraph xml-lang="en-US" id="par_id3148944" role="paragraph" l10n="U" oldref="16">Shows the values not equal to the condition.</paragraph>
100</tablecell>
101</tablerow>
102<tablerow>
103<tablecell>
104<paragraph xml-lang="en-US" id="par_id3149669" role="paragraph" l10n="U" oldref="17">Largest</paragraph>
105</tablecell>
106<tablecell>
107<paragraph xml-lang="en-US" id="par_id3159413" role="paragraph" l10n="U" oldref="18">Shows the N (numeric value as parameter) largest values.</paragraph>
108</tablecell>
109</tablerow>
110<tablerow>
111<tablecell>
112<paragraph xml-lang="en-US" id="par_id3151054" role="paragraph" l10n="U" oldref="19">Smallest</paragraph>
113</tablecell>
114<tablecell>
115<paragraph xml-lang="en-US" id="par_id3161657" role="paragraph" l10n="U" oldref="20">Shows the N (numeric value as parameter) smallest values.</paragraph>
116</tablecell>
117</tablerow>
118<tablerow>
119<tablecell>
120<paragraph xml-lang="en-US" id="par_id3150400" role="paragraph" l10n="U" oldref="21">Largest %</paragraph>
121</tablecell>
122<tablecell>
123<paragraph xml-lang="en-US" id="par_id3161645" role="paragraph" l10n="U" oldref="22">Shows the largest N% (numeric value as parameter) of the total values.</paragraph>
124</tablecell>
125</tablerow>
126<tablerow>
127<tablecell>
128<paragraph xml-lang="en-US" id="par_id3149202" role="paragraph" l10n="U" oldref="23">Smallest %</paragraph>
129</tablecell>
130<tablecell>
131<paragraph xml-lang="en-US" id="par_id3151176" role="paragraph" l10n="U" oldref="24">Shows the smallest N% (numeric value as parameter) of the entire values.</paragraph>
132</tablecell>
133</tablerow>
134</table>
135</body>
|
139</helpdocument>
| 136</helpdocument>
|