Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetFormula Method
Row index
Column index

In This Topic
    GetFormula Method (SheetView)
    In This Topic
    Gets the formula in the cell at the specified row and column.
    Public Overridable Function GetFormula( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As String
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim value As String
    value = instance.GetFormula(row, column)
    public virtual string GetFormula( 
       int row,
       int column


    Row index
    Column index

    Return Value

    String containing the formula in the specified cell or an empty string if no formula is specified

    For a list of the operators and functions you can use in formulas, refer to the Spread for .NET Formula Reference.

    The Spread component can use absolute or relative cell references. You define the cell reference style for the spreadsheet by using the ReferenceStyle property. The formula cannot contain both absolute and relative row or column references.

    This example gets the formula that is set for the specified cell.
    FarPoint.Web.Spread.SheetView sv;
    string s;
    sv = FpSpread1.ActiveSheetView;
    sv.SetFormula(0, 0, "4*4");
    s = sv.GetFormula(0, 0);
    Response.Write("The formula for the cell is a " + s);
    Dim sv As FarPoint.Web.Spread.SheetView
    Dim s As String
    sv = FpSpread1.ActiveSheetView
    sv.SetFormula(0, 0, "4*4")
    s = sv.GetFormula(0, 0)
    Response.Write("The formula for the cell is a " & s)
    See Also