Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Cell Class / ResetFormula Method
Example


In This Topic
    ResetFormula Method
    In This Topic
    Resets the formula for the cell to empty.
    Syntax
    'Declaration
     
    Public Sub ResetFormula() 
    'Usage
     
    Dim instance As Cell
     
    instance.ResetFormula()
    public void ResetFormula()
    Example
    This example uses the ResetFormula method.
    FarPoint.Win.Spread.Cell acell, mycell, urcell;
    acell = fpSpread1.ActiveSheet.Cells[0, 0];
    mycell = fpSpread1.ActiveSheet.Cells[2, 2];
    urcell = fpSpread1.ActiveSheet.Cells[2, 3];
    mycell.Value = 10;
    urcell.Value = 10;
    acell.Formula = "SUM(" + mycell.ToString() + "," + urcell.ToString() + ")";
    acell.ResetFormula();
    Dim acell, mycell, urcell As FarPoint.Win.Spread.Cell
    acell = FpSpread1.ActiveSheet.Cells(0, 0)
    mycell = FpSpread1.ActiveSheet.Cells(2, 2)
    urcell = FpSpread1.ActiveSheet.Cells(2, 3)
    mycell.Value = 10
    urcell.Value = 10
    acell.Formula = "SUM(" + mycell.ToString() + "," + urcell.ToString() + ")"
    acell.ResetFormula()
    See Also