ReCalcCell Method
Applies To
fpSpread control
Description
Recalculates the formula in an individual cell.
Syntax
BOOL CSpreadSheet::ReCalcCell(long Col, long Row);
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