Back to Devexpress

DataValidation Properties

officefileapi-devexpress-dot-spreadsheet-dot-datavalidation-dot-underscore-properties.md

latest2.7 KB
Original Source

DataValidation Properties

Provides access to a data validation rule defined for a worksheet range.

NameDescription
AllowBlankGets or sets whether the data validation treats empty or blank entries as valid.
CriteriaGets or sets the value used in the criterion for the data validation.
Criteria2Gets or sets the value used in the criterion for the data validation.
ErrorMessageGets or sets the message displayed in the error dialog invoked when data validation fails.
ErrorStyleGets or sets the style of the alert dialog window used for data validation.
ErrorTitleGets or sets the caption of the error alert window.
ImeModeGets or sets the IME (input method editor) mode used by the data validation.
InputMessageGets or sets the input message text.
InputTitleGets or sets the title bar text of the input prompt dialog window.
OperatorGets or sets the relational operator used in the data validation rule.
RangeGets or sets the worksheet range to which the data validation rule is applied.
ShowDropDownGets or sets whether to display the dropdown combo box for a validation of the DataValidationType.List type.
ShowErrorMessageGets or sets whether to display the error alert when the user input is not valid.
ShowInputMessageGets or sets whether to display the message prompting the user for data input.
ValidationTypeGets the type of data validation.

See Also

DataValidation Interface

DataValidation Members

DevExpress.Spreadsheet Namespace