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 language=javascript> function getEquation() { var eqnt = FpSpread1.GetFormula(FpSpread1.ActiveRow,FpSpread1.ActiveCol); alert("Equation is " + eqnt); } </SCRIPT> |
|
See Also
SetFormula | Scripting Members