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. |