Implementing Syncfusion WPF GridControl

QueryCellInfo

When to Use This Skill

• Adding a GridControl to a WPF application (XAML or code-behind)
• Populating cells via direct assignment or the virtual

  QueryCellInfo

  event
• Configuring cell types (CheckBox, ComboBox, DateTimeEdit, FormulaCell, etc.)
• Customizing cell appearance (background, font, borders, data formats)
• Managing rows and columns (insert, remove, move, freeze, hide)
• Clipboard, undo/redo, and editing behavior
• Interactive features: drag-drop columns, cell drag-drop, resizing
• Formula cell support and the built-in formula library
• Exporting grid data to Excel; importing Excel workbooks into the grid
• Selection modes, events, and virtual mode patterns
• Performance tuning, virtualization, covered ranges, zooming
• Advanced features: comments, tooltips, printing, serialization, autofit

Documentation and Navigation Guide

Getting Started

• Required assembly references
• Adding GridControl via designer or programmatically
• Setting

  RowCount

  and

  ColumnCount

• Populating data by loop vs.

  QueryCellInfo

  virtual event
• Minimal working example

Cell Types

• 20+ built-in cell types: Header, Static, CheckBox, Button, Image, ComboBox, DropDownList, DateTimeEdit, IntegerEdit, DoubleEdit, CurrencyEdit, PercentEdit, MaskEdit, UpDownEdit, RichText, DataBoundTemplate, NestedGrid (ScrollGrid)
• Setting

  Style.CellType

  on individual cells or ranges
• ComboBox with

  ChoiceList

  vs.

  ItemsSource

• Custom cell types (CellModel + CellRenderer pattern)

Appearance and Styling

• GridStyleInfo

  class and style inheritance hierarchy
• Volatile vs. render cell styles
• Base styles (

  BaseStylesMap

  ), TableStyle, RowStyles, ColumnStyles
• Background (solid/gradient), Foreground, Font, text orientation, borders
• Numeric and DateTime format strings;

  FormatProvider

  interface

Managing Rows and Columns

• Setting row/column counts and default sizes
• Hiding and unhiding rows/columns (

  SetHidden

  )
• Freezing rows/columns; footer and header rows/columns
• Inserting, moving, and removing rows/columns at runtime
• Resize behavior and disabling resize controllers

Editing, Clipboard, and Undo/Redo

• CopyPasteOption

  flags (CopyText, CopyCellData, PasteCell, CutCell, XmlCopyPaste)

• TextDataExchange

  for custom delimiters and buffer-based operations
• Clipboard events and

  IGridCopyPaste

  custom implementation

• CommandStack

  : Undo/Redo,

  BeginTrans

  ,

  CommitTrans

  ,

  Rollback

• Creating derived commands for extended undo/redo

Interactive Features

• Column drag-drop (

  AllowDragColumns

  )
• Excel-like cell drag-drop (

  AllowDragDrop

  ,

  DataObjectConsumerOptions

  )
• Runtime row/column resizing and disabling resize controllers
• Hide/unhide rows and columns visually (

  HiddenBorderBrush

  ,

  SetHidden

  )

Formula Cells

• Enabling

  FormulaCell

  type for individual cells or the entire grid
• Built-in formula library (150+ functions: Sum, Avg, Sqrt, Pow, Cos, Sin, etc.)
• Arithmetic operators and calculation precedence
• Cross-cell references (A1 notation), named ranges
• Adding custom formula functions to the library

Excel Import and Export

• Required assemblies (

  Syncfusion.XlsIO

  ,

  Syncfusion.GridConverter.Wpf

  )
• Exporting entire or selected grid content to .xls / .xlsx
• Importing Excel workbooks: styles, formulas, conditional formatting, freeze panes, hyperlinks, comments
• Virtualized import for large workbooks

Selection and Events

• Selection modes: cell, row, column (

  AllowSelection

  flags)

• QueryCellInfo

  event pattern for virtual data loading

• PrepareRenderCell

  for view-specific overrides
• Common grid events:

  CommitCellInfo

  ,

  CurrentCellActivated

  , clipboard events,

  RowsInserted

  ,

  ColumnsMoved

  ,

  ResizingRows

  , etc.
• Working with

  GridRangeInfo

  and

  SelectedRanges

Performance and Virtualization

• Virtual mode fundamentals and

  QueryCellInfo

  best practices
• Covered ranges (

  CoveredCells

  ) and floating cells
• Zooming the grid
• High-frequency update patterns

Advanced Features

• Cell comments, input-message tips, and tooltips
• Cell layout customization (covered cells, merged ranges, autofit)
• Printing grid content
• Serialization: saving and loading grid state
• Autofit rows and columns to content

Quick Start Example

   1. Add assemblies: 
      Syncfusion.Grid.Wpf
      Syncfusion.GridCommon.Wpf,
      Syncfusion.Linq.Base, 
      Syncfusion.Shared.Wpf

  // 2. XAML — place GridControl inside a ScrollViewer
<ScrollViewer>
     <syncfusion:GridControl x:Name="gridControl" />
</ScrollViewer>

// 3. Code-behind: set size and populate
gridControl.Model.RowCount = 100;
gridControl.Model.ColumnCount = 10;

// Option A — direct assignment
for (int i = 0; i < 100; i++)
    for (int j = 0; j < 10; j++)
        gridControl.Model[i, j].CellValue = $"{i}/{j}";

// Option B — virtual mode (preferred for large data)
gridControl.QueryCellInfo += (s, e) =>
{
    if (e.Cell.RowIndex > 0 && e.Cell.ColumnIndex > 0)
        e.Style.CellValue = $"{e.Cell.RowIndex}/{e.Cell.ColumnIndex}";
};

Common Patterns

Apply a Cell Type to a Range

// Set an entire column to CheckBox
for (int i = 1; i <= gridControl.Model.RowCount; i++)
    gridControl.Model[i, 3].CellType = "CheckBox";

Alternate Row Colors via PrepareRenderCell

gridControl.PrepareRenderCell += (s, e) =>
{
    if (e.Cell.RowIndex > 0 && e.Cell.RowIndex % 2 == 0)
        e.Style.Background = Brushes.LightSkyBlue;
};

Freeze Header and Enable Formula Cells

gridControl.Model.FrozenRows = 1;
gridControl.Model.HeaderRows = 1;
gridControl.BaseStylesMap["Standard"].StyleInfo.CellType = "FormulaCell";

Export to Excel

gridControl.Model.ExportToExcel(@"Output.xlsx", ExcelVersion.Excel2007);

Key Style Properties

Model[r, c].CellType

Model[r, c].CellValue

Model[r, c].Background

Model[r, c].Foreground

Model[r, c].Font.FontSize

Model[r, c].Borders

Model[r, c].Format

"C"

"0.00"

"d"

Model.RowHeights[r]

Model.ColumnWidths[c]

Model.FrozenRows

Model.FrozenColumns

undefined