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

In This Topic
    GetExpression Method (SheetView)
    In This Topic
    Gets the formula of the specified cell on this sheet.
    Public Function GetExpression( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As Expression
    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


    Row index of the cell
    Column index of the cell
    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
    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