SetFormula Method (DefaultSheetDataModel)

In This Topic

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

Syntax

Visual Basic
C#

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

'Usage
 
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim column As Integer
Dim value As String
 
instance.SetFormula(row, column, value)

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
C#

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

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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
GetFormula Method