Spread for ASP.NET 8.0 Product Documentation > Client-Side Scripting Reference > Scripting Members > Methods > GetFormula |
Gets the formula in the cell of the specified row and column.
[JavaScript]
var ret = GetFormula(row,column);
String with the formula in the specified cell or an empty string if no formula is specified
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 (=).
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> |