Released on May 20, 2026
Breaking changes
The new release introduces significant changes in the Spreadsheet API: there is a set of deprecated methods, properties and events. Check the Migration guide to keep in step with the latest version.
New functionality
- React Spreadsheet wrapper is introduced. Check related examples in the GitHub demo repository
- The
SheetManagermodule is introduced. It is a centralized API for managing sheets in Spreadsheet. It is accessible via thespreadsheet.sheetsproperty and replaces all the deprecated sheet-related methods on the root Spreadsheet instance. - The ability to specify a custom (user-defined) formula via the new
addFormula()method - The ability to display numbers in the scientific (exponential) notation
Updates
- The ability to adjust the font size of cell content:
- setting a default font size option via a built-in toolbar control
- setting a custom font size for the toolbar control
- New conditional aggregate functions are added into the formulas engine:
COUNTIF,COUNTIFS,SUMIF,SUMIFS,AVERAGEIF,AVERAGEIFS,MAXIFS,MINIFS - New dynamic array functions are added into the formulas engine:
CHOOSECOLS,CHOOSEROWS,DROP,EXPAND,RANDARRAY,SEQUENCE,SORT,SORTBY,TAKE,TEXTSPLIT,TOCOL,TOROW,UNIQUE,WRAPCOLS,WRAPROWS - The
awaitRedraw()helper is added for Spreadsheet to detect the rendering process and run the desired code after the component finishes rendering - JSDoc annotations are added to the type definitions, providing inline API descriptions, parameter types, and code examples directly in the IDE