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