Uses of Class
io.keikai.axyra.sheets.content.Validation

Packages that use Validation

Package	Description
io.keikai.axyra.sheets	Public Java API for the Axyra Sheets engine.
io.keikai.axyra.sheets.content	The objects a workbook or sheet holds besides cell values: charts, tables, data validations, conditional formats, comments, hyperlinks, sparklines, form controls, slicers, timelines, external links, embedded objects and more.

Uses of Validation in io.keikai.axyra.sheets

Methods in io.keikai.axyra.sheets that return types with arguments of type Validation

Modifier and Type	Method	Description
List<Validation>	Sheet.validations()	Returns every data-validation rule on this sheet, in stored order.

Methods in io.keikai.axyra.sheets with parameters of type Validation

Modifier and Type	Method	Description
void	Range.setValidation(Validation validation)	Adds a data-validation rule over this rectangle.

Uses of Validation in io.keikai.axyra.sheets.content

Methods in io.keikai.axyra.sheets.content that return Validation

Modifier and Type	Method	Description
Validation	Validation.Builder.build()	The immutable rule.
static Validation	Validation.custom(String formula)	A custom-formula constraint: an entry is valid when the formula returns TRUE.
static Validation	Validation.date(String operator, String formula1, String formula2)	A date constraint, for example date("between", "DATE(2020,1,1)", "DATE(2020,12,31)").
static Validation	Validation.decimal(String operator, String formula1, String formula2)	A decimal-number constraint, for example decimal("greaterThan", "0", null).
static Validation	Validation.fromJson(String json)	Builds a rule from the engine's JSON, the form behind Sheet.validations().
static Validation	Validation.list(String... items)	A drop-down list of the given allowed values, with its in-cell arrow shown.
static Validation	Validation.textLength(String operator, String formula1, String formula2)	A text-length constraint on the number of characters, for example textLength("lessThanOrEqual", "50", null).
static Validation	Validation.time(String operator, String formula1, String formula2)	A time constraint, for example time("between", "TIME(9,0,0)", "TIME(17,0,0)").
static Validation	Validation.wholeNumber(String operator, String formula1, String formula2)	A whole-number constraint, for example wholeNumber("between", "1", "10").