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

Glossary Item Box

Gets the value of a programmatically hidden cell at the specified row and column.

Syntax

[JavaScript]

var ret = FpSpread1.GetHiddenValue(row,columnName);

Parameters

row
Integer, row index
columnName
String, name of the column

Return Type

String, with the value of the cell

Remarks

This method is for use with a displayed spreadsheet, on the client, that may have hidden columns. Both row index and columnName string must be valid. For example, the column name could be the default letter designations (A, B, etc.), alternative designation of numbers (1, 2, etc.), the name of a data table column or bound field, or a custom name (such as Total).

Example

This is a sample that contains the method. On the client side, the script that contains the method would look like this:

JavaScript Copy Code
<SCRIPT language=javascript>
   function getHValue() {
       var hval = FpSpread1.GetHiddenValue(0,"D");
       alert("Value in Column D is " + hval);
   }
</SCRIPT>

See Also

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