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

});