The Excel-like WPF grid control is a cell-oriented control for displaying tabular data and can be customized down to the cell level. It does not make any assumptions regarding the structure of the data.It can be used in a virtual manner, where the data is provided on demand in real time, or it can be used in a manner where the cell grid maintains the data within its own internal structures.Its rich feature set includes editing, cell styling, data formatting, covered cells, various cell editors, clipboard operations, formulas, Excel-like selection, frozen rows and columns, importing and more.
Load millions of rows and columns in less time. Also supports on-demand data loading.
Provides smooth scrolling experience even with millions of rows and columns.
Provides support to virtually import Excel workbooks.
Users can populate the grid either by using the Grid control’s internal data storage or provide data on demand through virtual mode.
Users can populate the grid by storing the cell style in its internal storage. The cell style exposes various properties for storing cell appearance and data information of a cell.
Provides support for on-demand data population where the grid does not store cell styles in its internal storage. This means the grid can be loaded with millions of rows and columns instantly.
The Grid control provides cell styles for setting cell data and customizing each cell’s appearance such as its font, background, foreground, borders, orientation, margins, padding, alignment, and more. Cell style can be applied to any range of cells, rows, columns, and tables. Support is also provided for formatting the data.
Provides support for editing the cells with wide range of cell types and events to save the changes to external data source.
Provides support to validate a cell and display any error information and dialogs. The error information and dialogs can be customized as required.
Built-in support for clipboard operations such as copy, cut, and paste. The copied content can be customized. Support is also provided to copy and paste with styles preserved between two grids.
Built-in support for multilevel undo and redo operations for any changes made in the grid. There is no limit to the number of undo and redo operations. Also provides support to group multiple actions as a single transaction.
Built-in support for various cell editors to deal with different types of data for a better editing experience. Users can place any control inside a cell using the DataTemplate cell type. The Grid control provides a pluggable cell renderer architecture for easily implementing custom cell types without compromising on performance. The supported cell types are:
The Grid control supports Excel-like formulas for calculating the value of a cell. It comes with an extensive formula function library that supports more than 400 built-in formulas covering a broad range of business scenarios. It supports cross-sheet references and named ranges just like Excel, and also allows users to add custom functions.
Provides support to merge a range of cells into a single cell.
OLE drag and drop between two grids allows users to copy or move complete style information. Also supports dragging columns or ranges of cells like Excel.
Support to add comment tips like in Excel. Comment tips can be set to all corners of cells and can also be customized.
Allows users to easily fill or copy a series or pattern of values and formats into neighboring cells in any direction.
Provides support to freeze rows at the top and bottom of the grid, and columns at the left and right.
Provides support to display input messages when users interact with cells.
Provides support to float cell content to adjacent cells when the content exceeds the cell size.
Support for selecting a range of cells, rows, or columns with customizable selection color. Excel-like selection frames and current cell selection can also be enabled.
Provides support for cell-level context menus. Context menu items can be modified at runtime.
Provides support to resize, hide, and unhide rows and columns.
Supports both accelerated scrolling and deferred scrolling. Common scroll bars can be used for two or more grids.
Grid contents can be zoomed in and out as required.
Tooltip support can be enabled for each cell. The display information can be customized.
Built-in support for the Print and Print Preview dialogs with numerous customization options.
Provides support to serialize grid data to binary and XML formats and vice versa.
Compatible with Coded UI and UFT (formerly QTP) automation tools.