<html> <head> <title>Enum ConditionOperator</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="ConditionOperator-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Conditional_Formats" class="navimain">Devguide</a></td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#Values" class="navisub">Values</a></td> <td class="navisub"><a href="#ValueDetails" class="navisub">Values' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sheet</a> :: </p> </td> </tr> <tr> <td class="title">enum ConditionOperator</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>is used to specify the type of <a href="XSheetCondition.html">XSheetCondition</a>. </dd> </dl> <a name="devmanual"> </a><dl> <dt><b>Developers Guide</b></dt> <dd><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Conditional_Formats">Spreadsheets - Conditional Formats</a></dd> </dl> </td> </tr> </table> <hr> <a name="Values"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Values</td> </tr> <tr> <td class="imsum_left"><a href="#NONE">NONE</a></td> <td class="imsum_right">no condition is specified. </td> </tr> <tr> <td class="imsum_left"><a href="#EQUAL">EQUAL</a></td> <td class="imsum_right">value has to be equal to the specified value. </td> </tr> <tr> <td class="imsum_left"><a href="#NOT_EQUAL">NOT_EQUAL</a></td> <td class="imsum_right">the value must not be equal to the specified value. </td> </tr> <tr> <td class="imsum_left"><a href="#GREATER">GREATER</a></td> <td class="imsum_right">the value has to be greater than the specified value. </td> </tr> <tr> <td class="imsum_left"><a href="#GREATER_EQUAL">GREATER_EQUAL</a></td> <td class="imsum_right">the value has to be greater than or equal to the specified value. </td> </tr> <tr> <td class="imsum_left"><a href="#LESS">LESS</a></td> <td class="imsum_right">the value has to be less than the specified value. </td> </tr> <tr> <td class="imsum_left"><a href="#LESS_EQUAL">LESS_EQUAL</a></td> <td class="imsum_right">the value has to be less than or equal to the specified value. </td> </tr> <tr> <td class="imsum_left"><a href="#BETWEEN">BETWEEN</a></td> <td class="imsum_right">the value has to be between the two specified values. </td> </tr> <tr> <td class="imsum_left"><a href="#NOT_BETWEEN">NOT_BETWEEN</a></td> <td class="imsum_right">the value has to be outside of the two specified values. </td> </tr> <tr> <td class="imsum_left"><a href="#FORMULA">FORMULA</a></td> <td class="imsum_right">the specified formula has to give a non-zero result. </td> </tr> </table> <a name="ValueDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Values' Details</td> </tr> <tr> <td class="imdetail"><a name="NONE" class="membertitle">NONE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>NONE</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>no condition is specified. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="EQUAL" class="membertitle">EQUAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>EQUAL</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>value has to be equal to the specified value. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NOT_EQUAL" class="membertitle">NOT_EQUAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>NOT_EQUAL</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>the value must not be equal to the specified value. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="GREATER" class="membertitle">GREATER</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>GREATER</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>the value has to be greater than the specified value. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="GREATER_EQUAL" class="membertitle">GREATER_EQUAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>GREATER_EQUAL</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>the value has to be greater than or equal to the specified value. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="LESS" class="membertitle">LESS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>LESS</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>the value has to be less than the specified value. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="LESS_EQUAL" class="membertitle">LESS_EQUAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>LESS_EQUAL</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>the value has to be less than or equal to the specified value. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="BETWEEN" class="membertitle">BETWEEN</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>BETWEEN</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>the value has to be between the two specified values. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NOT_BETWEEN" class="membertitle">NOT_BETWEEN</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>NOT_BETWEEN</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>the value has to be outside of the two specified values. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="FORMULA" class="membertitle">FORMULA</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>FORMULA</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>the specified formula has to give a non-zero result. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.</p> </div> <!-- id="adc-idlref" --> </body> </html>