IValidation Interface

Represents data validation for a worksheet range.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IValidation

Public Interface IValidation

Properties

Name	Description
AlertStyle	Gets or sets the validation alert style.
ErrorMessage	Gets or sets the data validation error message (read or write).
ErrorTitle	Gets or sets the title of the data-validation error dialog box (read or write).
Formula1	Gets or sets the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula (read-only string).
Formula2	Gets or sets the value or expression associated with the second part of a conditional format or data validation (read-only string).
IMEMode	Gets or sets the description of the Japanese input rules.
IgnoreBlank	Gets or sets whether blank values are permitted by the data range validation (read or write).
InCellDropdown	Gets or sets whether data validation displays a drop-down list that contains acceptable values.
InputMessage	Gets or sets the data validation input message (read or write string).
InputTitle	Gets or sets the title of the data-validation input dialog box (read or write string).
Operator	Gets or sets the operator for the conditional format or data validation (read-only).
ShowError	Gets or sets whether the data validation error message will be displayed whenever the user enters invalid data (read or write).
ShowInputMessage	Gets or sets whether the data validation input message is displayed whenever the user selects a cell in the data validation range (read or write).
Type	Gets or sets the data type validation for a range (read-only).
Value	Gets whether all the validation criteria are met (that is, if the range contains valid data). This property is read-only.

Methods

Name	Description
Add(ValidationType, ValidationAlertStyle, ValidationOperator, object, object)	Adds data validation to the specified range.
Delete()	Deletes the object.
FromJson(string)	Generates the data validation from the JSON string.
ToJson()	Generates a JSON string from the data validation.