SpreadJS v19 Released!

We’re excited to announce the release of SpreadJS v19, a feature-packed version that spans data visualization, analysis, usability, and offers real-time collaboration and an AI assistant. This release introduces new chart types, improved designer functionality, better integration with modern frameworks, and numerous productivity/performance enhancements across the board. Developers can look forward to building more powerful and intuitive spreadsheet applications with these updates.

Ready to dive into the details? Let’s explore what’s new in each area of SpreadJS v19.

• New Collaboration Server Add-On
• New AI Assistant Add-On
• Formulas
• Pivot Table Add-On
• DataCharts Add-On
• ReportSheet Add-On
• UI and UX Enhancements
• Framework Support
• NPM Support Notice

Download a the Latest Release of SpreadJS Today!

New Collaboration Server Add-On

Collaboration Server Officially Released

SpreadJS v19 introduces Collaboration Server, an optional, robust set of collaboration features designed to bring seamless real-time editing to JavaScript spreadsheets. These collaboration features are similar to what you will find in Excel for the Web or Google Sheets. Whether you're building applications for teams, enterprises, or embedded SaaS tools, these capabilities eliminate synchronization delays, streamline user interaction, and reduce the complexity of maintaining consistent data states across users.

SpreadJS Collaboration Server offers a full-stack solution for real-time editing across users. The server is powered by Node.js, and the client seamlessly integrates with it. The Collaboration Server supports change tracking, conflict resolution, user permissions, and true live editing.   

Live Editing

Display real-time collaborator activity, including cursors, selections, and editing positions, directly within shared spreadsheets or documents.

Conflict Resolution

Keep every user’s view synchronized in real-time with the Operational Transformation (OT) engine that ensures data accuracy and conflict-free collaboration across sessions.

Permission Controls

Set granular editing and viewing permissions in collaborative spreadsheets to ensure secure and flexible real-time collaboration.

Get all of this and so much more in the new Collaboration Server!

Learn more in our Collaboration Server documentation, the online demo sample, or our introduction video.

New AI Assistant Add-On

AI-Assistant Officially Released

With v19, SpreadJS introduces an optional AI Assistant add-on including a powerful new set of AI-driven features designed to transform how users interact with JavaScript spreadsheets.

This AI Assistant addon is like sitting an Excel expert down with your users to help them create complex workbooks with ease.

The SpreadJS AI Assistant offers:

Formula Generation & Explanation Using Natural Language

Use natural language in the AI Formula Editor to instantly generate Excel-style formulas and get clear, step-by-step explanations of complex formulas—all in one streamlined experience.

PivotTable Generation Based on Descriptive Input

Use AI-powered PivotTable tools in SpreadJS to instantly generate layouts and get intelligent data insights—all through simple natural language input.

AI Worksheet Functions for Text Processing & Translation

AI functions in SpreadJS let you query data, translate content, and analyze sentiment directly in cells—bringing natural language intelligence to every part of your spreadsheet.

Learn more in our AI Assistance documentation, live AI demos, or our recent live webinar.

Formulas

Enhanced Calculation Performance with Web Worker

The new calcWorker Plugin offloads spreadsheet calculations to a Web Worker, keeping the main thread responsive during intensive recalculation. Enable this plugin to improve performance and avoid UI freezing when working with large or formula‑heavy workbooks.

Performance Benchmark

Compared to incremental calculations in the main thread, calcWorker incremental calculations require time for web workers to communicate with the main thread, but web workers can offload most of the cell formula evaluation tasks.

As shown in the following benchmarks using workbooks with heavy formula usage, the overall calculation time can be over 2 times faster.

Learn more in our Incremental Calculation documentation.

PivotTable Add-On

Date Grouping Support

The optional SpreadJS PivotTable addon allows you to group and ungroup datetime fields in pivot tables. You can group data by common intervals—such as seconds, minutes, hours, days, months, quarters, or years—and you can also define custom ranges, like a 7‑day interval (for a weekly view) or any other span that fits your scenario.

Learn more in our PivotTable Grouping documentation.

Drag-and-Drop Custom Reordering/Sorting

Just like in Excel, users can now manually reorder Pivot field items by dragging them after a global sort. The change takes effect immediately and is saved as a custom sort state.

Learn more in our PivotTable Sort documentation.

PivotTable Interaction in Protected Worksheet

Just like in Excel, SpreadJS enables limited PivotTable interactions in protected worksheets. These features can be controlled through the allowUsePivotTable property.

