Spread Windows Forms 11.0 Product Documentation
ResetFormula Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Cell Class : ResetFormula Method
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

Reference

Cell Class
Cell Members