Spread for ASP.NET 8.0 Product Documentation > Client-Side Scripting Reference > Scripting Members > Methods > GetValue |
Gets the value of a cell in the specified row and column.
[JavaScript]
var ret = FpSpread1.GetValue(row,column);
String, the value of the cell
This method returns the value as it is currently displayed in the cell. The row and column indexes must be valid.
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> |