Spread for ASP.NET 7.0 Product Documentation
SetHiddenValue
See Also Support Options
Spread for ASP.NET 7.0 Product Documentation > Client-Side Scripting Reference > Scripting Members > Methods > SetHiddenValue

Glossary Item Box

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>

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.