# GetHiddenCellValue

Use the GetHidden method to get the value of a programmatically hidden cell at the specified row and column. Learn its syntax and parameters in documentation.

## Content

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

## Syntax

[JavaScript]

```javascript
var ret = FpSpread1.GetHiddenCellValue(rowName,columnName);
```

## Parameters

***rowName***
String, name of the row
***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 or rows. Both the rowName 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). The [AllowGetAllHiddenValue](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.AllowGetAllHiddenValue.html) property can be set to determine whether to check the page or a sheet.

## Example

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

```javascript
<script type="text/javascript">
   function getHValue() {
       var hval = FpSpread1.GetHiddenCellValue("1","D");
       alert("Value in Column D is " + hval);
   }
</script>
```

## See Also

[AllowGetAllHiddenValue Property](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.AllowGetAllHiddenValue.html)