Handsontable Paste issue Demo
HTML
<div id="hot"></div>
CSS
</style><!-- Ugly Hack due to jsFiddle issue --> <script src="https://docs.handsontable.com/pro/1.5.0/bower_components/handsontable-pro/dist/handsontable.full.min.js"></script> <link type="text/css" rel="stylesheet" href="https://docs.handsontable.com/pro/1.5.0/bower_components/handsontable-pro/dist/handsontable.full.min.css">
JavaScript
var dynamicRenderer = function(instance, td, row, col, prop, data, cellProperties){
Handsontable.renderers.TextRenderer.apply(this, arguments);
Handsontable.Dom.empty(td);
if(instance.getDataAtCell(row,0)){//If first col has data
instance.setCellMeta(row,0,'readOnly',false);//enable col 1
instance.setCellMeta(row,1,'readOnly',true);//disable col 2
instance.setCellMeta(row,2,'readOnly',true);//disable col 3
}else if(instance.getDataAtCell(row,1) || instance.getDataAtCell(row,2)){//If data present in second or third col
instance.setCellMeta(row,0,'readOnly',true);//disable col 1
instance.setCellMeta(row,1,'readOnly',false);//enable col 2
instance.setCellMeta(row,2,'readOnly',false);//enable col 3
}else{
//enable all columns
instance.setCellMeta(row,1,'readOnly',false);
instance.setCellMeta(row,2,'readOnly',false);
instance.setCellMeta(row,0,'readOnly',false);
}
data = data !== null ? data : '';
td.title = data;
td.appendChild(document.createTextNode(data));
return td;
};
var hotElement = document.querySelector('#hot');
var hotElementContainer = hotElement.parentNode;
var hotSettings = {
data: {},
columns: [{
data: 'id',
renderer:dynamicRenderer
}, {
data: 'flag',
renderer:dynamicRenderer
}, {
data: 'currencyCode',
renderer:dynamicRenderer
}],
stretchH: 'all',
width: 806,
autoWrapRow: true,
height: 441,
maxRows: 22,
rowHeaders: true,
colHeaders: true
};
var hot = new Handsontable(hotElement, hotSettings);