Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / SetExpression Method
Row index of the cell
Column index of the cell
Formula to be set as an expression
Example


In This Topic
    SetExpression Method (DefaultSheetDataModel)
    In This Topic
    Sets the formula, as an expression value, for the cell of the specified row and column.
    Syntax
    'Declaration
     
    Public Overridable Sub SetExpression( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal value As Expression _
    ) 
    'Usage
     
    Dim instance As DefaultSheetDataModel
    Dim row As Integer
    Dim column As Integer
    Dim value As Expression
     
    instance.SetExpression(row, column, value)
    public virtual void SetExpression( 
       int row,
       int column,
       Expression value
    )

    Parameters

    row
    Row index of the cell
    column
    Column index of the cell
    value
    Formula to be set as an expression
    Example
    This example returns the formula, as an expression value, for the cell of the specified row and column.
    FarPoint.CalcEngine.Expression one; 
    FarPoint.CalcEngine.Expression two; 
    FarPoint.CalcEngine.Expression oneplustwo; 
    FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel; 
    one = new FarPoint.CalcEngine.DoubleExpression(100); 
    two = new FarPoint.CalcEngine.DoubleExpression(20); 
    oneplustwo = new FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two);
    
    dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
    dataModel.SetExpression(0, 0, oneplustwo);
     
    FarPoint.CalcEngine.Expression x; 
    x = dataModel.GetExpression(0, 0); 
    Response.Write(x.ToString());
    
    Dim dfltdatamodel As FarPoint.Web.Spread.Model.DefaultSheetDataModel
    Dim one As FarPoint.CalcEngine.Expression
    Dim two As FarPoint.CalcEngine.Expression
    Dim oneplustwo As FarPoint.CalcEngine.Expression
    one = New FarPoint.CalcEngine.DoubleExpression(100.0)
    two = New FarPoint.CalcEngine.DoubleExpression(20.0)
    oneplustwo = New FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two)
    
    dfltdatamodel = FpSpread1.ActiveSheetView.DataModel
    dfltdatamodel.SetExpression(0, 0, oneplustwo)
    
    Dim x As FarPoint.CalcEngine.Expression
    x = dfltdatamodel.GetExpression(0, 0)
    Response.Write(x.ToString()) 
    See Also