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

    You can allow the text in a cell to overflow into an adjacent cell with the options.allowCellOverflow property.

    Cell overflow in SpreadJS

    Using Code

    This example sets the alignment and allows the text to overflow into other cells.

    JavaScript
    Copy Code
    activeSheet.options.allowCellOverflow = true;
    activeSheet.getCell(0,3, GC.Spread.Sheets.SheetArea.viewport).hAlign(GC.Spread.Sheets.HorizontalAlign.left);
    activeSheet.getCell(1,3, GC.Spread.Sheets.SheetArea.viewport).hAlign(GC.Spread.Sheets.HorizontalAlign.center);
    activeSheet.getCell(2,3, GC.Spread.Sheets.SheetArea.viewport).hAlign(GC.Spread.Sheets.HorizontalAlign.right);
    activeSheet.getCell(3,3, GC.Spread.Sheets.SheetArea.viewport).hAlign(GC.Spread.Sheets.HorizontalAlign.general);
    activeSheet.getCell(0,3, GC.Spread.Sheets.SheetArea.viewport).text("Data overflows to the right");
    activeSheet.getCell(1,3, GC.Spread.Sheets.SheetArea.viewport).text("Data overflows to the left and right");
    activeSheet.getCell(2,3, GC.Spread.Sheets.SheetArea.viewport).text("Data overflows to the left");