Handsontable example
by handsoncode
HTML
<div id="example3"></div>
CSS
</style><!-- Ugly Hack due to jsFiddle issue --> <script src="https://docs.handsontable.com/pro/bower_components/handsontable-pro/dist/handsontable.full.min.js"></script> <link type="text/css" rel="stylesheet" href="https://docs.handsontable.com/pro/bower_components/handsontable-pro/dist/handsontable.full.min.css">
JavaScript
document.addEventListener("DOMContentLoaded", function() {
function getData() {
return [
['', 'Kia', 'Nissan', 'Toyota', 'Honda', 'Mazda', 'Ford'],
['2012', 10, 11, 12, 13, 15, 16],
['2013', 10, 11, 12, 13, 15, 16],
['2014', 10, 11, 12, 13, 15, 16],
['2015', 10, 11, 12, 13, 15, 16],
['2016', 10, 11, 12, 13, 15, 16]
];
}
var
example3 = document.getElementById('example3'),
settings3,
hot3;
settings3 = {
data: getData(),
rowHeaders: true,
colHeaders: true,
contextMenu: {
items: {
"custom_item": {
name: 'Custom option',
callback: function(key, options) {
console.log('It shows a log for rows other than first');
// does some things after click
},
hidden: function() {
// if first row, disable this option
return hot3.getSelectedRange().to.row === 0;
}
},
"custom_item_two": {
name: 'Custom option 2',
callback: function(key, options) {
console.log('This shows log for all the rows');
// does some things after click
}
}
}
}
};
hot3 = new Handsontable(example3, settings3);
});