Validation
Overview
Validation is a class in Aspose.Cells for NET.
Validation.AddArea(area) adds the given CellArea to the validation’s target ranges.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
Areas | IReadOnlyList<CellArea> | Read | Gets a read‑only list of CellArea objects defining the validation’s ranges |
Type | ValidationType | Read/Write | Gets or sets the ValidationType that specifies the kind of data validation |
AlertStyle | ValidationAlertType | Read/Write | Gets or sets the ValidationAlertType that determines how alerts are shown |
Operator | OperatorType | Read/Write | Gets or sets the OperatorType used to compare formula values |
Formula1 | string | Read/Write | Gets or sets the first formula string used in the validation rule |
Formula2 | string | Read/Write | |
IgnoreBlank | bool | Read/Write | Gets or sets a Boolean indicating whether blank cells are ignored |
InCellDropDown | bool | Read/Write | Gets or sets whether a drop‑down list is displayed in the cell |
InputTitle | string | Read/Write | Gets or sets the title displayed in the input message dialog |
InputMessage | string | Read/Write | Gets or sets the message shown when a cell is selected |
ErrorTitle | string | Read/Write | Gets or sets the title displayed in the error alert dialog |
ErrorMessage | string | Read/Write | Gets or sets the message shown when validation fails |
ShowInput | bool | Read/Write | Gets or sets a Boolean indicating whether the input message is shown |
ShowError | bool | Read/Write | Gets or sets whether the error alert is displayed on validation failure |
Methods
| Signature | Description |
|---|---|
AddArea(area: CellArea) | Adds the given CellArea to the validation’s target ranges |
RemoveArea(area: CellArea) | Removes the specified CellArea from the validation’s target ranges |