Validation

23 Sep 20251 minute to read

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 ’’