ValidationModel API in JavaScript (ES5) Spreadsheet API control

Interface for a class Validation

Properties

ignoreBlank

boolean

Specifies IgnoreBlank option in Data Validation.

inCellDropDown

boolean

Specifies InCellDropDown option in Data Validation.

isHighlighted

boolean

specifies to allow Highlight Invalid Data.

operator

ValidationOperator

Specifies Validation Operator.

type

ValidationType

Specifies Validation Type.

value1

string

Specifies Validation Minimum Value.

value2

string

Specifies Validation Maximum Value.