<html> <head> <title>Constants' Group ConditionOperator2</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="navimainnone">Use</td> <td class="navimainnone">Devguide</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="#Constants" class="navisub">Constants</a></td> <td class="navisub"><a href="#ConstantDetails" class="navisub">Constants' 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">constants group ConditionOperator2</td> </tr> <tr> <td/></tr> </table> <hr> <a name="Constants"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constants</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> <tr> <td class="imsum_left"><a href="#DUPLICATE">DUPLICATE</a></td> <td class="imsum_right">Conditionally format duplicate values </td> </tr> <tr> <td class="imsum_left"><a href="#NOT_DUPLICATE">NOT_DUPLICATE</a></td> <td class="imsum_right">Conditionally format non-duplicate values </td> </tr> </table> <a name="ConstantDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Constants' 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>const long <b>NONE</b> = 0;<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>const long <b>EQUAL</b> = 1;<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>const long <b>NOT_EQUAL</b> = 2;<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>const long <b>GREATER</b> = 3;<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>const long <b>GREATER_EQUAL</b> = 4;<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>const long <b>LESS</b> = 5;<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>const long <b>LESS_EQUAL</b> = 6;<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>const long <b>BETWEEN</b> = 7;<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>const long <b>NOT_BETWEEN</b> = 8;<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>const long <b>FORMULA</b> = 9;<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> <tr> <td class="imdetail"><a name="DUPLICATE" class="membertitle">DUPLICATE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DUPLICATE</b> = 10;<hr> <dl> <dt><b>Description</b></dt> <dd>Conditionally format duplicate values </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NOT_DUPLICATE" class="membertitle">NOT_DUPLICATE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>NOT_DUPLICATE</b> = 11;<hr> <dl> <dt><b>Description</b></dt> <dd>Conditionally format non-duplicate values </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.</p><p class="copyright" align="center">LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.</p><p class="copyright" align="center">The Document Foundation acknowledges all community members, please find more info <a href="http://www.libreoffice.org/about-us/credits/" target="_blank">at our website</a>.<p> </p><p class="copyright" align="center"><a href="http://www.libreoffice.org/privacy" target="_blank">Privacy Policy</a> | <a href="http://www.libreoffice.org/imprint" target="_blank">Impressum (Legal Info)</a> | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (<a href="http://www.libreoffice.org/download/license/" target="_blank">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="http://wiki.documentfoundation.org/TradeMark_Policy" target="_blank">trademark policy</a>.</p> </div> <!-- id="adc-idlref" --> </body> </html>
