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

Glossary Item Box

ReCalcCell Method


See Also    DLL

Applies To

fpSpread control

Description

Recalculates the formula in an individual cell.

Syntax

C++

BOOL CSpreadSheet::ReCalcCell(long Col, long Row);

Visual Basic

fpSpread.ReCalcCell(ByVal Col As Long, ByVal Row As Long) As Boolean

Parameters

The following parameters are available:

Parameter Description
Col Column number of cell
Row Row number of cell

Remarks

Use the ReCalcCell method if you have set the AutoCalc property to False and want to recalculate the formula in an individual cell. If you want to recalculate every formula in the control, use the ReCalc method.

This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.

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.

Return Type

True if the recalculation completes successfully; otherwise, False.

See Also

Automatically Recalculating and Updating Formulas

AutoCalc, Formula, FormulaSync, Sheet properties

ReCalc method

DLL Correspondence

SSReCalcCell function

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