Handsontable formula test
HTML
<div>
<div id="example1" class="hot handsontable htRowHeaders htColumnHeaders"></div>
</div>
CSS
</style><!-- Ugly Hack due to jsFiddle issue -->
<script src="https://gist.githack.com/budnix/d64dbf514f6616905d6a21e7f47ef011/raw/498372fbcc4a78369e0feb422dfbcc87c87f73bb/handsontable.full.js"></script><link type="text/css" rel="stylesheet" href="https://gist.githack.com/budnix/403f7049c07957acae6db8fa6ecfd1f5/raw/285165bd4031e4bb8b6923c8640fe25c753ae209/handsontable.full.css">
JavaScript
var data = [
[, 1, 4, ""],
[3, , 4, ],
['=SUM(A1+A2)', '=SUM(B1+B2)', '=SUM(C1+C2)', ' = Result in col A and B should be empty'],
];
var example1 = document.getElementById('example1');
var hot1 = new Handsontable(example1, {
data: data,
colHeaders: true,
rowHeaders: true,
contextMenu: true,
formulas: {
engine: HyperFormula
}
});