MaxChange Property

Gets or sets the maximum change allowed if iteration is to stop.

[Visual Basic]
Overridable Property MaxChange As Double

[C#]
virtual double MaxChange {get; set;}

[C++]
__property virtual double get_MaxChange();
__property virtual void set_MaxChange( 
   double value
);

[C++/CLI]
virtual property double MaxChange {
   double get();
   void set (double 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  | Iteration 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.