Completely disable a handsontable

javascript jquery handsontable
PeteT picture PeteT · Mar 17, 2014 · Viewed 8k times · Source

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.

Answer

JonBrave picture JonBrave · Nov 25, 2016

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

Related questions

Disabled inputs in bootstrap. How to apply it to a different TAG?

By using disabled attribute on an input is possible to prevent user input and trigger a slightly different look. Here is the demo http://jsfiddle.net/D2RLR/3023/ Let's suppose I want to apply the same style to a different …

Read More
How to get handson table data in json format with column header as key

I have handsontable and I want to get data enter on handsontable cell into server side. I have tried to ran below code but data is not in expected format. I was expecting to get the data in pure json …

Read More
Handsontable Replace autocomplete values with key before posting

I am using HandsOnTable to make editing database tables more interactive on my site. HandsOnTable fulfils nearly all my requirements except that some columns in my database actually store foreign keys rather than local string values. In the UI I …

Read More