Link Search Menu Expand Document
KLCV DEV MANUAL

SSpread.ReCalcCell Method

Explanation Recalculate the formula in each cell.

Use this method to manually recalculate individual cells when the AutoCalc property is set to $FALSE. To recalculate all the formulas in the spreadsheet, use the ReCalc method.
Call format ReCalcCell(col, row)
Return value None
Arguments col Cell column number
row Cell row number
Exception EXT-28 An error occurred in the ReCalcCell method
Example of use 
    AutoCalc = $FALSE;
    Col = 2;
    Row = 1;
    Formula = "A1";
    Function OnEditModeOff(e) {
        if (e.ChangeMade && e.Col == 1 && e.Row == 1) {
            ReCalcCell(2, 1);
        }
    }
Related item AutoCalc, Formula properties
ReCalc method