Disable Cell Editing or Make Cell Readonly

Question

When the user types a value in a cell of a certain column, I would like to make the cell of the next column(same row), readonly ou not editable. If the user deletes de value, I would like to make the next cell editable again.

Can someone give an example of how to achive this?

Thank you.

score 0 · Answer 1 · answered Mar 30 '16 at 14:13

You can try to define your columns like this:

const hot = new Handsontable(el, {
  data: someData,
  columns: [
    { type: 'text'},
    { type: 'numeric'},
    { type: 'text'}
  ]
});

You can update the settings like this

hot.updateSettings({
    columns: [
      { type: 'text'},
      { type: 'text', readOnly: true},
      { type: 'text'}
    ]
});

Disable Cell Editing or Make Cell Readonly

1 Answers1