CriteriaType Enumeration

Indicates the data validator criteria type.

Members

Member	Description
anyValue	Specifies that the data validation allows any type of value and does not check for a type or range of values.
custom	Specifies that the data validation uses a custom formula to check the cell value.
date	Specifies that the data validation checks for and allows date values satisfying the given condition.
decimalValues	Specifies that the data validation checks for and allows decimal values satisfying the given condition.
list	Specifies that the data validation checks for and allows a value that matches one in a list of values.
textLength	Specifies that the data validation checks for and allows text values whose length satisfies the given condition.
time	Specifies that the data validation checks for and allows time values satisfying the given condition.
wholeNumber	Specifies that the data validation checks for and allows whole number values satisfying the given condition.

Example

This example returns the type.

Javascript

spread.options.highlightInvalidData = true;
var dv = GC.Spread.Sheets.DataValidation.createListValidator("1,2,3");
dv.showInputMessage(true);
dv.inputMessage("Value must be 1, 2 or 3.");
dv.inputTitle("tip");
activeSheet.setDataValidator(1, 1, 1, 1, dv, GC.Spread.Sheets.SheetArea.viewport); 
alert(dv.type());

This example uses the CriteriaType enumeration.

Javascript

var textLengthCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textLengthCondition);
textLengthCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators.greaterThan);
textLengthCondition.formula("$C$1"); // formula used to calculate a number.
var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(textLengthCondition);
validator.type(GC.Spread.Sheets.DataValidation.CriteriaType.custom);
activeSheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.viewport).validator(validator);
spread.options.highlightInvalidData = true;
activeSheet.setValue(0, 0, "abcf");
 
//Set value 3 to $C$1, after this code, the value in Cell(0,0) is valid.
activeSheet.setValue(0, 2, 3);
//Set value 5 to $C$1, after this code, the value in Cel(0,0) is invalid.
// activeSheet.setValue(0, 2, 5);

Inheritance Hierarchy

Object
GC.Spread.Sheets.DataValidation.CriteriaType

Reference

GC.Spread.Sheets.DataValidation Namespace