javascriptjqueryhandsontable

Completely disable a handsontable


I have just started using handsontable with JSON data and its working great but I need to disable all table input to certain users (read-only view).

Is there a way to completely disable a handsontable so none of the inputs respond and the remove row plugin doesn't function? I have tried http://dougestep.com/dme/jquery-disabler-widget-demos which doesn't seem to work and http://malsup.com/jquery/block/#element which works but it essentially creates an iframe overlay over the controls and with the removerow plugin the position is off set incorrectly.


Solution

  • To fully "disable" a Handsontable I have done the following:

    hot.updateSettings({
        readOnly: true, // make table cells read-only
        contextMenu: false, // disable context menu to change things
        disableVisualSelection: true, // prevent user from visually selecting
        manualColumnResize: false, // prevent dragging to resize columns
        manualRowResize: false, // prevent dragging to resize rows
        comments: false // prevent editing of comments
    });