Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / RecalculateAll Method

In This Topic
    RecalculateAll Method (SheetView)
    In This Topic
    Evaluates all the formulas in cells on the sheet (including those that have not changed since the last calculation cycle).
    Public Sub RecalculateAll() 
    Dim instance As SheetView
    public void RecalculateAll()
    This example recalculates the formulas.
    DialogResult dlg;
    fpSpread1.ActiveSheet.SetValue(0, 0, 20);
    fpSpread1.ActiveSheet.SetValue(0, 1, 10);
    fpSpread1.ActiveSheet.SetFormula(3, 0, "SUM(A1,B1)");
    fpSpread1.ActiveSheet.SetFormula(4, 0, "A1*B1");
    dlg = MessageBox.Show("Do you want to recalculate the formulas?", "RecalculateAll", MessageBoxButtons.YesNo);
    if (dlg == DialogResult.Yes)
        fpSpread1.ActiveSheet.SetValue(0, 1, 100);
    Dim dlg As DialogResult
    FpSpread1.ActiveSheet.SetValue(0, 0, 20)
    FpSpread1.ActiveSheet.SetValue(0, 1, 10)
    FpSpread1.ActiveSheet.SetFormula(3, 0, "SUM(A1,B1)")
    FpSpread1.ActiveSheet.SetFormula(4, 0, "A1*B1")
    dlg = MessageBox.Show("Do you want to recalculate the formulas?", "RecalculateAll", MessageBoxButtons.YesNo)
    If dlg = DialogResult.Yes Then
        FpSpread1.ActiveSheet.SetValue(0, 1, 100)
    End If
    See Also