ExcelDataValidation Properties
From Office Open XML
The ExcelDataValidation type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
| Address |
Address of data validation
| |
| AllowBlank |
True if blanks should be allowed
| |
| AllowsOperator |
True if the validation type allows operator to be set.
| |
| Error |
Error message box text
| |
| ErrorStyle |
Warning style
| |
| ErrorTitle |
Title of error message box
| |
| Operator |
Operator for comparison between the entered value and Formula/Formulas.
| |
| Prompt | ||
| PromptTitle | ||
| ShowErrorMessage |
True if error message should be shown
| |
| ShowInputMessage |
True if input message should be shown
| |
| ValidationType |
Validation type
|