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:

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

Copyright © GrapeCity, inc. All rights reserved.