Property Getters/Setters Summary | ||
---|---|---|
function | getCalculatedValue() | |
Gets the newly calculated value of the cell.
Should be used only in |
||
function | getOriginalValue() | |
Gets the old value of the calculated cell.
Should be used only in |
||
function | getValueChanged() | |
Whether the cell's value has been changed after the calculation.
Should be used only in |
Method Summary | ||
---|---|---|
function | afterCalculate(sheetIndex, rowIndex, colIndex) | |
Implement this method to do business after one cell has been calculated. | ||
function | beforeCalculate(sheetIndex, rowIndex, colIndex) | |
Implement this method to do business before calculating one cell. | ||
function | onCircular(circularCellsData) | |
Implement this method to do business when calculating one cell and circular references being encountered |
Property Getters/Setters Detail |
---|
getOriginalValue : Object | |
function getOriginalValue() |
getValueChanged : boolean | |
function getValueChanged() |
getCalculatedValue : Object | |
function getCalculatedValue() |
Method Detail |
---|
beforeCalculate | |
function beforeCalculate(sheetIndex, rowIndex, colIndex) |
sheetIndex: Number
- Index of the sheet that the cell belongs to.rowIndex: Number
- Row index of the cellcolIndex: Number
- Column index of the cellafterCalculate | |
function afterCalculate(sheetIndex, rowIndex, colIndex) |
sheetIndex: Number
- Index of the sheet that the cell belongs to.rowIndex: Number
- Row index of the cellcolIndex: Number
- Column index of the cellonCircular | |
function onCircular(circularCellsData) |
circularCellsData: Iterator
- IEnumerator to enumerate cells(represented by CalculationCell object) in the circular chain