AutoCalc Property
Applies To
fpSpread control
Description
Sets or returns whether the control recalculates each formula when the contents of dependent cells change.
Syntax
BOOL CSpreadSheet::GetAutoCalc( );
void CSpreadSheet::SetAutoCalc(BOOL value);
[form.]fpSpread.AutoCalc[ = boolean%]
Remarks
The default value for the AutoCalc property is True.
This setting is applied to the entire workbook, including all sheets in the control.
When the AutoCalc property is set to True, the control automatically recalculates each formula when the contents of cells referenced by the formula change. When the AutoCalc property is set to False, cells with formulas are not updated when data changes.
If you have set the AutoCalc property to False, you can use the ReCalc method to force a recalculation of all formulas. You can use the ReCalcCell method to recalculate the formula in an individual cell.
Define formulas using the Formula property. If you want the control to update formulas when columns or rows are moved in the sheet, specify that using the FormulaSync property.
Spread Designer
Choose the Book menu, then the Environment menu, select the Environment tab, and then choose the Calculate Formulas check box in the Book Settings dialog box.
Data Type
Integer (Boolean)
See Also
Automatically Recalculating and Updating Formulas
Formula, FormulaSync properties
ReCalc, ReCalcCell methods
DLL Correspondence
SSGetBool (SSB_AUTOCALC), SSSetBool (SSB_AUTOCALC) functions