Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can allow the text in a cell to overflow into an adjacent cell with the 你可以使用 options.allowCellOverflow property. 属性来设置当单元格中的文字的长度较长时,是否溢出到相邻的单元格中。

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

 

See Also更多信息
Worksheet Method