SpreadsheetGear The Performance Spreadsheet Component Company 
Iteration Property
See Also 
SpreadsheetGear Namespace > IWorkbookSet Interface : Iteration Property
Gets or sets the property which specifies whether iteration will be used when a workbook set is calculated.

Syntax

C# 
virtual bool Iteration {get; set;}

Remarks

When Iteration is true, formulas are calculated until the number of iterations equals MaxIterations or until the maximum change in any calculated cell is less than MaxChange.

Iteration is false by default

MaxChange is set to 0.001 by default.

MaxIterations is set to 100 by default.

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also