Spread 8.0 Documentation
ReCalc Method
Support Options
ActiveX Reference > ActiveX Methods > ReCalc Method

Glossary Item Box

ReCalc Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Recalculates the formulas in the entire control.

Syntax

C++

void CSpreadSheet::ReCalc( );

Visual Basic

fpSpread1.ReCalc( )

Remarks

Use the ReCalc method if you have set the AutoCalc property to False and want to recalculate the formulas in the control. 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 control, specify that using the FormulaSync property.

Return Type

None

See Also

Automatically Recalculating and Updating Formulas

AutoCalc, Formula, FormulaSync properties

ReCalcCell method

DLL Correspondence

SSReCalc function

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.