ResetFormula Method

Resets the formula for the cell to empty.

Syntax

Visual Basic
C#

'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();

Visual Basic

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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

Cell Class
Cell Members