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. 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+ 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.”
About GrapeCity: GrapeCity is an award-winning Microsoft Gold Certified Partner and one of the world’s largest providers of developer components. The company has more than 850 employees and hundreds of thousands of customers worldwide. For over 30 years, GrapeCity has provided enterprises around the world with state-of-the-art developer tools and components, software services, and solutions. For more company information, visit the GrapeCity website.
All product and company names herein may be trademarks of their respective owners.