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


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).
    Syntax
    'Declaration
     
    Public Sub RecalculateAll() 
    'Usage
     
    Dim instance As SheetView
     
    instance.RecalculateAll()
    public void RecalculateAll()
    Example
    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);
        fpSpread1.ActiveSheet.RecalculateAll();
    }
    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)
        FpSpread1.ActiveSheet.RecalculateAll()
    End If
    See Also