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


In This Topic
    GetExpression Method (IExpressionSupport)
    In This Topic
    Gets the formula, as an expression, in the cell at the specified row and column.
    Syntax
    'Declaration
     
    Function GetExpression( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As Expression
    'Usage
     
    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
    )

    Parameters

    row
    Row index
    column
    Column index

    Return Value

    Expression containing the formula
    Example
    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