Sets a value in a hidden cell.
[JavaScript]
FpSpread1.SetHiddenCellValue(rowName, colName, value);
None
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.
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> |