DataValidation
Overview
DataValidation is a class in Aspose.Cells FOSS for TypeScript.
This class declares 3 methods for DataValidation objects in TypeScript programs.
Available methods include: addArea, getRanges, toXml.
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(range) on this DataValidation instance. |
getRanges() → CellRange[] | Returns the ranges. |
toXml() → string | Calls toXml on this DataValidation instance. |