GrapeCity.Documents.Excel.IValidation.IgnoreBlank

IgnoreBlank Property

IgnoreBlank

Gets or sets whether blank values are permitted by the data range validation.

When this property returns true, empty cells in the validated range are allowed without violating the validation rule.

Declaration

bool IgnoreBlank { get; set; }

Property IgnoreBlank As Boolean

Examples

IValidation validation = worksheet.Range["A1:A3"].Validation;
validation.Add(ValidationType.Whole, ValidationAlertStyle.Stop, ValidationOperator.Between, 1, 10);
validation.IgnoreBlank = true;
bool ignoreBlank = validation.IgnoreBlank;