Represents a data type validator for a range of cells.
Declaration Syntax| C# | Visual Basic | Visual C++ |
public class ExcelDataValidator
Public Class ExcelDataValidator
public ref class ExcelDataValidator
Members| All Members | Methods | Properties | |||
| Icon | Member | 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.
|
 | Equals(Object) | (Inherited from Object.) |
| 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.
|
 | Finalize()()() |
Allows an Object to attempt to free resources and perform other cleanup operations before the Object 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.) |
| 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.
|
| MemberwiseClone()()() |
Creates a shallow copy of the current Object.
(Inherited from Object.) |
| 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.
|
| ToString()()() | (Inherited from Object.) |
| Value1 |
Gets or sets the first value or expression for data validation.
|
| Value2 |
Gets or sets the second value or expression for data validation.
|
Inheritance Hierarchy| Object | |
 | ExcelDataValidator |