ComparisonOperator Enumeration

Specifies the comparison operator.

Members

Member	Description
Between	Determines whether a cell value is between the two parameter values.
EqualsTo	Determines whether a cell value is equal to the parameter value.
GreaterThan	Determines whether a cell value is greater than the parameter value.
GreaterThanOrEqualsTo	Determines whether a cell value is greater than or equal to the parameter value.
LessThan	Determines whether a cell value is less than the parameter value.
LessThanOrEqualsTo	Determines whether a cell value is less than or equal to the parameter value.
NotBetween	Determines whether a cell value is not between the two parameter values.
NotEqualsTo	Determines whether a cell value is not equal to the parameter value.

Example

This example creates a validator.

Javascript

spread.highlightInvalidData(true);
var dv = GcSpread.Sheets.DefaultDataValidator.createDateValidator(GcSpread.Sheets.ComparisonOperator.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.getRow(1).dataValidator(dv);

This example creates a rule.

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.CellValueRule(GcSpread.Sheets.ComparisonOperator.Between,2,100,style);
rule.ranges=[new GcSpread.Sheets.Range(0,0,5,1)];
sheet.getConditionalFormats().addRule(rule);
sheet.setValue(0,0,1,3);
sheet.setValue(1,0,45,3);

Inheritance Hierarchy

Object
GcSpread.Sheets.ComparisonOperator

Reference

GcSpread.Sheets Namespace