Iteration Property

Gets or sets the property which specifies whether iteration will be used when a workbook set is calculated.

[Visual Basic]
Overridable Property Iteration As Boolean

[C#]
virtual bool Iteration {get; set;}

[C++]
__property virtual bool get_Iteration();
__property virtual void set_Iteration( 
   bool value
);

[C++/CLI]
virtual property bool Iteration {
   bool get();
   void set (bool value);
}

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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IWorkbookSet Interface  | IWorkbookSet Members  | MaxChange Property  | MaxIterations Property

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.