GrapeCity.Documents.Excel.IValidation.Add

Add Method

Add(ValidationType, ValidationAlertStyle, ValidationOperator, object, object)

Adds data validation to the specified range.

Uses the specified ValidationType, ValidationAlertStyle, and ValidationOperator to define the validation rule for the range associated with this IValidation object.

Declaration

void Add(ValidationType type, ValidationAlertStyle alertStyle = ValidationAlertStyle.Stop, ValidationOperator validationOperator = ValidationOperator.Between, object formula1 = null, object formula2 = null)

Sub Add(type As ValidationType, Optional alertStyle As ValidationAlertStyle = ValidationAlertStyle.Stop, Optional validationOperator As ValidationOperator = ValidationOperator.Between, Optional formula1 As Object = Nothing, Optional formula2 As Object = Nothing)

Parameters

Type	Name	Description
ValidationType	type	The validation type.
ValidationAlertStyle	alertStyle	The validation alert style.
ValidationOperator	validationOperator	The data validation operator.
object	formula1	The first part of the data validation formula.
object	formula2	The second part of the data validation formula when `validationOperator` is Between or NotBetween; otherwise, this argument is ignored.

Examples

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

Exceptions

Type	Condition
ArgumentException	Thrown when `formula1` or `formula2` is not supported for the specified validation rule, or when `type` is Custom and `formula1` is `null`.