Validator Element

The validator elements are numberValidator, dateValidator, textLengthValidator, formulaValidator, formulaListValidator, and listValidator.

The following table lists the attributes of the base validator.

Attribute	API Reference	Type
errorMessage	`DefaultDataValidator.errorMessage`	`string`
errorStyle	`DefaultDataValidator.errorStyle`	`GC.Spread.Sheets.DataValidation.ErrorStyle`
errorTitle	`DefaultDataValidator.errorTitle`	`string`
ignoreBlank	`DefaultDataValidator.ignoreBlank`	`boolean`
inCellDropdown	`DefaultDataValidator.inCellDropdown`	`Boolean`
inputMessage	`DefaultDataValidator.inputMessage`	`string`
inputTitle	`DefaultDataValidator.inputTitle`	`string`
showErrorMessage	`DefaultDataValidator.showErrorMessage`	`Boolean`
showInputMessage	`DefaultDataValidator.showInputMessage`	`Boolean`

The numberValidator element has no child elements. The following table lists the attributes of the numberValidator element.

Attribute	API Reference	Type
comparisonOperator	`DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue)`	`GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators`
isIntegerValue	`DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue)`	`Boolean`
value1	`DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue)`	`string`
value2	`DefaultDataValidator.createNumberValidator(comparisonOperator, value, value2, isIntegerValue)`	`string`

The dateValidator element has no child elements. The following table lists the attributes of the dateValidator element.

Attribute	API Reference	Type
comparisonOperator	`DefaultDataValidator.createDateValidator(comparisonOperator, value, value2)`	`GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators`
value1	`DefaultDataValidator.createDateValidator(comparisonOperator, value, value2)`	`string`
value2	`DefaultDataValidator.createDateValidator(comparisonOperator, value, value2)`	`string`

The textLengthValidator element has no child elements. The following table lists the attributes of the textLengthValidator element.

Attribute	API Reference	Type
comparisonOperator	`DefaultDataValidator.createTextLengthValidator(comparisonOperator, value, value2)`	`GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators`
value1	`DefaultDataValidator.createTextLengthValidator(comparisonOperator, value, value2)`	`string`
value2	`DefaultDataValidator.createTextLengthValidator(comparisonOperator, value, value2)`	`string`

The formulaValidator element has no child elements. The following table lists the attributes of the formulaValidator element.

Attribute	API Reference	Type
formula	`DefaultDataValidator.createFormulaValidator(formula)`	`string`

The formulaListValidator element has no child elements. The following table lists the attributes of the formulaListValidator element.

Attribute	API Reference	Type
formulalist	`DefaultDataValidator.createFormulaListValidator(formulalist)`	`string`

The listValidator element has no child elements. The following table lists the attributes of the listValidator element.

Attribute	API Reference	Type
list	`DefaultDataValidator.createListValidator(list)`	`string`