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

    Sets a value in a hidden cell.

    Syntax

    [JavaScript]

    FpSpread1.SetHiddenCellValue(rowName, colName, value);

    Parameters

    rowName
    String, row name
    colName
    String, column name
    value
    String, value to set in cell

    Return Type

    None

    Remarks

    This method puts a value in a hidden cell at the specified row and column. The AllowGetAllHiddenValue property can be set to determine whether to check the page or a sheet.

    Example 1

    This is a sample that contains the method.

    On the server side on page load:

    Code
    Copy Code
    FpSpread1.Sheets[0].Columns[0].Visible = false;
    FpSpread1.Sheets[0].Cells[0, 0].Text = "test";
    

    On the client side, the script that contains the method would look like this:

    JavaScript
    Copy Code
    <script type="text/javascript">
       function ProfileSpread()
       {
              var spread = document.getElementById("FpSpread1");
              var v = spread.GetHiddenCellValue("1", "A");
              alert(v);
              spread.SetHiddenCellValue("1", "A", "test2");
              alert(spread.GetHiddenCellValue("1", "A")); //'test2'
       }
    </script>
    
    See Also