Alignment

优质
小牛编辑
132浏览
2023-12-01

To initialize Handsontable with predefined horizontal and vertical alignment, provide className cells details in form of a grid, columns or cell setting (see code sample below).

Available classNames:

  • Horizontal: htLeft, htCenter, htRight, htJustify,
  • Vertical: htTop, htMiddle, htBottom.

Alignment changes can be tracked using afterSetCellMeta hook callback.

var
  container = document.getElementById('example1'),
  hot1;

hot1 = new Handsontable(container, {
  data: Handsontable.helper.createSpreadsheetData(100, 18),
  colWidths: 100,
  rowHeaders: true,
  colHeaders: true,
  contextMenu: true,
  mergeCells: [
    {row: 1, col: 1, rowspan: 3, colspan: 3},
    {row: 3, col: 4, rowspan: 2, colspan: 2}
  ],
  className: "htCenter",
  cell: [
    {row: 0, col: 0, className: "htRight"},
    {row: 1, col: 1, className: "htLeft htMiddle"},
    {row: 3, col: 4, className: "htLeft htBottom"}
  ],
  afterSetCellMeta: function (row, col, key, val) {
    console.log("cell meta changed", row, col, key, val);
  }
});