Click or drag to resize
DataValidation Class
A single item of data validation defined on ranges of the worksheet.
Inheritance Hierarchy
SystemObject
  GemBox.SpreadsheetDataValidation

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1000
Syntax
public sealed class DataValidation

The DataValidation type exposes the following members.

Constructors
  NameDescription
Public methodDataValidation
Initializes a new instance of the DataValidation class.
Public methodDataValidation(CellRange)
Initializes a new instance of the DataValidation class with specified cell ranges on which this data validation will be applied.
Public methodDataValidation(IEnumerableCellRange)
Initializes a new instance of the DataValidation class with specified cell ranges on which this data validation will be applied.
Public methodDataValidation(ExcelWorksheet, IEnumerableString)
Initializes a new instance of the DataValidation class with specified worksheet and cell references on which this data validation will be applied.
Public methodDataValidation(ExcelWorksheet, String)
Initializes a new instance of the DataValidation class with specified worksheet and cell references on which this data validation will be applied.
Top
Properties
  NameDescription
Public propertyCellRanges
Gets the ranges over which data validation is applied.
Public propertyErrorMessage
Gets or sets the message text of error alert.
Public propertyErrorStyle
Gets or sets the style of error alert used for this data validation.
Public propertyErrorTitle
Gets or sets the title bar text of error alert.
Public propertyFormula1
Gets or sets the first formula in the DataValidation dropdown.
Public propertyFormula2
Gets or sets the second formula in the DataValidation dropdown.
Public propertyIgnoreBlank
Gets or sets a value indicating whether the data validation treats empty or blank entries as valid. means empty entries are OK and do not violate the validation constraints.
Public propertyInCellDropdown
Gets or sets a value indicating whether to display the dropdown combo box for a List data validation type.
Public propertyInputMessage
Gets or sets the message text of input prompt.
Public propertyInputMessageTitle
Gets or sets the title bar text of input prompt.
Public propertyOperator
Gets or sets the relational operator used with this data validation.
Public propertyShowErrorAlert
Gets or sets a value indicating whether to display the error alert message when an invalid value has been entered, according to the criteria specified.
Public propertyShowInputMessage
Gets or sets a value indicating whether to display the input prompt message.
Public propertyType
Gets or sets the type of data validation.
Top
See Also