Excel.Interfaces.DataValidationUpdateData interface
An interface for updating data on the DataValidation object, for use in dataValidation.set({ ... }).
Properties
| error |
Error alert when user enters invalid data. |
| ignore |
Specifies if data validation will be performed on blank cells. Default is |
| 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
ignoreBlanks
Specifies if data validation will be performed on blank cells. Default is true.
ignoreBlanks?: boolean;Property Value
boolean
Remarks
prompt
Prompt when users select a cell.
prompt?: Excel.DataValidationPrompt;Property Value
Remarks
rule
Data validation rule that contains different type of data validation criteria.
rule?: Excel.DataValidationRule;