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.highlightInvalidData(true);
var dv = GcSpread.Sheets.DefaultDataValidator.createListValidator("1,2,3");
dv.showInputMessage = true;
dv.inputMessage = "Value must be 1, 2 or 3.";
dv.inputTitle = "tip";
activeSheet.setDataValidator(1, 1, dv); 
alert(dv.type);

Inheritance Hierarchy

Object
GcSpread.Sheets.CriteriaType

Reference

GcSpread.Sheets Namespace