1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 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 12 * 13 * http://www.apache.org/licenses/LICENSE-2.0 14 * 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. 21 * 22 ***********************************************************--> 23 24<helpdocument version="1.0"> 25<meta> 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> 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">Comparison Operators</paragraph> 40<paragraph xml-lang="en-US" id="par_id3155364" role="paragraph" l10n="U">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"><emph>Comparative operator</emph></paragraph> 45</tablecell> 46<tablecell> 47<paragraph xml-lang="en-US" id="par_id3147089" role="paragraph" l10n="U"><emph>Effect</emph></paragraph> 48</tablecell> 49</tablerow> 50<tablerow> 51<tablecell> 52<paragraph xml-lang="en-US" id="par_id3147209" role="paragraph" l10n="U">Equal (=)</paragraph> 53</tablecell> 54<tablecell> 55<paragraph xml-lang="en-US" id="par_id3146797" role="paragraph" l10n="U">Shows values equal to the condition.</paragraph> 56</tablecell> 57</tablerow> 58<tablerow> 59<tablecell> 60<paragraph xml-lang="en-US" id="par_id3143271" role="paragraph" l10n="U">Less than (<)</paragraph> 61</tablecell> 62<tablecell> 63<paragraph xml-lang="en-US" id="par_id3153761" role="paragraph" l10n="U">Shows values less than the condition.</paragraph> 64</tablecell> 65</tablerow> 66<tablerow> 67<tablecell> 68<paragraph xml-lang="en-US" id="par_id3146807" role="paragraph" l10n="U">Greater than (>)</paragraph> 69</tablecell> 70<tablecell> 71<paragraph xml-lang="en-US" id="par_id3154852" role="paragraph" l10n="U">Shows values greater than the condition.</paragraph> 72</tablecell> 73</tablerow> 74<tablerow> 75<tablecell> 76<paragraph xml-lang="en-US" id="par_id3155342" role="paragraph" l10n="U">Less than or equal to (< =)</paragraph> 77</tablecell> 78<tablecell> 79<paragraph xml-lang="en-US" id="par_id3154381" role="paragraph" l10n="U">Shows values that are less than or equal to the condition.</paragraph> 80</tablecell> 81</tablerow> 82<tablerow> 83<tablecell> 84<paragraph xml-lang="en-US" id="par_id3153823" role="paragraph" l10n="U">Greater than or equal to (> =)</paragraph> 85</tablecell> 86<tablecell> 87<paragraph xml-lang="en-US" id="par_id3154143" role="paragraph" l10n="U">Shows values that are greater than or equal to the condition.</paragraph> 88</tablecell> 89</tablerow> 90<tablerow> 91<tablecell> 92<paragraph xml-lang="en-US" id="par_id3154811" role="paragraph" l10n="U">Not equal (< >)</paragraph> 93</tablecell> 94<tablecell> 95<paragraph xml-lang="en-US" id="par_id3148944" role="paragraph" l10n="U">Shows the values not equal to the condition.</paragraph> 96</tablecell> 97</tablerow> 98<tablerow> 99<tablecell> 100<paragraph xml-lang="en-US" id="par_id3149669" role="paragraph" l10n="U">Largest</paragraph> 101</tablecell> 102<tablecell> 103<paragraph xml-lang="en-US" id="par_id3159413" role="paragraph" l10n="U">Shows the N (numeric value as parameter) largest values.</paragraph> 104</tablecell> 105</tablerow> 106<tablerow> 107<tablecell> 108<paragraph xml-lang="en-US" id="par_id3151054" role="paragraph" l10n="U">Smallest</paragraph> 109</tablecell> 110<tablecell> 111<paragraph xml-lang="en-US" id="par_id3161657" role="paragraph" l10n="U">Shows the N (numeric value as parameter) smallest values.</paragraph> 112</tablecell> 113</tablerow> 114<tablerow> 115<tablecell> 116<paragraph xml-lang="en-US" id="par_id3150400" role="paragraph" l10n="U">Largest %</paragraph> 117</tablecell> 118<tablecell> 119<paragraph xml-lang="en-US" id="par_id3161645" role="paragraph" l10n="U">Shows the largest N% (numeric value as parameter) of the total values.</paragraph> 120</tablecell> 121</tablerow> 122<tablerow> 123<tablecell> 124<paragraph xml-lang="en-US" id="par_id3149202" role="paragraph" l10n="U">Smallest %</paragraph> 125</tablecell> 126<tablecell> 127<paragraph xml-lang="en-US" id="par_id3151176" role="paragraph" l10n="U">Shows the smallest N% (numeric value as parameter) of the entire values.</paragraph> 128</tablecell> 129</tablerow> 130</table> 131</body> 132</helpdocument> 133