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 98, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0. SpreadsheetGear for .NET 2006 requires the Microsoft .NET Framework 2.0.

See Also