SpreadsheetGear 2023
IValidation Interface Members
Properties  Methods 

SpreadsheetGear Namespace : IValidation Interface

The following tables list the members exposed by IValidation.

Public Properties
 NameDescription
 PropertyGets the alert style to be used when validation fails.  
 PropertyGets or sets the error message to display when validation fails.  
 PropertyGets or sets the error title to display when validation fails.  
 PropertyReturns the first validation formula.  
 PropertyReturns the second validation formula.  
 PropertyGets or sets the property which specifies whether validation should be skipped if either validation formula refers to a blank cell.  
 PropertyGets or sets the property which specifies whether an in-cell dropdown listbox should be used for validation with a ValidationType of ValidationType.List.  
 PropertyGets or sets the input message to be displayed when one of the represented cells is active.  
 PropertyGets or sets the input title to be displayed when one of the represented cells is active.  
 PropertyReturns the ValidationOperator.  
 PropertyGets or sets the property which specifies whether errors should be shown when validation fails.  
 PropertyGets or sets the property which specifies whether an input message should be displayed when one of the represented cells is active.  
 PropertyReturns the type of validation.  
 PropertyReturns true if all represented cells meet their validation criteria.  
Top
Public Methods
 NameDescription
 MethodAdds data validation to a range of cells using the specified options.  
 MethodDeletes data validation  
 MethodModifies existing data validation for a range of cells using the specified options.  
Top
See Also

Reference

IValidation Interface
SpreadsheetGear Namespace