SSpread.ArrowAutoCalcsExitEditMode Property
Sets whether to automatically recalculate each formula in the related cell each time a value in the cell’s been entered or changed.
Specify $TRUE for recalculation, $FALSE otherwise. The initial value is $TRUE.
The formula in the cell is set in the Formula property.
If $FALSE is set, the formula will not be recalculated automatically and will be recalculated by the ReCalc method. Use the ReCalcCell method to recalculate the formula for a particular cell.
Automatically update cell references (such as A1) in formulas by adding or removing columns or rows is set in the FormulaSync property.
Related Items
Formula, FormulaSync property
ReCalc, ReCalcCell method