GrapeCity.Spreadsheet.IValidation.Modify

Modify Method

Modify(DataValidationType, DataValidationErrorStyle, DataValidationOperator, string, string)

Modifies existing data validation for a range of cells using the specified options.

Declaration

IValidation Modify(DataValidationType type, DataValidationErrorStyle errorStyle = DataValidationErrorStyle.Stop, DataValidationOperator @operator = DataValidationOperator.Between, string formula1 = null, string formula2 = null)

Function Modify(type As DataValidationType, Optional errorStyle As DataValidationErrorStyle = DataValidationErrorStyle.Stop, Optional [operator] As DataValidationOperator = DataValidationOperator.Between, Optional formula1 As String = Nothing, Optional formula2 As String = Nothing) As IValidation

Parameters

Type	Name	Description
DataValidationType	type	A DataValidationType value indicates the type of data validation to add.
DataValidationErrorStyle	errorStyle	A DataValidationErrorStyle value indicates the error style to use for error messages.
DataValidationOperator	operator	A DataValidationOperator value indicates the data validation operator.
string	formula1	A string value indicates the first data validation value, formula or list.
string	formula2	A string value indicates the second data validation value for Between or NotBetween.

Returns

Type	Description
IValidation	The modified data validation. `null` if the data validation cannot be modified.

Remarks

Because formula1 and formula2 properties are also used for primitive value, the formula must start with "=".