| GC.Spread.Sheets.ConditionalFormatting Namespace : ComparisonOperators Enumeration |
| 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. |
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);
var style = new GC.Spread.Sheets.Style(); style.backColor = "red"; var ranges=[new GC.Spread.Sheets.Range(0,0,5,1)]; activeSheet.conditionalFormats.addCellValueRule(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between, 2, 100, style, ranges); activeSheet.setValue(0,0,1,3); activeSheet.setValue(1,0,45,3);
Object
GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators