Spread for ASP.NET 11 Product Documentation
SetFormula Method (DefaultSheetDataModel)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : SetFormula Method
Row index of the cell
Column index of the cell
Formula to be set, as a string
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
'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
ExceptionDescription
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.
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());
}
See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
GetFormula Method