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 v16.2
SpreadJS v16.2 is available. This release offers several great new features, some of which include:
- GanttSheet Add-On Beta
- New Formula Editor Panel
- Framework Support for Angular 16
- Cross-Sheet Reference Support in FormulaTextBox
- New Cell defaultValue Property
- More Accessibility Options
- New Designer Buttons for Excel Themes, Colors, and Fonts
- Window Aggregation Function Added to the TableSheet
- And Much More!