We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Syncfusion Feedback


Windows Forms Grid Control Excel Like Features

Overview

The WinForms Grid control provides rich, Excel-like features to provide a quality out-of-the-box user experience. These features include cell merging, OLE drag-and-drop, cell comment, fill and copy series, freeze panes, floating cells, format cell dialog, find-and-replace dialog, and split plane.

Cell merging

Dynamically merge data in adjacent cells and present that data in a single cell. You can also merge data based on content by writing your own custom logic.

cell merging in winforms grid control

OLE drag-and-drop

OLE drag-and-drop between two WinForms grids allows users to copy or move content or complete style information. Supports dragging columns or ranges of cells as in Excel.

ole drag and drop in winforms grid control

Cell comment

  • An intuitive comment in a cell helps users to show additional information for that cell.
  • Excel-like comment tip.
  • Users can customize the appearance of cell comments as required.

winforms grid control shows cell comments

Fill and copy series

  • An intuitive UI to choose the fill or copy series operation.
  • Users can easily fill or copy a series or pattern of values as in Excel. It is easy to copy the content of a cell to neighboring cells in any direction.

winforms grid control shows copy fill series option

Formula bar

  • View and edit formulas and values in the current cell using “GridAwareTextBox” control.
  • Support auto-suggestion and multi-line text editing.
  • Customize the appearance of the formula bar.

formula bar support in winforms grid control

Freeze panes

  • Users can freeze rows and columns at the top, bottom, left, and right positions, similar to Excel.
  • Horizontal and vertical scrolling can be performed, except on fixed columns and rows.
  • Customize the freeze pane line appearance as required.

freeze panes in winforms grid control

Floating cells

The WinForms grid provides support to float cell content to adjacent cells when the cell content exceeds cell size, allowing users to view the complete content of a cell.

floating cells in winforms grid control

Format cell dialog

Excel-like format cells dialog that aids in dynamic cell formatting. It provides options such as font, number, background, and alignment. With this feature available, you can format numerous grid cells with ease

winforms grid control shows format cell dialog

Find-and-replace dialog

  • Users can find and replace text using an Excel-like dialog. This includes built-in options such as Find Next, Replace, Replace All, Find All, and more.
  • Highlight the searched text to easily discover found content.

winforms grid control shows find and replace dialog

Split pane

Display multiple views of the grid by splitting the grid view.

winforms grid control shows split pane

95+ WINDOWS FORMS CONTROLS

Scroll up icon