• When set to true, users can make modifications to PivotTables.
• When set to false, most editing actions are restricted, though some basic operations remain available.

Learn more in our Protected Worksheet documentation.

DataCharts Add-On

While the base SpreadJS chart had these chart types already, now we are introducing them to our optional DataCharts add-on.  

Waterfall DataCharts

The new Waterfall chart in DataCharts illustrates how sequential positive and negative values affect a cumulative total. It visually breaks down each contributing factor, making it useful for analyzing changes in profit, budget variance, sales performance, or inventory trends.

Read more in our Waterfall DataChart docs or try our Waterfall DataChart demo.

Candlestick DataCharts

The Candlestick chart in DataCharts is a data visualization tool designed to illustrate the price movements of an asset within a specific time period. This chart type is widely used in financial data analysis to show open, high, low, and close (OHLC) values of securities, providing users with clear insights into market trends.

Learn more in our Candlestick DataChart docs or try our Candlestick DataChart demo.

OHLC DataCharts

The OHLC chart in DataCharts (Open–High–Low–Close) is a specialized data visualization feature that represents the price movement of an asset over a specified period. It is widely used in financial and stock market applications to observe daily, weekly, or monthly trends.

Learn more in our OHLC DataChart docs or try our OHLC DataChart demo.

Combo DataCharts

The Combo chart in DataCharts provides a flexible visualization tool that combines multiple chart types (e.g., column, line, area) into a single, unified chart. This allows users to represent and compare different types of data—such as quantities, trends, or percentages—within one graphical display.

Learn more in our Combo DataChart docs or try our Combo DataChart demo.

ReportSheet Add-On

New Template Range Feature

When your reports require repeating sections, nested details, or grouped summaries that adapt dynamically to your data structure, Template Range is the tool you need.

The optional ReportSheet add-on allows you to design structured, data‑driven report layouts directly inside SpreadJS—linking tables, building hierarchies, and rendering repeating sections automatically, without worrying about field context or layout logic.

Learn more in our ReportSheet Designer docs.

Display Total/Summary Headers in Container

You can now display Total or Summary data in Row or Column Headers in a ReportSheet Container. 

Learn more in our ReportSheet Container docs.

Fill Blank Data

The Fill Blank Data feature ensures that datasets inside list or group cells are padded with blank rows or columns until they meet a specified multiple when necessary.

Learn more in our ReportSheet Fill Blank Data docs.

Group-Level Pagination & Enhanced Pagination Functions

As of version 19, ReportSheet supports row pagination in Master-Detail reports. Paging is now supported at the group level.

Pagination details in a report can now be retrieved with the R.CURRENTPAGE and R.PAGESCOUNT functions, which work at both the report level and the group level. 

Learn more in our ReportSheet Pagination documentation.

Preserve Formulas When Exporting Report to Excel

The Preserve Formula in Export feature allows users to retain formulas when exporting reports to Excel. 

Learn more in our ReportSheet Preserve Formula docs.

UI and UX Enhancements

This release includes several user interface improvements designed to streamline spreadsheet navigation and editing making your apps feel faster, smarter, and more intuitive:

Enhancement	Description	Preview
Support Threaded Comments	Threaded Comments enable users to add contextual discussions to specific cells and reply to comments in threads.
Support Justify Alignment	Provides users with both horizontal and vertical justify alignment, ensuring that text is evenly distributed across the width and height of a cell
Exclude Data Headers when Sorting	SpreadJS now automatically detects header rows in the selected range and can exclude them from the sort.
Bulk Deletion in Name Manager Dialog	Similar to Excel, users can now select a range of names in the Name Manager Dialog and delete many at once.

Framework Support

Angular 20 Support

SpreadJS now officially supports Angular 20, ensuring compatibility with the latest Angular advancements.

Get started with our Angular guide.

Nuxt.js 4 Support

SpreadJS fully supports Nuxt.js 4, ensuring smooth client-side rendering and integration with modern Vue applications.

Get started with our NuxtJS guide.

NPM Support Notice

Starting in v19, the legacy npm package @grapecity/spread-sheets will no longer be updated. Please migrate to @mescius/spread-sheets to receive new features and support. Refer to our Migration Guide or reach out to our support team with any questions.

We encourage you to explore these new features and incorporate them into your projects. As always, you can find more details in our documentation and see these capabilities in action in our online demos. This release continues our commitment to making SpreadJS the most comprehensive and high-performance JavaScript spreadsheet solution available.

Happy coding, and we look forward to seeing what you build with SpreadJS v19!

Chris Bannon, Product Manager, SpreadJS