Spread ASP.NET 17
Spread for ASP.NET 17 Product Documentation / Client-Side Scripting Reference / Scripting Members / Methods / Cells
In This Topic
    Cells
    In This Topic

    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
    Update
    UpdatePostBackData
    Scripting Members