This plugins enables Excel-like formula evaluation for Handsontable.
See demo on JSFiddle
Include handsontable-excel code after handsontable code.
<script src="lib/jquery.min.js"></script>
<script src="dist/jquery.handsontable.full.js"></script>
<link rel="stylesheet" media="screen" href="dist/jquery.handsontable.full.css">
<script src="jquery.handsontable-excel.js"></script>Every cell beginning with = will be evaluated. Supported syntax:
-
algebraic operations
=(4+5+6)*7 -
cell references (letter for colums, number for row format: A4, B1, C7)
=(A1+A2+A3)*7 -
function calls
=SUM(A1:A3)*7