ExcelDataValidator Class |
Represents a data type validator for a range of cells.
Inheritance HierarchySystemObject
ExpertXls.ExcelLibExcelDataValidator
ExpertXls.ExcelLibExcelDataValidator
Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 7.0.0
SyntaxThe ExcelDataValidator type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | AllowedDataType |
Gets or sets the data type of the values allowed by this validator.
|
| AllowedValues |
Gets or sets the list of possible string values for a cell.
|
| ErrorAlertStyle |
Gets or sets the style of the error alert.
|
| ErrorAlertText |
Gets or sets the text of the error alert to be shown when user enters invalid data.
|
| ErrorAlertTitle |
Gets or sets the title of the error alert to be shown when user enters invalid data.
|
| InCellDropDown |
Gets or sets a flag indicating if the drop down list with allowed values is displayed in cell. Default value is true.
|
| InputMessageText |
Gets or sets the text of the input message to be shown when the cell to be validated is selected.
|
| InputMessageTitle |
Gets or sets the title of the input message to be shown when the cell to be validated is selected.
|
| Operator |
Gets or sets the operator for data validation.
|
| ShowErrorAlert |
Gets or sets a flag indicating if the error alert is shown when user enters invalid data.
|
| ShowInputMessage |
Gets or sets a flag indicating if the input message is shown when the cell to be validated is selected.
|
| Value1 |
Gets or sets the first value or expression for data validation.
|
| Value2 |
Gets or sets the second value or expression for data validation.
|
See Also