The following tables list the members exposed by IExcelDataValidation.
Public Properties
| Name | Description | |
|---|---|---|
 | AllowBlank | Gets or sets a value indicating whether ignore blank during the data validation. |
| CompareOperator | Gets or sets the data validation compare operator. |
| Error | Gets or sets the error message. |
| ErrorStyle | Gets or sets the error alert style of the data validation. |
| ErrorTitle | Gets or sets the error title. |
| FirstFormula | Gets or sets the first formula in the data validation dropdown. It is used as bounds for 'between' and 'notBetween' relation operators, and the only formula used for other relational operators (equal, notEqual, lessThan, lessThanOrEqual, greaterThan, greaterThanOrEqual), or for custom or list type data validation. The content can be a formula or a constant or a list of series (comma separated values). |
| Prompt | Gets or sets the prompt window message. |
| PromptTitle | Gets or sets the title bar text of input prompt. |
| Ranges | Gets or sets the ranges which data validation is applied. |
| SecondFormula | Gets or sets the second formula in the data validation dropdown. It is used as a bounds for 'between' and 'notBetween' relational operators only. |
| ShowErrorBox | Gets or sets a value indicating whether show error alert box |
| ShowInputMessage | Gets or sets a value indicating whether show input message when cell is selected. |
| ShowPromptBox | Gets or sets a value indicating whether show the prompt window. |
| Type | Gets or sets data validation type. |
See Also