Overview | Module | Use | Devguide | Index

Values | Values' Details

:: com :: sun :: star :: sheet ::
enum ConditionOperator
Description is used to specify the type of XSheetCondition . Developers Guide 8.3.2 Spreadsheet Documents - Working with Spreadsheet Documents - Formatting - 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

Copyright © 2003 Sun Microsystems, Inc.