Spread for ASP.NET 7.0 Product Documentation
LoadFormulas Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : LoadFormulas Method


recalculate
Whether to recalculate all the formulas in cells on the sheet that have changed

Glossary Item Box

Loads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.

Syntax

Visual Basic (Declaration) 
Public Sub LoadFormulas( _
   ByVal recalculate As Boolean _
) 
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim recalculate As Boolean
 
instance.LoadFormulas(recalculate)
C# 
public void LoadFormulas( 
   bool recalculate
)

Parameters

recalculate
Whether to recalculate all the formulas in cells on the sheet that have changed

Example

This example uses the LoadFormulas method.
C#Copy Code
FpSpread1.Sheets[0].LoadFormulas(true);
Visual BasicCopy Code
FpSpread1.Sheets(0).LoadFormulas(True)

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Formulas

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.