Excel.Interfaces.DataValidationUpdateData interface

An interface for updating data on the DataValidation object, for use in dataValidation.set({ ... }).

Properties

errorAlert

Error alert when user enters invalid data.

ignoreBlanks

Specifies if data validation will be performed on blank cells. Default is true.

prompt

Prompt when users select a cell.

rule

Data validation rule that contains different type of data validation criteria.

Property Details

errorAlert

Error alert when user enters invalid data.

errorAlert?: Excel.DataValidationErrorAlert;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

ignoreBlanks

Specifies if data validation will be performed on blank cells. Default is true.

ignoreBlanks?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

prompt

Prompt when users select a cell.

prompt?: Excel.DataValidationPrompt;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

rule

Data validation rule that contains different type of data validation criteria.

rule?: Excel.DataValidationRule;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]