Formula Pro v4
A newly expanded formula set and enhanced engine performance, tailored for developers in search of a frontend or backend solution for spreadsheet-like calculations.
Published at 15/09/2023
Introducing
Formula Pro is a JavaScript plugin that executes spreadsheet-like calculations on the front end via a browser or backend utilizing Node.js. It adeptly manages ranges, variables, and JS precision issues, seamlessly integrating worksheets and supporting various formulas compatible with Excel, Google Sheets and other spreadsheet software.
The recent release of Formula Pro brings notable enhancements to the forefront of developing spreadsheet-like features. Fifty-one new formulas have been added, expanding the toolset for Excel-like calculations. The quality and reliability of the plugin have been further reinforced with the integration of hundreds of unit tests.
What's new in Formula Pro v4?
Version 4 brings performance enhancements and an extended formula library, improving calculation efficiency and Jspreadsheet compatibility with other major spreadsheet software.
Newly Added Functions
YIELD, YIELDDISC, XLOOKUP, YIELDMAT, AMORDEGRC, AMORLINC, COUPDAYS, COUPDAYSNC, UNARY_PERCENT, COUPNCD, COUPNUM, COUPPCD, COUPDAYSBS, PRICE, PRICEMAT, INTRATE, SORTBY, ENCODEURL, CHOOSECOLS, ERF.PRECISE, ERFC.PRECISE, MODE, POISSON, HSTACK, EXPAND, DROP, ARRAYTOTEXT, VALUETOTEXT, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, FILTER, MINVERSE, MDETERM, SEQUENCE, RANDARRAY, MINIFS, MAXIFS, UPLUS, UMINUS, ISBETWEEN, SINGLE, INFO, FORMULATEXT, AREAS, SHEETS, SHEET, CELL, ISREF, EUROCONVERT.
Roadmap
Those are formulas not implemented at this point and should be consider in future releases.
Remaining Functions for Integration: ACCRINTM, ASC, BAHTTEXT, CALL, CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBEVALUE, DBCS, DURATION, EUROCONVERT, FILTERXML, FORECAST.ETS, FORECAST.ETS.CONFINT, FORECAST.ETS.SEASONALITY, FORECAST.ETS.STAT, GETPIVOTDATA, IMAGE, JIS, MDURATION, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PERCENTILE, PERCENTRANK, PHONETIC, RANK, RECEIVED, REDUCE, REGISTER.ID, RTD, STOCKHISTORY, TAKE, TOCOL, TOROW, VAR, VDB, VSTACK, WEBSERVICE, WEIBULL, WRAPCOLS, WRAPROWS, LAMBDA, LET, MAKEARRAY, MAP, SCAN, BYCOL, BYROW, ISOMITTED.
Useful links
Formula Pro Documentation
Jspreadsheet Formulas
Jspreadsheet Calculations
Formula Picker Documentation
Cross-spreadsheet calculations example using Jspreadsheet