Tlačidlá s možnosťou zmeny typu bunky

by janzitniak

HTML

<div id="example"></div>
<button id="btnCurrency">Set currency</button>
<button id="btnPercentage">Set percentage</button>
<button id="btnDate">Set date</button>
<button id="btnText">Set text</button>
<button id="btnNumeric">Set numeric</button>

CSS

.handsontable .border {
  border: 1px solid black;
}

.handsontable .colorbkg {
  background-color: lightblue;
}
</style><!-- Ugly Hack due to jsFiddle issue -->

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

JavaScript

var data = [
  ['', 'Ford', 'Tesla', 'Toyota', 'Honda'],
  ['2017', 10, 11, 12, "=SUM(B2:D2)"],
  ['2018', 20, 11, 14, 13],
  ['2019', 30, 15, 12, 13]
];

var container = document.getElementById('example');

var hot = new Handsontable(container, {
  data: data,
  rowHeaders: true,
  colHeaders: true,
  filters: true,
  dropdownMenu: true,
  outsideClickDeselects: false,
  selectionMode: 'multiple',
  formulas: true,
  licenseKey: 'non-commercial-and-evaluation'
});

var setButton = document.getElementById('btnPercentage');
setButton.addEventListener('click', function(event) {
  hot.setCellMetaObject(1, 1, {
    type: 'numeric',
    numericFormat: {
      pattern: {
        output: "percent",
        mantissa: 0
      }
    }
  });
  hot.render();
})

var setButton = document.getElementById('btnCurrency');
setButton.addEventListener('click', function(event) {
  hot.setCellMetaObject(1, 1, {
    type: 'numeric',
    numericFormat: {
      pattern: '0,0.00 $',
      culture: 'de-DE' // use this for EUR (German),
    }
  });
  hot.render();
})

var setButton = document.getElementById('btnText');
setButton.addEventListener('click', function(event) {
  hot.setCellMetaObject(1, 1, {
    type: 'text'
  });
  hot.render();
})

var setButton = document.getElementById('btnDate');
setButton.addEventListener('click', function(event) {
  hot.setCellMetaObject(1, 1, {
    type: 'date'
  });
  hot.render();
})

var setButton = document.getElementById('btnNumeric');
setButton.addEventListener('click', function(event) {
  hot.setCellMetaObject(1, 1, {
    type: 'numeric'
  });
  hot.render();
})