CalculationCell
Contents
[
Hide
]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
Method | Description |
---|---|
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
getWorksheet()
Gets the Worksheet object where the cell is in.
getWorksheet() : Worksheet;
Returns
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
setCalculatedValue(object)
Sets the calculated value for the cell.
setCalculatedValue(v: object) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
v | object |
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;