DS.Documents.Excel Assembly

GrapeCity.Documents.Excel.IValidation.Add

Add Method

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

Adds data validation to the specified range.

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	Required ValidationType. The validation type.
ValidationAlertStyle	alertStyle	Optional Object. The validation alert style.
ValidationOperator	validationOperator	Optional Object. The data validation operator.
object	formula1	Optional Object. The first part of the data validation equation.
object	formula2	Optional Object. The second part of the data validation when Operator is Between or NotBetween (otherwise, this argument is ignored).

Add Method
Add(ValidationType, ValidationAlertStyle, ValidationOperator, object, object)
Declaration
Parameters