After many customer requests, the SpreadJS team is pleased to announce support for pivot tables. This useful Excel feature for summarizing and analyzing large quantities of data also launches with a PivotPanel UI and Excel import and export capabilities. The SpreadJS pivot table add-on supports various functions like sorting, filtering, and grouping. To learn more about this long-awaited feature, read the release blog.
The camera shape is a new feature that lets you create a dynamic snapshot of a specified range of cells, which makes it ideal for creating stunning dashboards. This shape will reflect all the live changes made in the actual cell range. The camera shape works like a regular shape and includes Excel import and export, grouping and ungrouping, copying and pasting capabilities, and cross-sheet support. These features allow the user to observe changes in their spreadsheet even when the changes are not currently displayed. To learn more about the new camera shape, visit the release blog.
TableSheet, now in beta, is a quick, data-bound table view with spreadsheet functionality and an advanced relational data manager. It has grid-like behavior and a spreadsheet user interface. TableSheet includes powerful, structured formulas, in addition to support for column formulas, styles, conditional formatting, sorting, and filtering. To learn more about this table view in beta, visit the website.
"The new SpreadJS v14.1 release includes many new and exciting features like Pivot Tables, Camera Shapes, chart, calculation, shape, and workbook enhancements," said Product Manager, Kevin Ashley. "Utilize the new image, histogram, or gauge KPI sparklines and shape hyperlinks to create intuitive and responsive spreadsheets and dashboards."
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.