SpreadsheetGear The Performance Spreadsheet Component Company 
Modify Method
See Also 
SpreadsheetGear Namespace > IValidation Interface : Modify Method
type
Specifies the new type of data validation.
alertStyle
Specifies the alert style to use for alert messages.
validationOperator
Specifies the new 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.
Modifies existing data validation for a range of cells using the specified options.

Syntax

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

Parameters

type
Specifies the new type of data validation.
alertStyle
Specifies the alert style to use for alert messages.
validationOperator
Specifies the new 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