SpreadJS 13
SpreadJS Documentation / Developer's Guide / Features / Customize Appearance / Colors
In This Topic
    Colors
    In This Topic

    You can set background and foreground colors for cells, columns, rows, headers, and the widget.

    Cell background and forecolor

    Set the backColor or foreColor methods for cells, columns, headers, or rows. You can set the backColor method or use themes for the widget. You can use the options.grayAreaBackColor property for the gray area.

    For more information about themes, refer to Configure Themes. You can also use styles to set cell colors. For more information, refer to Set Styles.

    Using Code

    This example sets the foreColor and backColor for cell B2.

    JavaScript
    Copy Code
    //Set the backcolor and forecolor of cells.
        var cell = activeSheet.getCell(1, 1, GC.Spread.Sheets.SheetArea.viewport);
        cell.backColor("Blue");
        cell.foreColor("Red");
        cell.value("Color");
    

    Using Code

    This example sets the forecolor and backcolor for the header.

    JavaScript
    Copy Code
    //Set the backcolor and forecolor for the entire column header.
         var row = activeSheet.getRange(0, -1, 1, -1, GC.Spread.Sheets.SheetArea.colHeader);
         row.backColor("Red");
         row.foreColor("White");
         //Set the backcolor for the second row header.
         activeSheet.getCell(1, 0, GC.Spread.Sheets.SheetArea.rowHeader).backColor("Yellow");
    
    See Also