Spread 8.0 Documentation
Automatically Recalculating and Updating Formulas
Support Options
User's Guide > Working with the Control > Working with Data > Entering Formulas > Automatically Recalculating and Updating Formulas

Glossary Item Box

Automatically Recalculating and Updating Formulas


To turn off automatic formula calculation and updates

To recalculate an individual cell

Overview

By default, the control recalculates formulas when the contents of dependent cells change. You can turn this recalculation off. You can also recalculate an individual cell.

Also by default, the control updates formulas when you insert or delete columns or rows or when you move or swap blocks of cells. You can turn off these automatic formula updates. However, generally, you probably want the control to update formulas when you insert or delete columns or rows or when you move or swap blocks of cells.

Keep in mind how turning off automatic formula updating might impact the control if the user moves data, adds rows or columns, or performs other actions that affect the location of data.

When automatic formula updating is on, the control updates absolute and relative cell references, as follows:

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