Spread for ASP.NET 7.0 Product Documentation
ResetFormula Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Cell Class : ResetFormula Method


Glossary Item Box

Resets the formula for the cell to empty.

Syntax

Visual Basic (Declaration) 
Public Sub ResetFormula() 
Visual Basic (Usage)Copy Code
Dim instance As Cell
 
instance.ResetFormula()
C# 
public void ResetFormula()

Example

This example uses the ResetFormula method.
C#Copy Code
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();
VB.NETCopy Code
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()

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.