Spread ASP.NET 14
Spread for ASP.NET 14 Product Documentation / Client-Side Scripting Reference / Scripting Members / Methods / GetValue
In This Topic
    GetValue
    In This Topic

    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