# Cells

Use the Cells method to represent a cell on the client side and allows you to get or set various cell properties. Learn its syntax and parameters in the documentation.

## Content

This method represents a cell on the client side and allows you to get or set various cell properties.

## Syntax

[JavaScript]

```javascript
FpSpread1.Cells(r,c);
```

## Parameters

***row***
Integer, row index
***column***
Integer, column index

## Return Type

None

## Remarks

This method allows you to get or set various cell properties such as Value, BackColor, ForeColor, TabStop, HorizontalAlign, VerticalAlign, Locked, Font\_Name, Font\_Size, Font\_Bold, Font\_Italic, Font\_Overline, Font\_Strikeout, and Font\_Underline.

| **Methods** | **Return Type** | **Description** |
| ------- | ----------- | ----------- |
| GetValue() | String | Gets the value of the cell. |
| SetValue(String value) | \- \- | Sets the value of the cell. |
| GetBackColor() | String | Gets the backcolor of the cell. |
| SetBackColor(String color) | \- \- | Sets the backcolor of the cell. |
| GetForeColor() | String | Gets the forecolor of the cell. |
| SetForeColor(String color) | \- \- | Sets the forecolor of the cell. |
| GetTabStop() | Boolean | Gets the TabStop setting of the cell. |
| SetTabStop(Boolean IsStop) | \- \- | Sets the TabStop setting of the cell. |
| GetCellType() | String | Gets the cell type of the cell. |
| GetHAlign() | String | Gets the HorizontalAlign property of the cell. |
| SetHAlign(String nalign) | \- \- | Sets the HorizontalAlign property for the celll. |
| GetVAlign() | String | Gets the VerticalAlign property of the cell. |
| SetVAlign(String nalign) | \- \- | Sets the VerticalAlign property for the cell. |
| GetLocked() | Boolean | Gets the locked value of the cell. |
| SetLocked(Boolean locked) | \- \- | Sets the locked or unlocked status of the cell. |
| GetFont\_Name() | String | Gets the font name of the cell. |
| SetFont\_Name(String name) | \- \- | Sets the font name of the cell. |
| GetFont\_Size() | String | Gets the font size of the cell. |
| SetFont\_Size(String size) | \- \- | Sets the the font size of the title. |
| GetFont\_Bold() | Boolean | Gets a value that indicates whether the font is bold for the cell. |
| SetFont\_Bold(Boolean IsBold) | \- \- | Sets a value that indicates whether the font is bold for the cell. |
| GetFont\_Italic() | Boolean | Gets a value that indicates whether the font is italic for the cell. |
| SetFont\_Italic(Boolean IsItalic) | \- \- | Sets a value that indicates whether the font is italic for the cell. |
| GetFont\_Overline() | Boolean | Gets a value that indicates whether the font is overlined. |
| SetFont\_Overline(Boolean IsOverLine) | \- \- | Sets a value that indicates whether the font is overlined. |
| GetFont\_Strikeout() | Boolean | Gets a value that indicates whether the font is strikethrough. |
| SetFont\_Strikeout(Boolean IsStrikeout) | \- \- | Sets a value that indicates whether the font is strikethrough. |
| GetFont\_Underline() | Boolean | Gets a value that indicates whether the font is underlined. |
| SetFont\_Underline(Boolean IsUnderline) | \- \- | Sets a value that indicates whether the font is underlined. |

## 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 onCancelButtonClick() {
       var spread = FpSpread("FpSpread1");
       spread.Cells(1,2).SetValue("123"); // sets the cell property
   }
</script>
```

## See Also

[Update](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members/clientscript-allmeths/CSSR-Update)
[UpdatePostBackData](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members/clientscript-allmeths/CSSR-UpdatePostBackData)
[Scripting Members](/spreadnet/docs/latest/online-asp/overview/spweb-clientscriptref/clientscript-members)