Spread for ASP.NET 12 Product Documentation
Cells
Spread for ASP.NET 12 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.

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