Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetExpression Method
Row index of the specified cell
Column index of the specified cell
Formula to place in the specified cell
Example


In This Topic
    SetExpression Method (SheetView)
    In This Topic
    Sets a formula in a specified cell on this sheet.
    Syntax
    'Declaration
     
    Public Sub SetExpression( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal value As Expression _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim value As Expression
     
    instance.SetExpression(row, column, value)
    public void SetExpression( 
       int row,
       int column,
       Expression value
    )

    Parameters

    row
    Row index of the specified cell
    column
    Column index of the specified cell
    value
    Formula to place in the specified cell
    Exceptions
    ExceptionDescription
    Specified row index is out of range; must be between 0 and the total number of rows
    Specified column index is out of range; must be between 0 and the total number of columns
    Example
    FarPoint.CalcEngine.Expression one;
    FarPoint.CalcEngine.Expression two;
    FarPoint.CalcEngine.Expression oneplustwo;
    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);
    FpSpread1.ActiveSheetView.SetExpression(0, 0, oneplustwo);
    FarPoint.CalcEngine.Expression x;
    x = FpSpread1.ActiveSheetView.GetExpression(0, 0);
    string msg = x.ToString();
    Response.Write("alert('" + msg + "')");
    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)
    FpSpread1.ActiveSheetView.SetExpression(0, 0, oneplustwo)
    Dim x As FarPoint.CalcEngine.Expression
    x = FpSpread1.ActiveSheetView.GetExpression(0, 0)
    Dim msg As String = x.ToString()
    Response.Write("alert('" & msg & "')")
    See Also