Essential Studio® for Grid SDK - v35.1.37 Release Notes
DataGrid
.NET MAUI
Features
- Provided support for animating rows during row drag-and-drop interactions.
- Provided support for customizing editor selection behavior in editable columns.
- Provided support for organizing and spanning cells across multiple row levels (Multi-Row Column Layout).
- Provided support for shrink-wrapping all rows and columns.
- Provided support for customizing the scroll orientation of the
DataGridScrollView. - Provided support for detecting filter icons and edit elements through
AutomationID. - Provided support for programmatically navigating to the next or previous row and column from the current cell position.
- Provided support for dynamically loading items to the context menus.
-
#FB75302- Provided support for customizing the maximum number of digits inDataGridNumericColumn. -
#FB75512- Provided support for changing the display style (full-screen or popup) of the UI Filtering Popup Menu.
Bug Fixes
-
#FB75706- TheSfDataGridnow applies filtering to date columns when a date is selected using the DatePicker in the UI Filtering Popup Menu.
Flutter
Bug Fixes
-
#FB75703- TheSfDataGridnow filters records correctly when searching and deselecting values in the UI Checkbox Filter Popup Menu.
Angular
Features
- Introduced Advanced Filtering support, enabling users to perform complex filtering operations through an integrated Query Builder displayed in a dialog. This provides an intuitive way to create and manage multiple filter conditions with ease. Explore the demo here.
- Added Formula Cell support, allowing users to define formulas and perform calculations directly within Grid cells, similar to spreadsheet applications. This enhancement simplifies data computation and improves productivity. Explore the demo here.
- Introduced a Row Number column feature that automatically displays sequential numbers for data rows, making it easier to identify, reference, and navigate records. Explore the demo here.
- Added support for customizing Header Row Height, enabling greater control over header presentation and allowing header rows to better accommodate varying content and layout requirements.
- Introduced Empty Sticky Row support, ensuring the empty row remains visible during horizontal scrolling. This enhancement provides a more consistent and seamless user experience when working with wide datasets. Explore the demo here.
ASP.NET Core
Features
- Introduced Advanced Filtering support, enabling users to perform complex filtering operations through an integrated Query Builder displayed in a dialog. This provides an intuitive way to create and manage multiple filter conditions with ease. Explore the demo here.
- Added Formula Cell support, allowing users to define formulas and perform calculations directly within Grid cells, similar to spreadsheet applications. This enhancement simplifies data computation and improves productivity. Explore the demo here.
- Introduced a Row Number column feature that automatically displays sequential numbers for data rows, making it easier to identify, reference, and navigate records. Explore the demo here.
- Added support for customizing Header Row Height, enabling greater control over header presentation and allowing header rows to better accommodate varying content and layout requirements.
- Introduced Empty Sticky Row support, ensuring the empty row remains visible during horizontal scrolling. This enhancement provides a more consistent and seamless user experience when working with wide datasets. Explore the demo here.
ASP.NET MVC
Features
- Introduced Advanced Filtering support, enabling users to perform complex filtering operations through an integrated Query Builder displayed in a dialog. This provides an intuitive way to create and manage multiple filter conditions with ease. Explore the demo here.
- Added Formula Cell support, allowing users to define formulas and perform calculations directly within Grid cells, similar to spreadsheet applications. This enhancement simplifies data computation and improves productivity. Explore the demo here.
- Introduced a Row Number column feature that automatically displays sequential numbers for data rows, making it easier to identify, reference, and navigate records. Explore the demo here.
- Added support for customizing Header Row Height, enabling greater control over header presentation and allowing header rows to better accommodate varying content and layout requirements.
- Introduced Empty Sticky Row support, ensuring the empty row remains visible during horizontal scrolling. This enhancement provides a more consistent and seamless user experience when working with wide datasets. Explore the demo here.
Blazor
Features
-
FB64437- Provided support for advanced Find and Highlight functionality with match navigation, active match tracking, match count display, and programmatic APIs for an enhanced search experience. Explore the demo here.
Code Example:
<SfGrid TValue="Order" DataSource="@Orders" AllowPaging="true" AllowFiltering="true" Toolbar="@(new List<string> { "Find" })">
<GridFindSettings PlaceholderText="Find items" ></GridFindSettings>
<GridColumns>
<GridColumn Field="@nameof(Order.OrderID)" HeaderText="Order ID" Width="120" />
<GridColumn Field="@nameof(Order.CustomerID)" HeaderText="Customer ID" Width="150" />
<GridColumn Field="@nameof(Order.Freight)" HeaderText="Freight" Format="C2" Width="120" AllowSearchHighlight="false" />
</GridColumns>
</SfGrid>
-
FB32154,FB33110- Provided support forUndoandRedooperations in Batch Edit mode for edit, add, delete, paste, and autofill actions. Explore the demo here.
Code Example:
<SfGrid TValue="Order" DataSource="@Orders" Toolbar="@(new List<string> { "Add", "Delete", "Update", "Cancel", "Undo", "Redo" })">
<GridEditSettings AllowAdding="true" AllowDeleting="true" AllowEditing="true" Mode="EditMode.Batch" EnableUndoRedo="true"></GridEditSettings>
<GridColumns>
<GridColumn Field="@nameof(Order.OrderID)" HeaderText="Order ID" IsPrimaryKey="true" Width="120" />
<GridColumn Field="@nameof(Order.CustomerID)" HeaderText="Customer ID" Width="150" />
<GridColumn Field="@nameof(Order.Freight)" HeaderText="Freight" Format="C2" Width="120" />
</GridColumns>
</SfGrid>
-
#I843261,#I832261,FB73741- Provided support for Excel-like Cell Editing, enabling direct value editing within cells while preserving keyboard navigation, validation, event handling, and data binding. Explore the demo here.
Code Example:
<SfGrid TValue="Order" DataSource="@Orders" Toolbar="@(new List<string>() { "Add", "Delete", "Update", "Cancel" })">
<GridEditSettings AllowAdding="true" AllowDeleting="true" AllowEditing="true" Mode="EditMode.Cell" AllowEditOnKeyPress="true" EnterKeyDirection="EnterKeyDirection.NextRow" />
<GridSelectionSettings Type="Syncfusion.Blazor.Grids.SelectionType.Single" Mode="Syncfusion.Blazor.Grids.SelectionMode.Cell"/>
<GridColumns>
<GridColumn Field="@nameof(Order.OrderID)" HeaderText="Order ID" IsPrimaryKey="true" Width="120" />
<GridColumn Field="@nameof(Order.CustomerID)" HeaderText="Customer ID" Width="150" />
<GridColumn Field="@nameof(Order.Freight)" HeaderText="Freight" Format="C2" Width="120" />
</GridColumns>
</SfGrid>
- Provided support for event-driven data binding through the
OnDataLoadevent, enabling custom data operations on DataGrid requests without requiring SfDataManager or Custom Adaptors. Explore the demo here.
Code Example:
<SfGrid @ref="Grid" DataSource="@Orders">
<GridEvents OnDataLoad="HandleDataLoad" TValue="Order"></GridEvents>
</SfGrid>
@code {
SfGrid<Order>? Grid;
public List<Order> Orders { get; set; }
private async Task HandleDataLoad(GridLoadEventArgs<Order> args)
{
args.Result = Orders;
}
}
-
#I830533,#I830849,FB73282- Provided support forPrintingandPrintedevents to customize print operations with custom data sources, header and footer templates, and full print lifecycle handling. Explore the demo here. -
#I818077,FB73035- Provided support for Excel-style clipboard paste operations, including Smart Paste and Matrix Paste. -
#I577715,I580635- Provided theAfterAutoFillCellevent, which is triggered after each cell is updated through AutoFill and exposes the updated cell value, row data, and column information. -
I791199,FB71617- Provided support forPage UpandPage Downkeyboard navigation in Row Virtualization for faster scrolling across large datasets.
JavaScript
Features
- Introduced Advanced Filtering support, enabling users to perform complex filtering operations through an integrated Query Builder displayed in a dialog. This provides an intuitive way to create and manage multiple filter conditions with ease. Explore the demo here.
- Added Formula Cell support, allowing users to define formulas and perform calculations directly within Grid cells, similar to spreadsheet applications. This enhancement simplifies data computation and improves productivity. Explore the demo here.
- Introduced a Row Number column feature that automatically displays sequential numbers for data rows, making it easier to identify, reference, and navigate records. Explore the demo here.
- Added support for customizing Header Row Height, enabling greater control over header presentation and allowing header rows to better accommodate varying content and layout requirements.
- Introduced Empty Sticky Row support, ensuring the empty row remains visible during horizontal scrolling. This enhancement provides a more consistent and seamless user experience when working with wide datasets. Explore the demo here.
React
Features
- Introduced Advanced Filtering support, enabling users to perform complex filtering operations through an integrated Query Builder displayed in a dialog. This provides an intuitive way to create and manage multiple filter conditions with ease. Explore the demo here.
- Added Formula Cell support, allowing users to define formulas and perform calculations directly within Grid cells, similar to spreadsheet applications. This enhancement simplifies data computation and improves productivity. Explore the demo here.
- Introduced a Row Number column feature that automatically displays sequential numbers for data rows, making it easier to identify, reference, and navigate records. Explore the demo here.
- Added support for customizing Header Row Height, enabling greater control over header presentation and allowing header rows to better accommodate varying content and layout requirements.
- Introduced Empty Sticky Row support, ensuring the empty row remains visible during horizontal scrolling. This enhancement provides a more consistent and seamless user experience when working with wide datasets. Explore the demo here.
TypeScript
Features
- Introduced Advanced Filtering support, enabling users to perform complex filtering operations through an integrated Query Builder displayed in a dialog. This provides an intuitive way to create and manage multiple filter conditions with ease. Explore the demo here.
- Added Formula Cell support, allowing users to define formulas and perform calculations directly within Grid cells, similar to spreadsheet applications. This enhancement simplifies data computation and improves productivity. Explore the demo here.
- Introduced a Row Number column feature that automatically displays sequential numbers for data rows, making it easier to identify, reference, and navigate records. Explore the demo here.
- Added support for customizing Header Row Height, enabling greater control over header presentation and allowing header rows to better accommodate varying content and layout requirements.
- Introduced Empty Sticky Row support, ensuring the empty row remains visible during horizontal scrolling. This enhancement provides a more consistent and seamless user experience when working with wide datasets. Explore the demo here.
Vue
Features
- Introduced Advanced Filtering support, enabling users to perform complex filtering operations through an integrated Query Builder displayed in a dialog. This provides an intuitive way to create and manage multiple filter conditions with ease. Explore the demo here.
- Added Formula Cell support, allowing users to define formulas and perform calculations directly within Grid cells, similar to spreadsheet applications. This enhancement simplifies data computation and improves productivity. Explore the demo here.
- Introduced a Row Number column feature that automatically displays sequential numbers for data rows, making it easier to identify, reference, and navigate records. Explore the demo here.
- Added support for customizing Header Row Height, enabling greater control over header presentation and allowing header rows to better accommodate varying content and layout requirements.
- Introduced Empty Sticky Row support, ensuring the empty row remains visible during horizontal scrolling. This enhancement provides a more consistent and seamless user experience when working with wide datasets. Explore the demo here.
WPF
Features
-
#I407152,#I530873,#I857867,#I858348,#I224869,#F149818- Added support for interactive row resizing, enabling users to dynamically adjust row heights. - Introduced Filter Editor support, allowing users to create advanced filter criteria.
- Added support for a default sort order using the new
InitialSortDirectionproperty, allowing users to set the sort direction at the grid or column level, so that sorting always starts in the specified ascending or descending order. -
#I584931- Added support for character casing inGridTextColumn, enabling automatic conversion of user-entered text to uppercase or lowercase during editing.
WinUI
Features
-
#I851794,#I852517,#I852855- Added support for displaying the Clear Icon during editing inGridTimeColumn. -
#I604367- Added support for a default sort order using the newInitialSortDirectionproperty, allowing users to set the sort direction at the grid or column level, so that sorting always starts in the specified ascending or descending order.
Pivot Table
Features
-
#I745091- Improved memory usage and overall performance when processing large volumes of data in the Pivot Table. - Added support for Web MCP (Model Context Protocol), enabling AI agents and external applications to interact with Pivot Table reports through a standardized tool-based interface. This support allows programmatic operations such as report configuration, field management, filtering, sorting, drill operations, formatting, chart interactions, and exporting.
Breaking Changes
- As part of API naming improvements, the
repeatItemLabelsproperty has been deprecated. Its functionality is now provided by therepeatRowHeaderLabelsproperty, ensuring backward compatibility while promoting a clearer and more consistent API.
| Deprecated Property | Recommended Property |
|---|---|
repeatItemLabels |
repeatRowHeaderLabels |
SmartDataGrid
WPF
Features
- Introduced AI-powered exporting support, allowing users to export data to Excel or PDF using natural language prompts.
TreeGrid
.NET MAUI New
Features
The Syncfusion® .NET MAUI now includes the SfTreeGrid control, a hierarchical data visualization component designed to display self-relational and nested data in a tabular format. This control enables users to efficiently manage hierarchical datasets through an intuitive and customizable user interface, with support for expanding and collapsing nodes, sorting, filtering, and other advanced data operations.
Features
- Provided support for binding self-relational and nested collections to the
ItemsSource. - Provided support for both auto-generated and manually defined columns.
- Provided built-in support for text, numeric, date, checkbox, and template columns.
- Provided support for auto-fitting columns based on content with various customization options.
- Provided support for expanding and collapsing nodes both interactively and programmatically.
- Provided support for single-column and multi-column sorting, including custom sorting.
- Provided support for freezing columns in both header and footer regions.
- Provided support for selecting single and multiple rows programmatically and through user interaction.
- Provided support for applying programmatic filtering with different filter levels.
- Provided support for applying implicit and explicit styles to rows and columns, along with built-in theming support.
Angular
Features
- Introduced DOM virtualization support to improve rendering performance by minimizing the number of DOM elements created during scrolling, making the Tree Grid more efficient when handling large datasets. Explore the demo here.
- Improved the Checkbox Column feature by introducing
Self,Hierarchy, andFilteredHierarchyselection modes, enabling flexible selection behavior for hierarchical data and preserving selection states across filtering operations. Explore the demo here.
ASP.NET Core
Features
- Introduced DOM virtualization support to improve rendering performance by minimizing the number of DOM elements created during scrolling, making the Tree Grid more efficient when handling large datasets. Explore the demo here.
- Improved the Checkbox Column feature by introducing
Self,Hierarchy, andFilteredHierarchyselection modes, enabling flexible selection behavior for hierarchical data and preserving selection states across filtering operations. Explore the demo here.
ASP.NET MVC
Features
- Introduced DOM virtualization support to improve rendering performance by minimizing the number of DOM elements created during scrolling, making the Tree Grid more efficient when handling large datasets. Explore the demo here.
- Improved the Checkbox Column feature by introducing
Self,Hierarchy, andFilteredHierarchyselection modes, enabling flexible selection behavior for hierarchical data and preserving selection states across filtering operations. Explore the demo here.
JavaScript
Features
- Introduced DOM virtualization support to improve rendering performance by minimizing the number of DOM elements created during scrolling, making the Tree Grid more efficient when handling large datasets. Explore the demo here.
- Improved the Checkbox Column feature by introducing
Self,Hierarchy, andFilteredHierarchyselection modes, enabling flexible selection behavior for hierarchical data and preserving selection states across filtering operations. Explore the demo here.
React
Features
- Introduced DOM virtualization support to improve rendering performance by minimizing the number of DOM elements created during scrolling, making the Tree Grid more efficient when handling large datasets. Explore the demo here.
- Improved the Checkbox Column feature by introducing
Self,Hierarchy, andFilteredHierarchyselection modes, enabling flexible selection behavior for hierarchical data and preserving selection states across filtering operations. Explore the demo here.
TypeScript
Features
- Introduced DOM virtualization support to improve rendering performance by minimizing the number of DOM elements created during scrolling, making the Tree Grid more efficient when handling large datasets. Explore the demo here.
- Improved the Checkbox Column feature by introducing
Self,Hierarchy, andFilteredHierarchyselection modes, enabling flexible selection behavior for hierarchical data and preserving selection states across filtering operations. Explore the demo here.
Vue
Features
- Introduced DOM virtualization support to improve rendering performance by minimizing the number of DOM elements created during scrolling, making the Tree Grid more efficient when handling large datasets. Explore the demo here.
- Improved the Checkbox Column feature by introducing
Self,Hierarchy, andFilteredHierarchyselection modes, enabling flexible selection behavior for hierarchical data and preserving selection states across filtering operations. Explore the demo here.
WPF
Features
- Added support for a default sort order using the new
InitialSortDirectionproperty, allowing users to set the sort direction at the grid or column level, so that sorting always starts in the specified ascending or descending order.
WinUI
Features
- Added support for a default sort order using the new
InitialSortDirectionproperty, allowing users to set the sort direction at the grid or column level, so that sorting always starts in the specified ascending or descending order. - Added support for displaying the Clear Icon during editing in
TreeGridTimeColumn.
Test Results
| Component Name | Platform | Test Cases | Passed | Failed | Remarks |
|---|---|---|---|---|---|
| DataGrid | Blazor | 11841 | 11841 | 0 | All Passed |
| Data Grid | Web(Javascript, Angular, React, Vue, ASP.NET Core & MVC) | 4579 | 4579 | 0 | All Passed |
| DataGrid | WPF | 5240 | 5240 | 0 | All Passed |
| DataGrid | WinUI | 582 | 582 | 0 | All Passed |
| DataGrid | Windows Forms | 966 | 966 | 0 | All Passed |
| DataGrid | .NET MAUI | 6128 | 6128 | 0 | All Passed |
| DataGrid | Flutter | 5739 | 5739 | 0 | All Passed |
| TreeGrid | Blazor | 8169 | 8169 | 0 | All Passed |
| TreeGrid | Web(Javascript, Angular, React, Vue, ASP.NET Core & MVC) | 5395 | 5395 | 0 | All Passed |
| TreeGrid | WPF | 3249 | 3249 | 0 | All Passed |
| TreeGrid | WinUI | 241 | 241 | 0 | All Passed |
| Smart DataGrid | .NET MAUI | 96 | 96 | 0 | All Passed |