Gets the value of a cell in the specified row and column.
Syntax
[JavaScript]
var ret = FpSpread1.GetValue(row,column);
Parameters
- row
- Integer, row index
- column
- Integer, column index
Return Type
String, the value of the cell
Remarks
This method returns the value as it is currently displayed in the cell. The row and column indexes must be valid.
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 doCalc() { var rc = FpSpread1.GetRowCount(); var total = 0; for (var i=0; i<rc-1; i++) { var value = parseFloat(FpSpread1.GetValue( i, 0 )); total += value; } if (!isNaN(total)) FpSpread1.SetValue(n-1, 0, total, true); } </SCRIPT> |
|