Handsontable example

by handsoncode

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/handsontable/8.2.0/handsontable.full.min.js"></script>
<div>
  <div id="example" class="hot handsontable htRowHeaders htColumnHeaders"></div>
</div>

CSS

</style><!-- Ugly Hack due to jsFiddle issue -->

<script src="https://cdn.jsdelivr.net/npm/handsontable@8.2.0/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@8.2.0/dist/handsontable.full.min.css">

JavaScript

var data = [
    [3, '=IF(ISBLANK(A1); ""; "=A1*UR")'], // B1 = 30
    [null, '=IF(ISBLANK(A2); ""; "=A2*UR")'] // B2 = ""
  ];
  var example = document.getElementById('example');
  var hot2 = new Handsontable(example, {
    data: data,
    colHeaders: true,
    rowHeaders: true,
    contextMenu: true,
    formulas: {
      variables: {
        UR: 10,
      }
    },
  });