SpreadsheetGear 2012
IValidation Interface Members
Properties  Methods 

The following tables list the members exposed by IValidation.

Public Properties
 NameDescription
 PropertyAlertStyleGets the alert style to be used when validation fails.  
 PropertyErrorMessageGets or sets the error message to display when validation fails.  
 PropertyErrorTitleGets or sets the error title to display when validation fails.  
 PropertyFormula1Returns the first validation formula.  
 PropertyFormula2Returns the second validation formula.  
 PropertyIgnoreBlankGets or sets the property which specifies whether validation should be skipped if either validation formula refers to a blank cell.  
 PropertyInCellDropdownGets or sets the property which specifies whether an in-cell dropdown listbox should be used for validation with a ValidationType of ValidationType.List.  
 PropertyInputMessageGets or sets the input message to be displayed when one of the represented cells is active.  
 PropertyInputTitleGets or sets the input title to be displayed when one of the represented cells is active.  
 PropertyOperatorReturns the ValidationOperator.  
 PropertyShowErrorGets or sets the property which specifies whether errors should be shown when validation fails.  
 PropertyShowInputMessageGets or sets the property which specifies whether an input message should be displayed when one of the represented cells is active.  
 PropertyTypeReturns the type of validation.  
 PropertyValueReturns true if all represented cells meet their validation criteria.  
Top
Public Methods
 NameDescription
 MethodAddAdds data validation to a range of cells using the specified options.  
 MethodDeleteDeletes data validation  
 MethodModifyModifies existing data validation for a range of cells using the specified options.  
Top
See Also

Reference

IValidation Interface
SpreadsheetGear Namespace

Send Feedback