Spread for ASP.NET 12 Product Documentation
GetFormula
Spread for ASP.NET 12 Product Documentation > Client-Side Scripting Reference > Scripting Members > Methods > GetFormula

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