DefaultDataValidator type

Represents a data validator.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(condition);

function DefaultDataValidator;

Example

Javascript

//This example validates the cell data.
spread.options.highlightInvalidData = true;
var dv = new GC.Spread.Sheets.DataValidation.createTextLengthValidator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan, 5);
activeSheet.setDataValidator(0, 0, 1, 1, dv, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(0, 0, "abcf");

Inheritance Hierarchy

Object
GC.Spread.Sheets.DataValidation.DefaultDataValidator

Constructors

	Name	Description
	DefaultDataValidator Constructor	Represents a data validator.

Top

Methods

	Name	Description
	comparisonOperator	Gets or sets the comparison operator.
	condition	Gets or sets the condition to validate.
	errorMessage	Gets or sets the error message.
	errorStyle	Gets or sets the error style to display.
	errorTitle	Gets or sets the error title.
	getValidList	Returns the valid data lists if the Data validation type is list; otherwise, returns null.
	highlightStyle	Get or Sets the invalid data cell highlight style.
	ignoreBlank	Gets or sets whether to ignore an empty value.
	inCellDropdown	Gets or sets whether to display a drop-down button.
	inputMessage	Gets or sets the input message.
	inputTitle	Gets or sets the input title.
	isValid	Determines whether the current value is valid.
	reset	Resets the data validator.
	showErrorMessage	Gets or sets whether to display an error message.
	showInputMessage	Gets or sets whether to display the input title and input message.
	type	Gets or sets the criteria type of this data validator.
	value1	Gets the first value of the data validation.
	value2	Gets the second value of the data validation.

Top

Reference

GC.Spread.Sheets.DataValidation Namespace
Using Data Validation