Spread Windows Forms 12.0 Product Documentation
Calculations Tab

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.