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 98, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0. SpreadsheetGear for .NET 2006 requires the Microsoft .NET Framework 2.0.

See Also