Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: sheet ::

enum ConditionOperator
Description
is used to specify the type of XSheetCondition.
Developers Guide
Spreadsheets - Conditional Formats

Values
NONE no condition is specified.  
EQUAL value has to be equal to the specified value.  
NOT_EQUAL the value must not be equal to the specified value.  
GREATER the value has to be greater than the specified value.  
GREATER_EQUAL the value has to be greater than or equal to the specified value.  
LESS the value has to be less than the specified value.  
LESS_EQUAL the value has to be less than or equal to the specified value.  
BETWEEN the value has to be between the two specified values.  
NOT_BETWEEN the value has to be outside of the two specified values.  
FORMULA the specified formula has to give a non-zero result.  
Values' Details
NONE
NONE,
Description
no condition is specified.
EQUAL
EQUAL,
Description
value has to be equal to the specified value.
NOT_EQUAL
NOT_EQUAL,
Description
the value must not be equal to the specified value.
GREATER
GREATER,
Description
the value has to be greater than the specified value.
GREATER_EQUAL
GREATER_EQUAL,
Description
the value has to be greater than or equal to the specified value.
LESS
LESS,
Description
the value has to be less than the specified value.
LESS_EQUAL
LESS_EQUAL,
Description
the value has to be less than or equal to the specified value.
BETWEEN
BETWEEN,
Description
the value has to be between the two specified values.
NOT_BETWEEN
NOT_BETWEEN,
Description
the value has to be outside of the two specified values.
FORMULA
FORMULA,
Description
the specified formula has to give a non-zero result.
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.