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;
Property Value
Remarks
Office Add-ins
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for