ESSENTIAL STUDIO® 2025 VOLUME 3
What's New in Essential Studio® Spreadsheet Editor SDK
The Volume 3 release improves the JavaScript Spreadsheet with aggregated functions and styling in discontinuous ranges, as well as date interpolation in charts.
What’s New
What's New in Essential Studio® Spreadsheet Editor SDK
Web Spreadsheet Editor (Javascript, Angular, React, Vue, ASP.NET Core & MVC)
Skip specific properties during Excel import
The Spreadsheet component allows skipping specific properties using parsing options in the server-side library and client-side events to improve performance when opening Excel files. This enhancement reduces the size of the generated JSON and significantly boosts rendering speed—especially beneficial for large or complex Excel files.
Date interpolation in charts
Charts referencing date values support interpolation, enabling smoother transitions and accurate visualizations. This feature aligns with Microsoft Excel’s charting behavior, enhancing the clarity of date-based data presentations.
Apply cell styles to discontinuous ranges
Users can apply cell styles to discontinuous cell ranges like Microsoft Excel. This feature provides greater flexibility in formatting and improves the overall user experience.
Aggregate calculation for discontinuous ranges
Display aggregate summaries, such as SUM, AVERAGE, COUNT, MIN, and MAX, directly in the sheet tab for discontinuous cell ranges. This enhancement streamlines quick data analysis and improves usability when working with non-contiguous selections.
