Spread Windows Forms 7.0 Product Documentation
Calculations Tab
Support Options

Glossary Item Box

The Calculations tab of the Sheet Settings dialog provides the settings that apply to the entire sheet and correspond to the SheetView properties that relate to recalculating the cells that have formulas. Refer to the properties in the SheetView class.

Spread Designer Sheet Settings Calculations Tab

This tab provides the following items:

Sheet Settings

Description and Reference

Auto Recalculation

Set whether the control recalculates each formula when the contents of dependent cells change for a sheet.

Iteration

Set whether circular references are evaluated on this sheet.

Maximum Change

Set the maximum change before recalculation is performed.

Maximum Iterations

Set the maximum amount of change below which iterations stop when circular references are evaluated on this sheet.

Reference Style

Set the style for cell and range references in formulas in cells on this sheet.

For more information about formulas and calculations, refer to the Formula Reference.

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