Spread 8.0 Documentation
FormulaSync Property
Support Options
ActiveX Reference > ActiveX Properties > FormulaSync Property

Glossary Item Box

FormulaSync Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns whether the cell references in formulas are updated when columns or rows are added or deleted or when blocks of cells are moved or swapped.

Syntax

C++

BOOL CSpreadSheet::GetFormulaSync( );
void CSpreadSheet::SetFormulaSync(BOOL value);

Visual Basic

[form.]fpSpread.FormulaSync[ = boolean%]

Remarks

The default value for the FormulaSync property is True, which causes the control to update the cell references in formulas when you insert or delete columns or rows or when you move or swap blocks of cells.

This setting is applied to the entire workbook, including all sheets in the control.

The control does not update cell references in formulas when you use the Sort method to sort blocks of cells in the sheet. The setting of the FormulaSync property does not affect this behavior.

Provide formulas in the control using the Formula property.

Spread Designer

Choose the Book menu, then the Environment menu, select the Environment tab, and then choose the Formula Sync check box in the Book Settings dialog box.

Data Type

Integer (Boolean)

See Also

Automatically Recalculating and Updating Formulas

Formula property

Sort method

DLL Correspondence

SSGetBool (SSB_FORMULASYNC), SSSetBool (SSB_FORMULASYNC) functions

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