Uses of Interface
io.keikai.axyra.sheets.CellValue

Packages that use CellValue

Package	Description
io.keikai.axyra.sheets	Public Java API for the Axyra Sheets engine.
io.keikai.axyra.sheets.formula	User-defined formula functions and the built-in function catalog.

Uses of CellValue in io.keikai.axyra.sheets

Classes in io.keikai.axyra.sheets that implement CellValue

Modifier and Type	Class	Description
static final record	CellValue.Array	A rectangular, row-major matrix of scalar values (rows[r][c]).
static final record	CellValue.Blank	The empty cell value; use the shared BLANK.
static final record	CellValue.Bool	A boolean cell value.
static final record	CellValue.Error	An error cell value, identified by its Excel ERROR.TYPE code (see error(int) for the codes).
static final record	CellValue.Number	A numeric cell value.
static final record	CellValue.Text	A text cell value.

Methods in io.keikai.axyra.sheets that return CellValue

Modifier and Type	Method	Description
static CellValue	CellValue.array(CellValue[][] rows)	A row-major matrix value (see CellValue.Array) — the shape of a range argument to a typed user-defined function, or of an array result returned from one.
static CellValue	CellValue.blank()	Returns BLANK, the value of an empty cell.
static CellValue	CellValue.bool(boolean value)	A boolean value: TRUE or FALSE.
static CellValue	CellValue.error(int code)	An error value from its Excel ERROR.TYPE code: 1 #NULL!, 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A, 8 #GETTING_DATA, 9 #SPILL!, 14 #CALC!.
CellValue	Workbook.evaluate(String formula)	Evaluates an ad-hoc formula (leading = optional) in the first sheet's context.
CellValue	Workbook.evaluate(String formula, Sheet sheet)	Evaluates an ad-hoc formula in sheet's context: references without a sheet name read that sheet.
CellValue	CellValue.Array.get(int row, int col)	Returns the value at (row, col), both 0-based.
static CellValue	CellValue.number(double value)	A numeric value.
CellValue[][]	CellValue.Array.rows()	Returns the value of the rows record component.
static CellValue	CellValue.text(String value)	A text value, stored as typed: a numeric-looking string stays text.
CellValue	Cell.value()	Returns the cell's value.
CellValue	Sheet.value(int row, int col)	Returns the value of one cell: its cached result for a formula cell, BLANK for an empty cell.
CellValue[][]	Range.values()	Reads every cell as a CellValue, row-major: result[r][c] is the cell at (firstRow() + r, firstColumn() + c).

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

Modifier and Type	Method	Description
static CellValue	CellValue.array(CellValue[][] rows)	A row-major matrix value (see CellValue.Array) — the shape of a range argument to a typed user-defined function, or of an array result returned from one.
void	Cell.setValue(CellValue value)	Sets this cell's value and drops any formula.
void	Range.setValues(CellValue[][] values)	Writes every cell from a row-major CellValue[rowCount()][colCount()].

Constructors in io.keikai.axyra.sheets with parameters of type CellValue

Modifier	Constructor	Description
	Array(CellValue[][] rows)	Creates an instance of a Array record class.

Uses of CellValue in io.keikai.axyra.sheets.formula

Methods in io.keikai.axyra.sheets.formula that return CellValue

Modifier and Type	Method	Description
CellValue	TypedUserFunction.apply(CellValue[] args)	Computes the function result.

Methods in io.keikai.axyra.sheets.formula with parameters of type CellValue

Modifier and Type	Method	Description
CellValue	TypedUserFunction.apply(CellValue[] args)	Computes the function result.