Spread for ASP.NET 8.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 language=javascript> function onCancelButtonClick() { var spread = FpSpread("FpSpread1"); spread.Cells(1,2).SetValue("123"); // sets the cell property } </SCRIPT> |