SpreadsheetGear The Performance Spreadsheet Component Company 
CalculateFullRebuild Method
See Also 
SpreadsheetGear Namespace > IWorkbookSet Interface : CalculateFullRebuild Method
Optimizes the internal representation of formulas and data in this workbook set and calculates all of the formulas.

Syntax

C# 
virtual 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 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