How to set the formatting for a range of cells in WinForms GridControl?

1 min read

Formatting range of cells

You can use the GridControl’s ChangeCells method by passing a GridRangeInfo object to it to change the appearance of a range of cells.

To set the Interior and TextColor for a range of cells, you can use the ChangeCells method and QueryCellInfo Event.

Using ChangeCells method

// formatting is done by using the GridStyleInfo
GridStyleInfo style = new GridStyleInfo();
style.TextColor = Color.Green;
style.Text = "Welcome";
//interior property is used to change the backcolor
style.Interior = new BrushInfo(Color.Yellow);
//Range of cell can be selected using GridRangeInfo
gridControl1.ChangeCells(GridRangeInfo.Cells(1, 1, 4, 5), style);

'formatting is done by using the GridStyleInfo
Dim style As New GridStyleInfo()
style.TextColor = Color.Red
style.Text = "Welcome"
' interior property is used to change the backcolor
style.Interior = New BrushInfo(Color.Yellow)
' Range of cell can be selected using GridRangeInfo
gridControl1.ChangeCells(GridRangeInfo.Cells(1, 1, 4, 5), style)

Using QueryCellInfo Event

void gridControl1_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e)
{
 if (e.RowIndex > 0 && e.RowIndex < 5 && e.ColIndex > 0 && e.ColIndex < 6)
 {
  e.Style.Text = "welcome";
  //interior property is used to change the backcolor
  e.Style.Interior = new BrushInfo(Color.Yellow);
  e.Style.TextColor = Color.Green;
 }
}

Private Sub gridControl1_QueryCellInfo(ByVal sender As Object, ByVal e As GridQueryCellInfoEventArgs)
 If e.RowIndex > 0 AndAlso e.RowIndex < 5 AndAlso e.ColIndex > 0 AndAlso                        e.ColIndex < 6 Then
  e.Style.Text = "welcome"
  ' interior property is used to change the backcolor
  e.Style.Interior = New BrushInfo(Color.Yellow)
  e.Style.TextColor = Color.Green
 End If
End Sub

After applying the properties, the Grid cell is displayed as follows.

Formatting range of cells