Spread 8.0 Documentation
SSReCalcCell Function
Support Options
DLL Reference > DLL Functions > SSReCalcCell Function

Glossary Item Box

SSReCalcCell Function


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Recalculates the formula in an individual cell.

Syntax

C

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.

See Also

Automatically Recalculating and Updating Formulas

SSReCalc, SSSetBool, SSSetFormula, SSSetSheet functions

ActiveX Correspondence

ReCalcCell method

Copyright © GrapeCity, inc. All rights reserved.