[]
Gets or sets whether the data validation error message will be displayed whenever the user enters invalid data.
Use this property to control whether invalid input displays the validation error alert for the range.
bool ShowError { get; set; }
Property ShowError As Boolean
IValidation validation = worksheet.Range["A1"].Validation;
validation.Add(ValidationType.List, ValidationAlertStyle.Stop, ValidationOperator.Between, "1,2,3", null);
validation.ShowError = false;
bool showError = validation.ShowError;
| Type | Condition |
|---|---|
| ArgumentException | Thrown when no data validation is applied to the range. |