Sets the formula, as a string value, for the cell of the specified row and column. If you pass null, it will clear the expression from that cell.

Syntax

Visual Basic (Declaration)
Public Sub SetFormula( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal value As String _ )

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetDataModel Dim row As Integer Dim column As Integer Dim value As String instance.SetFormula(row, column, value)

C#
public void SetFormula( int row, int column, string value )

Parameters

row: Row index of the cell
column: Column index of the cell
value: Formula to be set, as a string

Exceptions

Exception	Description
ParseException	Specified value is not a valid formula

Remarks

For a list of the operators and functions you can use in formulas, refer to the Spread for .NET Formula Reference.

The Spread component can use absolute or relative cell references. You define the cell reference style for the spreadsheet The formula cannot contain both absolute and relative row or column references.

Example

This example creates a new DefaultSheetDataModel, sets its number of rows and columns in the constructor and attaches it to the DataModel of the active sheet. Data is added to the first three columns along with formulas to sum the values.

Visual Basic	Copy Code
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load If(Me.IsPostBack)Then Return Dim dm As New FarPoint.Web.Spread.Model.DefaultSheetDataModel(8,8) FpSpread1.ActiveSheetView.DataModel=dm Dim i As Integer For i=0 To 3 FpSpread1.ActiveSheetView.SetValue(i,0,i) FpSpread1.ActiveSheetView.SetValue(i,1,i) FpSpread1.ActiveSheetView.SetValue(i,2,i) Next dm.SetFormula(5,0,"SUM(A3:A4)") dm.SetFormula(5,1,"SUM(B1:B2)") dm.SetFormula(5,2,"SUM(C1:C3)") ListBox1.Items.Add(dm.GetFormula(5,0).ToString()) ListBox1.Items.Add(dm.MaximumIterations.ToString()) ListBox1.Items.Add(dm.ReferenceStyle.ToString()) End Sub

Visual Basic

Copy Code

Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load

If(Me.IsPostBack)Then Return

Dim dm As New FarPoint.Web.Spread.Model.DefaultSheetDataModel(8,8)
FpSpread1.ActiveSheetView.DataModel=dm

Dim i As Integer
For i=0 To 3
FpSpread1.ActiveSheetView.SetValue(i,0,i)
FpSpread1.ActiveSheetView.SetValue(i,1,i)
FpSpread1.ActiveSheetView.SetValue(i,2,i)
Next
dm.SetFormula(5,0,"SUM(A3:A4)")
dm.SetFormula(5,1,"SUM(B1:B2)")
dm.SetFormula(5,2,"SUM(C1:C3)")

ListBox1.Items.Add(dm.GetFormula(5,0).ToString())
ListBox1.Items.Add(dm.MaximumIterations.ToString())
ListBox1.Items.Add(dm.ReferenceStyle.ToString())

End Sub

C#	Copy Code
private void Page_Load(object sender,System.EventArgs e) { if(this.IsPostBack)return; FarPoint.Web.Spread.Model.DefaultSheetDataModel dm=new FarPoint.Web.Spread.Model.DefaultSheetDataModel(10,10); FpSpread1.ActiveSheetView.DataModel=dm; int i; for(i=0;i<=3;i++) { FpSpread1.ActiveSheetView.SetValue(i,0,i); FpSpread1.ActiveSheetView.SetValue(i,1,i); FpSpread1.ActiveSheetView.SetValue(i,2,i); } dm.SetFormula(5,0,"SUM(A3:A4)"); dm.SetFormula(5,1,"SUM(B2:B4)"); dm.SetFormula(5,2,"SUM(C1:C3)"); ListBox1.Items.Add(dm.GetFormula(5,0).ToString()); ListBox1.Items.Add(dm.MaximumIterations.ToString()); ListBox1.Items.Add(dm.ReferenceStyle.ToString()); }

Copy Code

private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;

FarPoint.Web.Spread.Model.DefaultSheetDataModel dm=new FarPoint.Web.Spread.Model.DefaultSheetDataModel(10,10);
FpSpread1.ActiveSheetView.DataModel=dm;

int i;
for(i=0;i<=3;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,0,i);
FpSpread1.ActiveSheetView.SetValue(i,1,i);
FpSpread1.ActiveSheetView.SetValue(i,2,i);
}
dm.SetFormula(5,0,"SUM(A3:A4)");
dm.SetFormula(5,1,"SUM(B2:B4)");
dm.SetFormula(5,2,"SUM(C1:C3)");

ListBox1.Items.Add(dm.GetFormula(5,0).ToString());
ListBox1.Items.Add(dm.MaximumIterations.ToString());
ListBox1.Items.Add(dm.ReferenceStyle.ToString());
}

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

Spread for ASP.NET 7.0 Product Documentation
SetFormula Method
See Also Example Support Options