DataValidation
Overview
DataValidation is a class in Aspose.Cells FOSS for Typescript.
DataValidation objects let you specify validation rules, including type, operator, two formulas, and UI options like allowBlank, showDropDown, and custom messages.
This class provides 3 methods for working with DataValidation objects in Typescript programs.
Available methods include: addArea, getRanges, toXml.
All public members are accessible to any Typescript application after installing the Aspose.Cells FOSS for Typescript package.
Properties: allowBlank, errorMessage, errorStyle, errorTitle, formula1, formula2, and 6 more.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
type | DataValidationType["type"] | Read/Write | Gets the type. |
operator | DataValidationType["operator"] | undefined | Read/Write | Gets the operator. |
formula1 | string | undefined | Read/Write | Gets the formula1. |
formula2 | string | undefined | Read/Write | Gets the formula2. |
allowBlank | boolean | Read/Write | Gets the allow blank. |
showDropDown | boolean | Read/Write | Gets the show drop down. |
showInputMessage | boolean | Read/Write | Gets the show input message. |
inputTitle | string | undefined | Read/Write | Gets the input title. |
inputMessage | string | undefined | Read/Write | Gets the input message. |
errorTitle | string | undefined | Read/Write | Gets the error title. |
errorMessage | string | undefined | Read/Write | Gets the error message. |
errorStyle | DataValidationType["errorStyle"] | undefined | Read/Write | Gets the error style. |
Methods
| Signature | Description |
|---|---|
addArea(range: string) | Calls addArea on this DataValidation instance. |
getRanges() → CellRange[] | Returns the ranges. |
toXml() → string | Calls toXml on this DataValidation instance. |