# SetHiddenCellValue

Use the SetHiddenCellValue method to set a value in a hidden cell. Learn its syntax and parameters in documentation.

## Content

Sets a value in a hidden cell.

## Syntax

[JavaScript]

```javascript
FpSpread1.SetHiddenCellValue(rowName, colName, value);
```

## Parameters

***rowName***
String, row name
***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. 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 1

This is a sample that contains the method.
On the server side on page load:

```csharp
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
<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>
```

## See Also

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