Package Exports

@jspreadsheet/formula-pro
@jspreadsheet/formula-pro/dist/index.js

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (@jspreadsheet/formula-pro) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

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

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

@jspreadsheet/formula-pro