Syncfusion Essential Studio Spreadsheet Editor SDK 2026 Volume 2 (34.1.29)
Released: Jul 6, 2026
Actualizaciones en 2026 Volume 2 (34.1.29)
Características
- Web Spreadsheet Editor
- Smart Spreadsheet:
- Spreadsheet Editor includes a built-in AI Assist that lets users perform operations using natural language through a chat-based interface. With prompt suggestions and a resizable panel, users can efficiently interact with the Spreadsheet and take actions.
- AI-powered actions, such as editing, formatting, data analysis, and visualization, are performed directly in the Spreadsheet with full undo and redo support. When a prompt is submitted, the AI service interprets the intent and applies the corresponding actions instantly, with results displayed in the UI and confirmed in the AI Assist panel.
- Subscripts and superscripts - Subscript and superscript formatting enables the styling of specific portions of text within a cell. Directly format selected text during cell editing, enhancing clarity and improving the readability of complex data.
- Suspend and resume UI refresh - Suspend and resume refresh API options improve UI rendering efficiency during bulk operations. Previously, the UI refreshed after every action, such as editing cells, which could impact performance when executing multiple operations in sequence. With this enhancement, UI updates can be temporarily paused using the suspendRefresh() method. Multiple programmatic changes can be performed efficiently, followed by a single refresh triggered with the resumeRefresh() method. This approach minimizes unnecessary re-rendering and significantly improves performance, especially during initialization, data processing, or large-scale updates.
- Blazor Spreadsheet Editor
- Ribbon customization - Improved the spreadsheet experience with advanced ribbon customization. Add new tabs, create custom groups, and use tailored controls that align the interface with specific workflows. Existing tabs, groups, and items can be enhanced by inserting, rearranging, or removing elements while maintaining a consistent, intuitive user experience. These capabilities are supported by a simple, developer-friendly API that enables seamless configuration and integration.
- Conditional formatting - Enhance data visualization by applying conditional formatting to selected ranges to highlight trends, outliers, and key values. Use color scales, data bars, and icon sets to deliver intuitive, engaging visuals, and ensure formatting updates dynamically as data changes to maintain accuracy.
- Export to XLS, CSV, and PDF - Export spreadsheets in XLS, CSV, and PDF formats for seamless sharing and cross-platform compatibility while preserving data accuracy and formatting. PDF exports offer customizable layout options, including settings such as fitting the sheet onto a single page and adjusting orientation. These capabilities are available through both the UI and a simple, developer-friendly API.
- Auto aggregation - Perform quick calculations in selected ranges using the spreadsheet footer's aggregation feature. It provides instant access to sums, averages, counts, and more without writing formulas. As data changes, results update automatically.
- Enhanced API support - The capabilities of spreadsheet applications have been extended with powerful new API methods and properties. These additions enable developers to perform advanced operations, customize user interactions, and configure spreadsheet behavior.
- API methods:
- AddDefinedNameAsync: Adds named ranges to the workbook with configurable scopes.
- CalculateAsync: Triggers immediate formula recalculation at the workbook, worksheet, or sheet index level.
- ClearAsync: Clears contents, formatting, hyperlinks, or all aspects from specified ranges.
- DisableContextMenuItems: Disables specified items in the context menu while keeping them visible.
- EnableContextMenuItems: Enables specified items in the context menu for user interaction.
- GetDisplayText: Returns the formatted, user-visible text representation of a cell based on its address.
- OpenAsync: Opens spreadsheet files from streams asynchronously, supporting multiple formats.
- ProtectSheetAsync: Applies protection to worksheets in the workbook.
- Redo: Reapplies the most recently undone action.
- RemoveContextMenuItems: Removes specified items from the context menu entirely.
- RemoveDefinedNameAsync: Removes existing named ranges from the workbook.
- SetColumnWidthAsync: Sets the width of specified columns programmatically.
- SetRowHeightAsync: Sets the height of specified rows programmatically.
- Undo: Reverts the most recent action in the spreadsheet.
- UnprotectSheetAsync: Removes protection from worksheets in the workbook.
- API properties:
- AllowDelete: Enables or restricts sheet deletion functionality.
- AllowInsert: Enables or restricts row, column, and sheet insertion functionality.
- AllowOpen: Enables or disables the ability to open spreadsheets via UI and programmatic methods.
- AllowSave: Enables or disables the ability to save or download spreadsheets.
- AllowTextWrap: Controls text wrapping behavior within cells.
- AllowUndoRedo: Enables or disables undo and redo functionalities.
- CalculationMode: Determines how and when formulas are recalculated, supporting automatic and manual modes.
- EnableKeyboardNavigation: Enables or disables keyboard navigation within the spreadsheet.
- EnableKeyboardShortcut: Enables or disables keyboard shortcuts for common actions.
- ShowAggregate: Shows or hides aggregate values in the footer section of the spreadsheet.
- ShowSheetTabs: Shows or hides the sheet tabs for navigating among sheets and managing sheets via UI.