[]
        
(Showing Draft Content)

GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators

Enumeration: ComparisonOperators

Sheets.ConditionalFormatting.ComparisonOperators

Specifies the comparison operator.

example

spread.options.highlightInvalidData = true;
var dv = GC.Spread.Sheets.DataValidation.createDateValidator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between, new Date(2012, 11, 31), new Date(2013, 11, 31));
dv.showInputMessage(true);
dv.inputMessage("Enter a date between 12/31/2012 and 12/31/2013.");
dv.inputTitle("Tip");
activeSheet.getCell(1, -1).validator(dv);

Table of contents

Enumeration members

Enumeration members

between

between = 6

Determines whether a cell value is between the two parameter values.


equalsTo

equalsTo = 0

Determines whether a cell value is equal to the parameter value.


greaterThan

greaterThan = 2

Determines whether a cell value is greater than the parameter value.


greaterThanOrEqualsTo

greaterThanOrEqualsTo = 3

Determines whether a cell value is greater than or equal to the parameter value.


lessThan

lessThan = 4

Determines whether a cell value is less than the parameter value.


lessThanOrEqualsTo

lessThanOrEqualsTo = 5

Determines whether a cell value is less than or equal to the parameter value.


notBetween

notBetween = 7

Determines whether a cell value is not between the two parameter values.


notEqualsTo

notEqualsTo = 1

Determines whether a cell value is not equal to the parameter value.