SpreadJS 14
Features / Cells / Cell Colors
In This Topic
    Cell 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 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");
    

     

    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");
    

     

    This example changes the color of the active cell.

    JavaScript
    Copy Code
    window.onload = function()
    {
       var spread =
       new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
       var sheet = spread.getActiveSheet();
       sheet.getCell(0, 0).backColor("pink");
       sheet.bind(GC.Spread.Sheets.Events.LeaveCell, function (event, infos) {
       
       // Reset the backcolor of cell before moving
       infos.sheet.getCell(infos.row, infos.col).backColor(undefined);
       });
      
       sheet.bind(GC.Spread.Sheets.Events.EnterCell, function (event, infos) {
               
       //Set the backcolor of destination cells (currently active cells)
       infos.sheet.getCell(infos.row, infos.col).backColor("pink");
    });
    }
    
    See Also