Spread for ASP.NET 13 Product Documentation
Spread for ASP.NET 13 Product Documentation / Client-Side Scripting Reference / Scripting Members / Methods / GetFormula
In This Topic
    GetFormula
    In This Topic

    Gets the formula in the cell of the specified row and column.

    Syntax

    [JavaScript]

    var ret = GetFormula(row,column);

    Parameters

    row
    Integer, row index of cell
    column
    Integer, column index of cell

    Return Type

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

    Remarks

    This method returns a formula as a string. Both row and column indexes must be integer values and must be valid. For a list of the operators and functions that appear in formulas, refer to the Formula Reference. The formula starts with an equals sign (=).

    Example

    This is a sample that contains the method. On the client side, the script that contains the method would look like this:

    JavaScript
    Copy Code
    <script type="text/javascript">
       function getEquation() {
           var eqnt = FpSpread1.GetFormula(FpSpread1.ActiveRow,FpSpread1.ActiveCol);
           alert("Equation is " + eqnt);
       }
    </script>
    
    See Also