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