This method represents a cell on the client side and allows you to get or set various cell properties.
Syntax
[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 |  Copy Code |
|---|---|
<SCRIPT language=javascript> function onCancelButtonClick() { var spread = FpSpread("FpSpread1"); spread.Cells(1,2).SetValue("123"); // sets the cell property } </SCRIPT> |
|