Handsontable example

by Aleksandra Maria Budnik

HTML

<div id="example1" class="hot handsontable htColumnHeaders"></div>

CSS

</style>

<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/handsontable.full.min.css">
<script src="https://handsontable.com/docs/7.3.0/components/numbro/dist/languages.min.js"></script>

JavaScript

function getCarData() {
    return [
      [1.09534, 0.65464, '=A1+B1']
    ];
  }
  var
    container = document.getElementById('example1'),
    hot = new Handsontable(container, {
    data: getCarData(),
    colHeaders: true,
    formulas: true,
    licenseKey: 'non-commercial-and-evaluation',
    columnSorting : true,
    columns: [
      {}, {},
      {
        type: 'numeric',
        numericFormat: {
          pattern: '0,0.00 $',
          culture: 'pt-BR'
        }
      }
    ]
  });