DefaultDataValidator type

Represents a data validator.

Syntax

var instance = new GcSpread.Sheets.DefaultDataValidator(condition);

function DefaultDataValidator;

Inheritance Hierarchy

Object
GcSpread.Sheets.DefaultDataValidator

Constructors

	Name	Description
	DefaultDataValidator Constructor	Represents a data validator.

Fields

	Name	Description
	comparisonOperator	Indicates the comparison operator.
	condition	Indicates the condition to validate.
	errorMessage	Indicates the error message.
	errorStyle	Indicates the error style to display.
	errorTitle	Indicates the error title.
	ignoreBlank	Indicates whether to ignore an empty value.
	inCellDropdown	Indicates whether to display a drop-down button.
	inputMessage	Indicates the input message.
	inputTitle	Indicates the input title.
	showErrorMessage	Indicates whether to display an error message.
	showInputMessage	Indicates whether to display the input title and input message.
	type	Indicates the criteria type of this data validator.

Methods

	Name	Description
	createDateValidator	Creates a validator based on the data.
	createFormulaListValidator	Creates a validator based on a formula list.
	createFormulaValidator	Creates a validator based on a formula.
	createListValidator	Creates a validator based on a list.
	createNumberValidator	Creates a validator based on numbers.
	createTextLengthValidator	Creates a validator based on text length.
	getValidList	Returns the valid data lists if the Data validation type is list; otherwise, returns null.
	IgnoreBlank	Gets or sets whether to ignore an empty value.
	isValid	Determines whether the current value is valid.
	reset	Resets the data validator.
	value1	Gets the first value of the data validation.
	value2	Gets the second value of the data validation.