Tutorial: Formula support

Formula support

Edit this page
This plugin is still under development and should be considered an experimental feature.

A formula parser for Handsontable is based on RuleJS library which takes most of functions from Formula.js.

Find the list of features below:

  • math functions: + - * / ^
  • logical functions: = > < >= <= <> NOT
  • error handling: #DIV/0! #ERROR #VALUE! #REF! #NAME? #N/A
  • parser for formulas (list of supported formulas)
  • absolute cell references: $A$1 $A1 A$1
  • nested functions
  • basic auto-fill
  • dynamic updates

Go to demo to see it live