Validation

Overview

Validation is a class in Aspose.Cells FOSS for Java.

Represents a data validation rule applied to one or more cell areas.

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.