Your account has not been activated. Click here to get a new activation Email.
Unfortunately, activation email could not send to your email. Please try again.

GridControl

The cell-oriented GridControl is a very efficient display engine for tabular data that can be customized down to the cell level. It does not make any assumptions on 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 GridControl maintains the data within its own internal structures. Its rich feature set includes functionalities like cell styling, data formatting, covered cells, various cell editors, clipboard operations, undo redo, formulas, Excel like selection, frozen rows & columns, importing and exporting.


High Performance

Instant Loading

Ability to load even millions of rows and columns in lesser time. And also, supports on-demand loading of data.

Smooth Scrolling

Provides smooth scrolling experience even with millions of rows and columns.

Virtual Importing

Provides support to virtually import the Excel workbook.


Data Population

User can use either GridControl’s internal data storage or provide the data on demand through virtual mode for populating the grid.

Internal Storage

User can populate the grid by storing the cell style in its internal storage. Cell style exposes various properties for storing cell appearance and data information of cell.

Virtual Mode

Provides support for on-demand population where the gird does not store cell style in its internal storage. This means grid can be loaded with millions of rows and columns instantly.


Appearance and formatting

GridControl provides cell style for setting cell data and customize each individual cell appearance such as font, background, foreground, borders, orientation, margin & padding and alignment etc. Cell style can be applied to any range of cells, rows, columns and table. Also it provides support to format the data.


Editing

Provides support for editing the cells with wide range of cell types and events to save the changes to external data source.

Data Validation

Provides support to validate the cell and displays the error information & dialogs. The error information and dialogs can be customized as required.

Clipboard Operations

Built-in support for clipboard operations such as Copy, Cut and Paste. The copied content can be customized. And also provides support to copy paste with styles between two grids.

Undo & Redo

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/redo operations. Also provides support to group multiple actions as single transaction.


Cell Types

Built-in support for various cell editors to deal with different types of data for better editing experience. User can place any control inside the cell using the DataTemplate cell type. GridControl provides a pluggable cell renderer architecture for easily implementing custom cell types without compromising on performance. Below are the supported cell types,

  • Static cell
  • TextBox cell
  • CheckBox cell
  • Button cell
  • Image cell
  • ComboBox cell
  • DataTemplate cell
  • DropDown cell
  • Integer Edit cell
  • Double Edit cell
  • Currency cell
  • Date Time cell
  • Mask Edit cell
  • Percent Edit cell
  • Nested Grid cell
  • RichTextBox cell
  • Text Image cell
  • Up Down Edit cell
  • Hyperlink cell

Formulas

GridControl provides support for Excel like formulas to calculate 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 like in excel and also allows the user to add custom functions.


Excel Like Features

Covered Cells

Provides support to merge the range of cells into a single cell.

Drag and Drop

OLE Drag & Drop between two grids allows users to copy or move complete style information. Also supports dragging columns or range of cells like Excel.

Cell Comments

Support to add comment tip like in excel. Comment tip can be set to all corners of cells and also can be customized.

Drag Fill

Allows the user to easily fill or copy a series or pattern of values and formats into neighboring cells in any direction.

Freeze Panes

Provides support to freeze the rows at top and bottom, columns at left and right.

Input Message

Provides support to display input message when user interact with cell.

Floating Cells

Provides support to float the cell content to adjacent cell when the content exceeds the cell size.


Interactive Features

Selection

Support for selecting a range of cells, rows or columns with customizable selection color. Excel like selection frames and current cell can also be enabled.

Context Menu

Provides support for cell level context menu. Context menu items can be modified at runtime.

Resize

Provides support to resize, hide and unhide the rows and columns.

Scrolling

Supports both accelerated scrolling and deferred scrolling. Ability to have common scroll bars for two or more grids.

Zooming

Grid contents can be zoomed in and out as required

Tooltip

Tooltip support can be enabled for each cells. The display information can be customized.


Graphic Cells

  • Provides support to load the Graphical elements into the grid to visually represent the data like Excel.
  • Some predefined Graphic Cell types are Charts, Sparklines, Pictures and Textboxes.


Importing and Exporting

Import and Export

  • Provides support for importing the Microsoft Excel file with same look and feel.
  • Rich set of options available for exporting data to Microsoft Excel file formats, PDF and CSV.

Printing

Built-in support for the Print and Print Preview dialogs with numerous customization options.


Serialization

Provides supports to serialize grid data to Binary, XML formats and vice versa.


UI Automation

Compatible with Coded UI and UFT (formerly QTP) automation tools.


You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.