Represents a data type validator for a range of cells.
Inheritance Hierarchy
Winnovative.ExcelLibExcelDataValidator
Namespace: Winnovative.ExcelLib
Assembly: wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)
Syntax
The 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.
|
Methods
Name | Description | |
---|---|---|
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
![]() | GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() | MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() | ToString | Returns a string that represents the current object. (Inherited from Object.) |
See Also