SpreadJS Documentation
Using the Validator Element

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

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) GcSpread.Sheets.ComparisonOperator
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) GcSpread.Sheets.ComparisonOperator
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) GcSpread.Sheets.ComparisonOperator
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

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.