Sets a value in a hidden cell.
Syntax
[JavaScript]
FpSpread1.SetHiddenValue(r, colName, value);
Parameters
- r
- Integer, row index
- 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.
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 language=javascript> function ProfileSpread() { var spread = document.getElementById("FpSpread1"); var v = spread.GetHiddenValue(0, "A"); alert(v); spread.SetHiddenValue(0, "A", "test2"); alert(spread.GetHiddenValue(0, "A")); //'test2' } </SCRIPT> |
|