SSpread.FormulaSync Property

Sets whether cell references (such as A1) in formulas are automatically updated when rows or columns are added, deleted, or moved.

Specify $TRUE to automatically update cell references in formulas, otherwise $FALSE. The initial value is $TRUE.

Set $TRUE to automatically update cell references in formulas when cell positions change due to additions, deletions, cell block movements, etc. of rows and columns.

Set $FALSE, the formula will not be updated when the cell position changes.

The cell formula is set with the Formula property.

The automatic recalculation of formulas is set in the AutoCalc property.

Related Items
AutoCalc, Formula property

---