Formula Pro v6

JavaScript spreadsheet formula parser and execution engine.

Compatibility

- Formula Pro v6: Requires JSpreadsheet Pro v12 or later
- Formula Pro v5: Use with JSpreadsheet Pro v11

Overview

Formula Pro implements a custom shunting yard parser that translates Excel-compatible formula strings into secure JavaScript operations.

Features

- 400+ Excel-compatible formulas
- Secure execution in private scope
- Cross-worksheet calculations
- Range operations (A1:B10, A:A, 1:1)
- Defined names and external variables
- Matrix operations
- @ operator and column name references
- Floating-point precision adjustment
- Formula caching for performance
- International customization

Installation

``bash
npm install @jspreadsheet/formula-pro
``

Supported Formulas

Formula Pro implements 400+ Excel-compatible formulas across categories:

- Mathematical: SUM, AVERAGE, ROUND, POWER, etc.
- Statistical: STDEV, VAR, MEDIAN, MODE, etc.
- Logical: IF, AND, OR, NOT, XOR, etc.
- Text: CONCATENATE, LEFT, RIGHT, MID, TRIM, etc.
- Date/Time: NOW, TODAY, DATE, YEAR, MONTH, DAY, etc.
- Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET, etc.
- Financial: PMT, FV, PV, RATE, NPV, IRR, etc.
- Engineering: CONVERT, DELTA, BIN2DEC, etc.
- Database: DSUM, DAVERAGE, DCOUNT, etc.

Full list: https://jspreadsheet.com/docs/formulas/functions

License

Commercial license required. Visit https://jspreadsheet.com for licensing.

Dependencies

- jsuites ^6.0.0

Links

- Product page: https://jspreadsheet.com/products/formulas
- Documentation: https://jspreadsheet.com/docs
- Issues: https://github.com/jspreadsheet/pro/issues