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: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2008 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.