Spread ASP.NET 6.0 Product Documentation
GetValue
Send Feedback
Spread ASP.NET 6.0 Product Documentation > Client-Side Scripting Reference > Scripting Members > Methods > GetValue

Glossary Item Box

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>

See Also

SetValue | GetHiddenValue | Scripting Members

© 2002-2012 GrapeCity, Inc. All Rights Reserved.