SpreadsheetGear Namespace : IValidation Interface |
The following tables list the members exposed by IValidation.
Name | Description | |
---|---|---|
AlertStyle | Gets the alert style to be used when validation fails. | |
ErrorMessage | Gets or sets the error message to display when validation fails. | |
ErrorTitle | Gets or sets the error title to display when validation fails. | |
Formula1 | Returns the first validation formula. | |
Formula2 | Returns the second validation formula. | |
IgnoreBlank | Gets or sets the property which specifies whether validation should be skipped if either validation formula refers to a blank cell. | |
InCellDropdown | Gets or sets the property which specifies whether an in-cell dropdown listbox should be used for validation with a ValidationType of ValidationType.List. | |
InputMessage | Gets or sets the input message to be displayed when one of the represented cells is active. | |
InputTitle | Gets or sets the input title to be displayed when one of the represented cells is active. | |
Operator | Returns the ValidationOperator. | |
ShowError | Gets or sets the property which specifies whether errors should be shown when validation fails. | |
ShowInputMessage | Gets or sets the property which specifies whether an input message should be displayed when one of the represented cells is active. | |
Type | Returns the type of validation. | |
Value | Returns true if all represented cells meet their validation criteria. |
Name | Description | |
---|---|---|
Add | Adds data validation to a range of cells using the specified options. | |
Delete | Deletes data validation | |
Modify | Modifies existing data validation for a range of cells using the specified options. |