Spread ASP.NET 16
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
Example


In This Topic
    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
    '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