I have a project requirement where, I have a Handsontable with data, with columns read-only, Now I want to add column insert options in dropdown menu and the columns those are newly added only that will be editable.
I am new to handsontable, what I want is the columns along with the data that I have initially are readOnly , that is what I have coded. Now only those column that I am adding using dropdownMenu: [‘col_left’ , ‘col_right’] this 2 option I my table I want those column only to be editable. is there a way to do that
Now, based on the use of array data you can define readOnly false for the whole dataset, and then use afterCreateCol hook to make the new column editable. Here’s a demo Handsontable example - JSFiddle - Code Playground