Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetExpression Method
Row index of the cell
Column index of the cell
Example


In This Topic
    GetExpression Method (SheetView)
    In This Topic
    Gets the formula of the specified cell on this sheet.
    Syntax
    'Declaration
     
    Public Function GetExpression( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As Expression
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim value As Expression
     
    value = instance.GetExpression(row, column)
    public Expression GetExpression( 
       int row,
       int column
    )

    Parameters

    row
    Row index of the cell
    column
    Column index of the 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
    This example returns the set expression for the specified cell.This example returns the set expression for the specified cell.
    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