In the SpreadJS v15 release, TableSheet and Data Manager are officially out of beta. The TableSheet is a new type of sheet component that is an impressive data table that can also take full advantage of the 500+ functions in the SpreadJS calculation engine. This quick, data-bound table view includes a relational data manager that makes sorting, filtering, and many other data management functions incredibly fast. Read the release announcement to learn more about these new features.
The SpreadJS team added many enhancements to the Designer, which provides users with an improved experience. The Designer now supports printing with a page setup dialog. The dialog includes tabs for Page, Margins, Header/Footer, and Sheet, allowing users to control the various familiar options for printing SpreadJS workbooks. The new Remove Duplicates option can remove redundant data quickly and automatically. The new functionality will keep only the first occurrence of a value in a selected cell range and delete the other identical values. Visit the website to learn more about the many Designer enhancements in SpreadJS v15.
In addition to the Designer, there are several new features in SpreadJS’s PivotTable add-on. With the new slicer, users can filter PivotTables with a single click utilizing the new slicer features. With a familiar interface, it’s possible to filter an aggregate target by connecting multiple PivotTables and managing the filter state of row and column fields. Learn more about PivotTable enhancements in SpreadJS’s release article.
“The new v15 release of SpreadJS marks the official launch of the new TableSheet and Data Manager, which combines an extremely powerful data table with database connection capabilities and the 500+ calc functions of the SpreadJS calculation engine,” said Product Manager Kevin Ashley. “This is in addition to the many other enhancements and LAMBDA functions that will help put your application a step above the rest with even more Excel compatibility and functionality.”
For more such updates and perspectives around Digital Innovation, IoT, Data Infrastructure, AI & Cybersecurity, go to AI-Techpark.com.