Spread Windows Forms 10.0 Product Documentation
ResetFormula Method
Example 


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()
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

Cell Class
Cell Members

 

 


Copyright © GrapeCity, inc. All rights reserved.