XlDataValidation Members
In This Article
#Constructors
Name | Description |
---|---|
Xl |
Initializes a new instance of the Xl |
#Properties
Name | Description |
---|---|
Allow |
Gets or sets whether the data validation treats empty or blank entries as valid. |
Criteria1 | Gets or sets the value used in the criterion for data validation. |
Criteria2 | Gets or sets the value used in the criterion for data validation. |
Error |
Gets or sets the error message to display when the entered data is not valid. |
Error |
Gets or sets the style or the alert dialog window used to show the error message. |
Error |
Gets or sets the caption of the error alert window. |
Ime |
Gets or sets the input method editor (IME) mode used by the data validation. |
Input |
Gets or sets the text for the input prompt message. |
List |
Gets or sets the lists of cell ranges whose values should be used as the data validation criteria. |
List |
Provides access to the list of values used in the data validation rule. |
Operator | Gets or sets the relational operator used in the data validation rule. |
Prompt |
Gets or sets the title bar text of the prompt message. |
Ranges | Provides access to the collection of cell ranges to which the data validation rule is applied. |
Show |
Gets or sets whether to display the dropdown combo box for the Xl |
Show |
Gets or sets whether to show the error message when the user input is not valid. |
Show |
Gets or sets whether to show the input message. |
Type | Gets or sets the type of data validation. |
#Methods
Name | Description |
---|---|
Equals |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
Gets the Type of the current instance. Inherited from Object. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
To |
Returns a string that represents the current object. Inherited from Object. |
See Also