GetValue

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:

<script type="text/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>

See Also

SetValue

GetHiddenValue

Scripting Members