Spread ASP.NET 6.0 Product Documentation
GetFormula
Send Feedback
Spread ASP.NET 6.0 Product Documentation > Client-Side Scripting Reference > Scripting Members > Methods > GetFormula

Glossary Item Box

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

© 2002-2012 GrapeCity, Inc. All Rights Reserved.