Excel.DataValidationType enum

Represents Data validation type enum.

[ API set: ExcelApi 1.8 ]

Fields

custom = "Custom"

Custom data validation type

date = "Date"

Date data validation type

decimal = "Decimal"

Decimal data validation type

inconsistent = "Inconsistent"

Inconsistent means that the range has inconsistent data validation (there are different rules on different cells)

list = "List"

List data validation type

mixedCriteria = "MixedCriteria"

MixedCriteria means that the range has data validation present on some but not all cells

none = "None"

None means allow any value and so there is no data validation in the range.

textLength = "TextLength"

Text length data validation type

time = "Time"

Time data validation type

wholeNumber = "WholeNumber"

Whole number data validation type