Excel.Interfaces.DataValidationUpdateData interface
An interface for updating data on the DataValidation object, for use in dataValidation.set({ ... }).
| 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. |
Error alert when user enters invalid data.
TypeScript
errorAlert?: Excel.DataValidationErrorAlert;Property Value
Remarks
Specifies if data validation will be performed on blank cells. Default is true.
TypeScript
ignoreBlanks?: boolean;Property Value
boolean
Remarks
Prompt when users select a cell.
TypeScript
prompt?: Excel.DataValidationPrompt;Property Value
Remarks
Data validation rule that contains different type of data validation criteria.
TypeScript
rule?: Excel.DataValidationRule;Property Value
Remarks
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins feedback
Office Add-ins is an open source project. Select a link to provide feedback: