Spread for ASP.NET 18 Product Documentation

SetHiddenCellValue

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:

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:

<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>