Iterative calculations can help with finding solutions to certain calculations by running them over and over using the previous result. For example, you can perform what-if analysis with the CalcEngine.goalSeek function or find the future value of an investment at a certain month.
RegEx functions, short for regular expression functions, are powerful tools that enable users to search for and manipulate text based on a specified pattern. The SpreadJS's RegEx functions REGEXEXTRACT, REGEXMATCH, and REGEXREPLACE helps easily automate tasks, validate user input, and perform complex text manipulation operations.
Formula Editor Panel
Effortlessly manage long, complex formulas with SpreadJS's Formula Editor Panel plugin. The Formula Panel provides a flexible, formatted, outline view to collapse and expand formulas. Edit, debug, and optimize lengthy formulas seamlessly with flexible outline views, syntax highlighting, tooltip function information, and more.
What's New in SpreadJS v17
SpreadJS v17 is available! This release offers several great new enhancements, features and optional addons, including: