Skip to main content

XlDataValidation Members

Represents the data validation rule defined for a current worksheet.

Constructors

Name	Description
XlDataValidation()	Initializes a new instance of the XlDataValidation class with the default settings.

Properties

Name	Description
AllowBlank	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.
ErrorMessage	Gets or sets the error message to display when the entered data is not valid.
ErrorStyle	Gets or sets the style or the alert dialog window used to show the error message.
ErrorTitle	Gets or sets the caption of the error alert window.
ImeMode	Gets or sets the input method editor (IME) mode used by the data validation.
InputPrompt	Gets or sets the text for the input prompt message.
ListRange	Gets or sets the lists of cell ranges whose values should be used as the data validation criteria.
ListValues	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.
PromptTitle	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.
ShowDropDown	Gets or sets whether to display the dropdown combo box for the XlDataValidationType.List validation rule.
ShowErrorMessage	Gets or sets whether to show the error message when the user input is not valid.
ShowInputMessage	Gets or sets whether to show the input message.
Type	Gets or sets the type of data validation.

Name	Description
Equals(Object, Object) static	Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)	Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode()	Serves as the default hash function. Inherited from Object.
GetType()	Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected	Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static	Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString()	Returns a string that represents the current object. Inherited from Object.

See Also

XlDataValidation Class

DevExpress.Export.Xl Namespace

Was this page helpful?

Thanks for your feedback!

How can we improve this help topic?

Add an example/code snippet.

Improve topic clarity.

Improve organization/make it easier to find.

Include additional information/content.

Additional comments/thoughts:

If you have any questions, submit a ticket to our Support Center.

No

Your feedback is appreciated.