hyperformula

The spreadsheet app looks like a really nice boiler plate. I was surprised to learn about this amazing library digging through the docs: https://github.com/handsontable/hyperformula

My initial thoughts were how does a spreadsheet do it? but it's a different kind of beast. In search of a parser toolkit I had come across this https://github.com/handsontable/hyperformula which uses chevrotain to parse spreadsheet formulas and decided to use chevrotain for the parsing.

There was a time when we used Excel Services in SharePoint to meet some of our business user needs. I wouldn’t use Excel again, but back then it seemed to be a good trade-off between time-to-market and usability (meaning performance for most of the time). Anyhow, we use https://github.com/handsontable/hyperformula to run calculations in our other components these days.

If you're in TypeScript/JavaScript world, check out HyperFormula [1]. There's a summarized design document in the documentation that explains the AST, dependency graph, formula evaluation and lazy CRUD operations [2]. Disclaimer, I'm one of the founders. [1] https://github.com/handsontable/hyperformula [2] https://handsontable.github.io/hyperformula/guide/key-concep...

A similar product? https://github.com/handsontable/hyperformula