SpreadsheetGear The Performance Spreadsheet Component Company 
Add Method
See Also 
SpreadsheetGear Namespace > IValidation Interface : Add Method
type
Specifies the type of data validation to add.
alertStyle
Specifies the alert style to use for alert messages.
validationOperator
Specifies the data validation operator.
formula1
Specifies the first data validation value, formula or list.
formula2
Specifies the second data validation value for ValidationOperator.Between or ValidationOperator.NotBetween.
Adds data validation to a range of cells using the specified options.

Syntax

C# 
virtual void Add( 
   ValidationType type,
   ValidationAlertStyle alertStyle,
   ValidationOperator validationOperator,
   string formula1,
   string formula2
)

Parameters

type
Specifies the type of data validation to add.
alertStyle
Specifies the alert style to use for alert messages.
validationOperator
Specifies the data validation operator.
formula1
Specifies the first data validation value, formula or list.
formula2
Specifies the second data validation value for ValidationOperator.Between or ValidationOperator.NotBetween.

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also