Spread for ASP.NET 11 Product Documentation
ResetFormula Method
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.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.Web.Spread.Cell mycell;
mycell = FpSpread1.Cells[2,0];
FpSpread1.ActiveSheetView.SetValue(0,0,10);
FpSpread1.ActiveSheetView.SetValue(1,0,10);
mycell.Formula="SUM(A1:A2)";
//mycell.ResetFormula();
Dim mycell As FarPoint.Web.Spread.Cell
mycell = FpSpread1.Cells(2, 0)
FpSpread1.ActiveSheetView.SetValue(0, 0, 10)
FpSpread1.ActiveSheetView.SetValue(1, 0, 10)
mycell.Formula = "SUM(A1:A2)"
'mycell.ResetFormula()
See Also

Reference

Cell Class
Cell Members