Spread Windows Forms 7.0 Product Documentation
RecalculateAll Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : RecalculateAll Method


Glossary Item Box

Evaluates all the formulas in the entire sheet (including those that have not changed since the last calculation cycle).

Syntax

Visual Basic (Declaration) 
Public Sub RecalculateAll() 
Visual Basic (Usage)Copy Code
Dim instance As DefaultSheetDataModel
 
instance.RecalculateAll()
C# 
public void RecalculateAll()

Example

Visual BasicCopy Code
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10)
Dim dlg As DialogResult
FpSpread1.ActiveSheet.Models.Data = dataModel
dataModel.SetValue(0, 0, 10)
dataModel.SetValue(1, 0, 20)
dataModel.SetFormula(1, 1, "3*SUM(A1, A2)")
dataModel.SetValue(4, 0, 100)
dataModel.SetValue(5, 0, 200)
dataModel.SetFormula(2, 2, "3*SUM(A5, A6)")
dlg = MessageBox.Show("Do you want to recalculate?", "RecalculateAll", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
dataModel.SetValue(0, 0, 50)
dataModel.RecalculateAll()
End If
C#Copy Code
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8);
DialogResult dlg;
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.SetValue(0, 0, 10);
dataModel.SetValue(1, 0, 20);
dataModel.SetFormula(1, 1, "3*SUM(A1, A2)");
dataModel.SetValue(4, 0, 100);
dataModel.SetValue(5, 0, 200);
dataModel.SetFormula(2, 2, "3*SUM(A5, A6)");
dlg = MessageBox.Show("Do you want to recalculate?", "RecalculateAll", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
dataModel.SetValue(0, 0, 50);
dataModel.RecalculateAll();
}

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

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