Validation API in JavaScript (ES5) Spreadsheet API control

Represents the DataValidation.

Properties

ignoreBlank

boolean

Specifies IgnoreBlank option in Data Validation.

Defaults to true

inCellDropDown

boolean

Specifies InCellDropDown option in Data Validation.

Defaults to true

isHighlighted

boolean

specifies to allow Highlight Invalid Data.

Defaults to false

operator

ValidationOperator

Specifies Validation Operator.

Defaults to ‘Between’

type

ValidationType

Specifies Validation Type.

Defaults to ‘WholeNumber’

value1

string

Specifies Validation Minimum Value.

Defaults to ”

value2

string

Specifies Validation Maximum Value.

Defaults to ”