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.
Properties
| Property | Type | Description |
|---|---|---|
| workbook | Workbook | Readonly. Gets the Workbook object. |
| worksheet | Worksheet | Readonly. Gets the Worksheet object where the cell is in. |
| cellRow | number | Readonly. Gets the row index of the cell. |
| cellColumn | number | Readonly. Gets the column index of the cell. |
| cell | Cell | Readonly. Gets the Cell object which is being calculated. |
Methods
| Method | Description |
|---|---|
| setCalculatedValue(VObject) | Sets the calculated value for the cell. |
workbook
Readonly. Gets the Workbook object.
workbook : Workbook;
worksheet
Readonly. Gets the Worksheet object where the cell is in.
worksheet : Worksheet;
cellRow
Readonly. Gets the row index of the cell.
cellRow : number;
cellColumn
Readonly. Gets the column index of the cell.
cellColumn : number;
cell
Readonly. Gets the Cell object which is being calculated.
cell : Cell;
setCalculatedValue(VObject)
Sets the calculated value for the cell.
setCalculatedValue(v: VObject) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| v | VObject |
Remarks
User can set the calculated result by this method to ignore the automatic calculation for the cell.