Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / IExpressionSupport Interface / GetExpression Method
Row index
Column index

In This Topic
    GetExpression Method (IExpressionSupport)
    In This Topic
    Gets the formula, as an expression, in the cell at the specified row and column.
    Function GetExpression( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As Expression
    Dim instance As IExpressionSupport
    Dim row As Integer
    Dim column As Integer
    Dim value As Expression
    value = instance.GetExpression(row, column)
    Expression GetExpression( 
       int row,
       int column


    Row index
    Column index

    Return Value

    Expression containing the formula
    FarPoint.Web.Spread.Model.IExpressionSupport ems; 
    FarPoint.CalcEngine.Expression one = new FarPoint.CalcEngine.DoubleExpression(1.0); 
    FarPoint.CalcEngine.Expression two = new FarPoint.CalcEngine.DoubleExpression(2.0); 
    FarPoint.CalcEngine.Expression oneplustwo = new FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two); 
    ems = (FarPoint.Web.Spread.Model.IExpressionSupport)FpSpread1.ActiveSheetView.DataModel; 
    ems.SetExpression(0, 0, oneplustwo); 
    Response.Write("The type of expression is " + ems.GetExpression(0, 0).ToString());
    Dim ems As FarPoint.Web.Spread.Model.IExpressionSupport
    Dim one As FarPoint.CalcEngine.Expression
    Dim two As FarPoint.CalcEngine.Expression
    Dim oneplustwo As FarPoint.CalcEngine.Expression
    one = New FarPoint.CalcEngine.DoubleExpression(1.0)
    two = New FarPoint.CalcEngine.DoubleExpression(2.0)
    oneplustwo = New FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two)
    ems = FpSpread1.ActiveSheetView.DataModel
    ems.SetExpression(0, 0, oneplustwo)
    Response.Write("The type of expression is " & ems.GetExpression(0, 0).ToString())
    See Also