Syntax
| Visual Basic (Declaration) | |
|---|---|
Sub CalculateFullRebuild() | |
| C# | |
|---|---|
void CalculateFullRebuild() | |
Remarks
CalculateFullRebuild is a very expensive operation. Typically, it will prove beneficial when a set of one or more workbooks are loaded and/or created, populated with values and formulas, optimized with CalculateFullRebuild, and then modified and calculated many times.
Calling System.GC.Collect after rebuilding and before the next calculation is triggered typically results in faster calculation. However, calling System.GC.Collect in a server environment is rarely a good idea.
Requirements
Platforms: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.