| Spread for ASP.NET 9.0 Product Documentation > Client-Side Scripting Reference > Scripting Members > Methods > Cells |
This method represents a cell on the client side and allows you to get or set various cell properties.
[JavaScript]
FpSpread1.Cells(r,c);
None
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. |
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 type="text/javascript"> function onCancelButtonClick() { var spread = FpSpread("FpSpread1"); spread.Cells(1,2).SetValue("123"); // sets the cell property } </script> |
|