CalculationCell

CalculationCell class

Represents the calculation relevant data about one cell which is being calculated.

class CalculationCell;

Remarks

All objects provided by this class are for “read” purpose only. User should not change any data in the Workbook during the formula calculation process, Otherwise unexpected result or Exception may be caused.

Methods

MethodDescription
getWorkbook()Gets the Workbook object.
getWorksheet()Gets the Worksheet object where the cell is in.
getCellRow()Gets the row index of the cell.
getCellColumn()Gets the column index of the cell.
getCell()Gets the Cell object which is being calculated.
setCalculatedValue(object)Sets the calculated value for the cell.
isNull()Checks whether the implementation object is null.

getWorkbook()

Gets the Workbook object.

getWorkbook() : Workbook;

Returns

Workbook

getWorksheet()

Gets the Worksheet object where the cell is in.

getWorksheet() : Worksheet;

Returns

Worksheet

getCellRow()

Gets the row index of the cell.

getCellRow() : number;

getCellColumn()

Gets the column index of the cell.

getCellColumn() : number;

getCell()

Gets the Cell object which is being calculated.

getCell() : Cell;

Returns

Cell

setCalculatedValue(object)

Sets the calculated value for the cell.

setCalculatedValue(v: object) : void;

Parameters:

ParameterTypeDescription
vobject

Remarks

User can set the calculated result by this method to ignore the automatic calculation for the cell.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;