What's New in Essential Studio^® Spreadsheet Editor SDK

Web Spreadsheet Editor (JavaScript, Angular, React, Vue, ASP.NET Core, and ASP.NET MVC)

Discontinuous chart range support

Create charts from multiple nonadjacent rows, columns, or cell blocks for greater flexibility when visualizing selective or scattered data. Linked charts automatically update whenever any referenced range changes. This capability is fully supported across major chart types, including column, bar, area, pie, donut, line, and scatter.

Improved file import efficiency

Core server-side processes for file imports have been refined to improve memory efficiency and faster performance, ensuring a smoother experience when working with large Excel workbooks. This optimization is especially beneficial for complex files that include advanced styling, formatting, and rich content structures, enabling more reliable handling of heavy datasets with reduced resource usage.

The following metrics table highlights the reduction in peak memory consumption across different feature sets for an Excel sheet with 1 million cells compared to previous versions:

Enhanced clipboard behavior

Clipboard operations retain formatting, formulas, and cell references when copying or moving data across worksheets. It reduces transfer-related errors and ensures pasted content fully preserves user intent, even in complex multi-sheet workflows.

Improved conditional formatting logic

Conditional formatting now evaluates rules accurately and updates consistently as data changes. It eliminates rendering mismatches and ensures that formatting rules visually respond to edits in real time for a clearer, more reliable data presentation experience.

Enhanced data validation experience

Data validation has been improved to provide immediate and precise responses when invalid values are entered. This helps users avoid input mistakes and maintain data accuracy, and supports cleaner, integrity-focused data entry across all workflows.

Refined formula calculation experience

Formula processing has been upgraded with more robust error handling and behavior aligned closely with Excel for commonly used functions. These address argument-related edge cases, resulting in predictable, reliable, and consistent calculations.

Blazor Spreadsheet Editor

Optimized undo and redo performance

The undo and redo mechanism in the Blazor Spreadsheet Editor has been optimized to handle extensive formula sets more efficiently, delivering faster operations and a more responsive user experience.

The following table highlights the substantial performance improvements achieved in formula cell calculation operations compared to previous versions:

Enhanced open and save behavior

File open and save operations now align better with Excel. These preserve images, gridlines, text validation, table headers, password protection, and named ranges during round‑trip workflows—resulting in fewer visual discrepancies, data inconsistencies, and protection failures for more reliable file handling.

Improved worksheet management

Provides intuitive sheet insertion, protection enforcement, and consistent API behavior. Enhancements include sheet manipulation such as insert/delete/move/duplicate actions when protection is enabled—offering more predictable organization, enhanced workbook security, and a smoother multi-sheet experience.

Enhanced row and column insertion

Row and column insertion has been improved for more predictable, Excel-aligned results. Row heights adjust correctly, formulas and named ranges remain intact, inserted rows remain visible after filtering, images reposition smoothly, name box updates accurately, and hyperlinks stay preserved during insertions.

Visual Studio Code Extension

Syncfusion Spreadsheet Editor SDK Extension - Visual Studio Code

Syncfusion’s Spreadsheet Editor SDK Extension for Visual Studio Code empowers developers to create Blazor applications with advanced Spreadsheet Editor components—no dependency on Microsoft Office or other external tools. It includes ready-made project templates and Blazor-specific code snippets, helping new users get started quickly with pre-built, powerful spreadsheet features.

Visual Studio Extension

Syncfusion Spreadsheet Editor SDK Extension

The Spreadsheet Editor SDK Extension helps developers create applications for Blazor, WPF, or Windows Forms using the Syncfusion Spreadsheet Editor SDK components. For Blazor, a Spreadsheet Editor SDK code generator automatically inserts component code into Razor files while configuring namespaces, styles, and NuGet references. Additionally, developers can enhance existing WinForms or WPF projects by seamlessly integrating Spreadsheet Editor SDK components through intuitive item templates and reference manager options.