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 in DataGridNumericColumn.
  • #FB75512 - Provided support for changing the display style (full-screen or popup) of the UI Filtering Popup Menu.

Bug Fixes

  • #FB75706 - The SfDataGrid now applies filtering to date columns when a date is selected using the DatePicker in the UI Filtering Popup Menu.

Flutter

Bug Fixes

  • #FB75703 - The SfDataGrid now 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 for Undo and Redo operations 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 OnDataLoad event, 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 for Printing and Printed events 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 the AfterAutoFillCell event, 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 for Page Up and Page Down keyboard 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 InitialSortDirection property, 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 in GridTextColumn, 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 in GridTimeColumn.
  • #I604367 - Added support for a default sort order using the new InitialSortDirection property, 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 repeatItemLabels property has been deprecated. Its functionality is now provided by the repeatRowHeaderLabels property, 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, and FilteredHierarchy selection 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, and FilteredHierarchy selection 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, and FilteredHierarchy selection 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, and FilteredHierarchy selection 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, and FilteredHierarchy selection 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, and FilteredHierarchy selection 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, and FilteredHierarchy selection 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 InitialSortDirection property, 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 InitialSortDirection property, 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