Spread for ASP.NET 10 Product Documentation
RecalculateAll Method (SheetView)
Example 


Evaluates all the formulas in the sheet (including those that have not changed since the last calculation cycle).
Syntax
'Declaration
 
Public Sub RecalculateAll() 
'Usage
 
Dim instance As SheetView
 
instance.RecalculateAll()
public void RecalculateAll()
Example
This example evaluates all the formulas in the sheet since the last calculation cycle.
private void PageLoad(object sender, System.EventArgs e)
{
FarPoint.Web.Spread.SheetView sv;
      sv = FpSpread1.ActiveSheetView;
      sv.Cells[0, 0, 2, 3].CellType = New FarPoint.Web.Spread.IntegerCellType();
      sv.SetValue(0, 0, 20)
      sv.SetValue(1, 0, 10)
      sv.SetFormula(2, 0, "Sum(A1,A2)");
      sv.AutoCalculation = false;
}

private void Button1Click(object sender, System.EventArgs e)
{
      FarPoint.Web.Spread.SheetView sv;
      sv = FpSpread1.ActiveSheetView;
      sv.Cells[1, 0].Value = 100;
      sv.RecalculateAll();
}
Private Sub PageLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
      Dim sv As FarPoint.Web.Spread.SheetView
      sv = FpSpread1.ActiveSheetView
      sv.Cells(0, 0, 2, 3).CellType = New FarPoint.Web.Spread.IntegerCellType
      sv.SetValue(0, 0, 20)
      sv.SetValue(1, 0, 10)
      sv.SetFormula(2, 0, "Sum(A1,A2)")
      sv.AutoCalculation = False
End Sub

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
      Dim sv As FarPoint.Web.Spread.SheetView
      sv = FpSpread1.ActiveSheetView
      sv.Cells(1, 0).Value = 100
      sv.RecalculateAll()
End Sub
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetView Class
SheetView Members
Recalculate Method

User-Task Documentation

Recalculating Formulas

 

 


Copyright © GrapeCity, inc. All rights reserved.