SpreadsheetGear
Add Method
See Also  Send Feedback
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

Visual Basic (Declaration) 
Sub Add( _
   ByVal type As ValidationType, _
   ByVal alertStyle As ValidationAlertStyle, _
   ByVal validationOperator As ValidationOperator, _
   ByVal formula1 As String, _
   ByVal formula2 As String _
) 
C# 
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 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2008 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.