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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

Cell Class
Cell Members