GrapeCity.Spreadsheet.IValidation

IValidation Interface

Represents data validation for a worksheet range.

public interface IValidation

Public Interface IValidation

Name	Description
AlertStyle	Gets the validation alert style.
ErrorMessage	Gets or sets the data validation error message.
ErrorTitle	Gets or sets the title of the data validation error dialog box.
Formula1	Gets the value or expression associated with the conditional format or data validation.
Formula2	Gets the value or expression associated with the second part of a conditional format or data validation.
IgnoreBlank	Gets a value indicating whether blank values are permitted by the range data validation.
ImeMode	Gets or sets the description of the Japanese input rules.
InCellDropdown	Gets or sets data validation displays a drop-down list that contains acceptable values.
InputMessage	Gets or sets the data validation input message.
InputTitle	Gets or sets the title of the data validation input dialog box.
Operator	Gets a value indicating the operator for the data validation.
ShowError	Gets or sets the data validation error message will be displayed whenever the user enters invalid data.
ShowInput	Gets or sets the data validation input message will be displayed whenever the user selects a cell in the data validation range.
Type	Gets a value indicating the data type validation for a range.
Value	Gets a bool value indicating whether all the validation criteria are met (that is, if the range contains valid data).

Name	Description
Add(DataValidationType, DataValidationErrorStyle, DataValidationOperator, string, string)	Adds data validation to a range of cells using the specified options.
Delete()	Deletes data validation.
Modify(DataValidationType, DataValidationErrorStyle, DataValidationOperator, string, string)	Modifies existing data validation for a range of cells using the specified options.