Link Search Menu Expand Document

SSpread.ReCalc Method

Explanation Recalculate the formula for the entire spreadsheet.

Use this method to recalculate all formulas in your spreadsheet when the AutoCalc property is set to $FALSE.

Use the ReCalcCell method to recalculate the formulas in individual cells.
Call format ReCalc()
Return value None
Arguments None
Exception EXT-28 An error occurred in the ReCalc method
Example of use
    AutoCalc = $FALSE;
    Function OnEditModeOff(e) {
        if (e.ChangeMade) {
            ReCalc();
        }
    }
    
Related item AutoCalc, Formula properties
ReCalcCell method