SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Cells / Spanning or Merging Cells
In This Topic
    Spanning or Merging Cells
    In This Topic

    You can span or merge cells.

    Merging cells in a worksheet

    Using Code

    This example spans blocks of cells.

    JavaScript
    Copy Code
    window.onload = function()
    {
      var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
      var activeSheet = spread.getActiveSheet();
    
     // Merge three columns with origin at cell(1,1).
     activeSheet.addSpan(1, 1, 1, 3, GC.Spread.Sheets.SheetArea.viewport);
    
     // Merge 2 rows x 2 columns with origin at cell(3,3).
     activeSheet.addSpan(3, 3, 2, 2, GC.Spread.Sheets.SheetArea.viewport);
    
     // Set on every anchor cell
     var cell = activeSheet.getCell(1, 1, GC.Spread.Sheets.SheetArea.viewport);
     cell.backColor("LightCyan");
     cell.value("Row binding");
     cell = activeSheet.getCell(3, 3, GC.Spread.Sheets.SheetArea.viewport);
     cell.backColor("LightPink");
     cell.value("Matrix binding");
     cell.hAlign(GC.Spread.Sheets.HorizontalAlign.center);
     cell.vAlign(GC.Spread.Sheets.VerticalAlign.center);
    } 
    
    See Also

    Developer's Guide