Spread for ASP.NET 11 Product Documentation
GetValue
Spread for ASP.NET 11 Product Documentation > Client-Side Scripting Reference > Scripting Members > Methods > 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:

JavaScript
Copy Code
<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