Interface SheetCellsIf

The link between the body model and the cell formulas of a table (TableOptionsIf.cellFormulas): the model asks it for the value of every text input – an =… cell of a formula column gives its result. Set by the table.

Since

1.1.99

Hierarchy

SheetCellsIf

Implemented by

TableSheet

Index

Methods

isFormulaColumnIndex isFormulaProperty valueAt valueOfProperty

Methods

isFormulaColumnIndex

isFormulaColumnIndex(columnIndex): boolean
True if the column may hold formulas.
Parameters
- columnIndex: number
Returns boolean
- Defined in src/lib/table/sheet/sheet-cells.if.ts:16

isFormulaProperty

isFormulaProperty(property): boolean
True if the column of this property may hold formulas.
Parameters
- property: string
Returns boolean
- Defined in src/lib/table/sheet/sheet-cells.if.ts:14

valueAt

valueAt(row, columnIndex, input): unknown
The value of a cell of an array row (AreaModelArrayOfArrays): the result for a formula, otherwise input.
Parameters
- row: unknown
- columnIndex: number
- input: string
Returns unknown
- Defined in src/lib/table/sheet/sheet-cells.if.ts:10

valueOfProperty

valueOfProperty(row, property, input): unknown
The value of a property of a row object: the result for a formula, otherwise input.
Parameters
- row: unknown
- property: string
- input: string
Returns unknown
- Defined in src/lib/table/sheet/sheet-cells.if.ts:12