Validation
Overview
Validation is a class in Aspose.Cells FOSS for Java.
Represents a data validation rule applied to one or more cell areas.
This class provides 30 methods for working with Validation objects in Java programs.
Available methods include: addArea, delete, getAlertStyle, getAreas, getErrorMessage, getErrorTitle, getFormula1, getFormula2, getIgnoreBlank, getInCellDropDown, getInputMessage, getInputTitle, and 18 additional methods.
All exported members are accessible to any Java application after installing the Aspose.Cells FOSS for Java package.
Properties: alertStyle, areas, errorMessage, errorTitle, formula1, formula2, and 8 more.
Description
Validation is a class in the Aspose.Cells FOSS library for Java that exposes 30 methods and 14 properties for programmatic use.
Core capabilities include: list<cellarea>; validationtype; validationalerttype. These operations enable developers to integrate validation functionality directly into Java applications.
The class also provides the areas property (returns the list of cell areas covered by this validation), the type property (returns the type), the alertStyle property (returns the alert style).
Properties
| Name | Type | Access | Description |
|---|---|---|---|
areas | List<CellArea> | Read | Returns the list of cell areas covered by this validation. |
type | ValidationType | Read | Returns the type. |
alertStyle | ValidationAlertType | Read | Returns the alert style. |
operator | OperatorType | Read | Returns the operator. |
formula1 | String | Read | Returns the formula 1. |
formula2 | String | Read | Returns the formula 2. |
ignoreBlank | boolean | Read | Returns the ignore blank. |
inCellDropDown | boolean | Read | Returns the in cell drop down. |
inputTitle | String | Read | Returns the input title. |
inputMessage | String | Read | Returns the input message. |
errorTitle | String | Read | Returns the error title. |
errorMessage | String | Read | Returns the error message. |
showInput | boolean | Read | Returns the show input. |
showError | boolean | Read | Returns the show error. |
Methods
| Signature | Description |
|---|---|
getAreas() → List<CellArea> | Returns the list of cell areas covered by this validation. |
getType() → ValidationType | Returns the type. |
setType(type: ValidationType) | Sets the type. |
getAlertStyle() → ValidationAlertType | Returns the alert style. |
setAlertStyle(alertStyle: ValidationAlertType) | Sets the alert style. |
getOperator() → OperatorType | Returns the operator. |
setOperator(operator: OperatorType) | Sets the operator. |
getFormula1() → String | Returns the formula 1. |
setFormula1(value: String) | Sets the formula 1. |
getFormula2() → String | Returns the formula 2. |
setFormula2(value: String) | Sets the formula 2. |
getIgnoreBlank() → boolean | Returns the ignore blank. |
setIgnoreBlank(ignoreBlank: boolean) | Sets the ignore blank. |
getInCellDropDown() → boolean | Returns the in cell drop down. |
setInCellDropDown(inCellDropDown: boolean) | Sets the in cell drop down. |
getInputTitle() → String | Returns the input title. |
setInputTitle(value: String) | Sets the input title. |
getInputMessage() → String | Returns the input message. |
setInputMessage(value: String) | Sets the input message. |
getErrorTitle() → String | Returns the error title. |
setErrorTitle(value: String) | Sets the error title. |
getErrorMessage() → String | Returns the error message. |
setErrorMessage(value: String) | Sets the error message. |
getShowInput() → boolean | Returns the show input. |
setShowInput(showInput: boolean) | Sets the show input. |
getShowError() → boolean | Returns the show error. |
setShowError(showError: boolean) | Sets the show error. |
addArea(area: CellArea) | Adds area. |
removeArea(area: CellArea) | Removes area. |
delete() | Removes this validation rule from the collection. |
