SSReCalcCell Function

Applies To

fpSpread DLL control

Description

Recalculates the formula in an individual cell.

Syntax

BOOL SSReCalcCell(HWND hWnd, SS_COORD lCol, SS_COORD lRow);

C++

BOOL TSpread::ReCalcCell(SS_COORD lCol, SS_COORD lRow);

Parameters

The following parameters are available:

Parameter	Description
hWnd	Window handle of the fpSpread control
lCol	Column number of cell
lRow	Row number of cell

Remarks

This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.

Call the SSReCalcCell function if you have called the SSSetBool function and set the SSB_AUTOCALC boolean to FALSE and want to recalculate the formula in an individual cell. If you want to recalculate every formula in the control, call the SSReCalc function.

Define formulas by calling the SSSetFormula function. If you want the control to update formulas when columns or rows are moved, specify that by calling the SSSetBool function and setting the SSB_FORMULASYNC boolean to True.

Return Value

TRUE if the recalculation completes successfully; FALSE otherwise.

ActiveX Correspondence

ReCalcCell method