Appearance in WPF GridControl

You can customize the appearance of the grid to the cell-level using our Grid properties.

Cell Styles

The EssentialGrid’s cell style architecture plays an integral role in almost every aspect of Essential Grid. The display system hosts a powerful and complete Styles architecture. Settings can be specified at the cell level or at higher levels using parent styles that are referred to as Base Styles. Base Styles can affect a groups of cells. Cell level settings override any higher-level settings and enable easy customization to cell level. With this initial version, Syncfusion’s core focus has been on the underlying architecture for displaying cells with virtualized cell editors to enable good performance characteristics.

Following are the two cell styles available:

Volatile Cell Styles

QueryCellInfo will be raised the first time you access the contents of a cell with a call to Grid.Model[rowIndex, columnIndex] or when the grid calls this indexer internally before painting cells. The indexer returns an object of type GridStyleInfo. After querying the cell contents they remain cached in a volatile cache that holds weak references to the cell styles. This ensures that this data is available for reuse when needed. At the same time it does not stand in the way of the garbage collector if memory needs to be freed. Once a style gets garbage collected it will be removed from the volatile cache. You can manually force QueryCellInfo to be called again when you call GridControl.InvalidateCell(cell) or GridModel.VolatileCellStyles.Clear(cell).

Render Cell Styles

Prior to display of a cell, the PrepareRenderCell event is raised. This event is not raised from the Model. Instead it is raised from the GridControlBase directly. This has the advantage that if you want multiple grids to display the same Model, individual grids can override the cell contents individually.

// view specific cell color
grid.PrepareRenderCell += new GridPrepareRenderCellEventHandler(grid_PrepareRenderCell);
void grid_PrepareRenderCell(object sender, GridPrepareRenderCellEventArgs e)
{

    if (e.Cell.RowIndex > 0 && e.Cell.ColumnIndex > 0)
    {

        if (e.Cell.RowIndex % 2 == 0)
            e.Style.Background = Brushes.LightSkyBlue;
    }
}

PrepareRenderCell is used to initialize the so called RenderStyles. RenderStyles are of type GridRenderStyleInfo and derive from GridStyleInfo. GridRenderStyleInfo are tied to a GridControlBase instance. The render style provides additional properties to obtain access to the associated GridControl , CellRenderer and the underlying ModelStyle instance from the volatile cells cache described earlier.

To access the render style for a cell you can call GridControlBase.GetRenderStyleInfo.

Render Styles are created only for the cells that are visible and will be discarded the moment a cell is scrolled out of view (with the exception being if the current cell is scrolled out of view; they are retained in such case alone).

In contrast, Volatile Cell Styles from the GridModel are often also created for cells outside the viewable area and can stay in the cache even when a cell is scrolled out of view.

A basic understanding of this layered cell style architecture will help you understand and learn grid behaviors. This is particularly important when you are trying to modify or extend some existing functionality.

GridStyleInfo class Overview

An EssentialGrid can be thought of as a rectangular table of grid cells. Each cell will contain distinct information and that can be displayed independently of other cells. Essential Grid uses GridStyleInfo object to store state information about the appearance of a grid cell. So attributes like the type of font, background color, cell value and cell type are all reflected in a single GridStyleInfo object.

Every cell in a grid may have such an object associated with it, giving the individual cell its unique appearance. It is not necessary that all cells should require fully populated GridStyleInfo objects stored in memory to function. And, for a given GridStyleInfo object, not all possible properties need to be populated in the object. So for example, a particular cell may or may not have a stored GridStyleInfo object, and if it does, this GridStyleInfo object may, or may not, contain a particular property such as font.

In general, when Essential Grid needs a cell’s state information, usually to draw the cell, it uses an inheritance process to generate a GridStyleInfo from several parent styles. These parent styles are GridStyleInfo objects associated with particular grid entities:

  • TableStyle is a single GridStyleInfo object associated with the entire grid.
  • RowStyles are GridStyleInfo objects associated with each row.
  • ColumnStyles are GridStyleInfo objects associated with each column.

These three GridStyleInfo objects may not be fully populated, meaning that some properties may not have been set. However, there is a fourth parent style referred to as the StandardStyle, which is a fully populated style object comprising settings for every property.

Hence, when Essential Grid needs to generate a composite GridStyleInfo object for a particular cell, it first looks at any property that may be specifically set in the GridStyleInfo (if one exists) for the current cell. If properties are not set in the cell-specific GridStyleInfo object, Essential Grid will then pick up the RowStyles for the cell and will populate any property that was explicitly set in the RowStyle and not set in the cell-specific GridStyleInfo object. After adding unset properties to the composite GridStyleInfo from the RowStyle, it does the same for the ColumnStyle, the TableStyle and finally the StandardStyle. In this manner, Essential Grid comes up with a fully populated composite GridStyleInfo object to use.

The following graphic illustrates the effect of using the GridStyleInfo inheritance to come up with the appearance of a cell. Even though the BackColor property is set in each of the table style, RowStyle and ColumnStyle objects, it is the cell specific style that determines the background color of cell.

Change background color of specific cell or row and column in WPF GridControl

Style Properties

Property settings for individual/groups of cells are stored in a GridStyleInfo property. The style allows you to set properties such as background, cell value, and cell type for a particular cell.

Essential Grid for WPF holds two different style caches that depend upon how the cell style is being used:

Volatile style-cache-Is maintained for styles populated through calls made to the QueryCellInfo (the virtual grid event that provides the cell values to the grid on demand) event. This volatile style-cache uses weak references to interact with the .NET Framework’s Garbage collection to ensure optimal memory use. These styles remain cached as long as they are not garbage collected by the Framework.

Render style-cache-Is maintained for styles needed to draw the grid and are disposed of as soon as the cell scrolls out of view.
The combination of these two caches makes Essential Grid for WPF highly efficient. This section elaborates on important style properties.

Base Styles

Base Styles, otherwise named as Parent Styles, define the style information for individual cell groups such that all the cells belonging to a group will share the same Base style. On changing the common base style, the dependent cells styles also get updated automatically.

Following code snippet illustrates the effect of various Base styles.

//Defines the base styles named PinkStyle and GreenStyle.
GridBaseStyle baseStyle1 = new GridBaseStyle();
baseStyle1.Name = "PinkStyle";
baseStyle1.StyleInfo.Background = Brushes.LightPink;
baseStyle1.StyleInfo.Foreground = Brushes.Maroon;

GridBaseStyle baseStyle2 = new GridBaseStyle();
baseStyle2.Name = "GreenStyle";
baseStyle2.StyleInfo.Background = Brushes.PaleGreen;
baseStyle2.StyleInfo.Foreground = Brushes.Olive;

//Add the above styles to the grid base styles collection.
grid.Model.BaseStylesMap.Add(baseStyle1);
grid.Model.BaseStylesMap.Add(baseStyle2);

//Applying base styles.

for (int i = 1; i <= grid.Model.RowCount; i++)
{

   for (int j = 1; j <= grid.Model.ColumnCount; j++)
   {

        if(j ==2)
           grid.Model[i, j].BaseStyle = "PinkStyle";

        else
           grid.Model[i,j].BaseStyle = "GreenStyle";
   }
}

Output

The code above displays the following output:

Change the background color of each columns in WPF GridControl

Background

The Background property specifies a background brush for the grid cell. The cell’s background can be painted with either a solid brush or a gradient brush.

NOTE

Gradient-A gradient brush uses two colors. These colors merge to create a transition or fading effect. * Solid-A solid brush is equipped with only one color.

Setting Background Brush Type

this.grid.Model[2, 1].Background = Brushes.Aquamarine;
this.grid.Model[2, 2].Background = Brushes.Violet ;
this.grid.Model[2, 3].Background = Brushes.LawnGreen;
this.grid.Model[2, 4].Background = Brushes.LavenderBlush  ;
this.grid.Model[2, 5].Background = Brushes.CadetBlue ;
this.grid.Model[2, 6].Background = Brushes.LemonChiffon;
this.grid.Model[3, 1].Background = GetLinerBrush();
this.grid.Model[3, 2].Background = new LinearGradientBrush(Colors.Turquoise, Colors.White, 90.0);
this.grid.Model[3, 3].Background = new LinearGradientBrush(Colors.Firebrick, Colors.Orange, 90.0);
this.grid.Model[3, 4].Background = new LinearGradientBrush(Colors.CornflowerBlue, Colors.White, 0.0);
this.grid.Model[3, 5].Background = new LinearGradientBrush(Colors.Olive, Colors.PaleGreen, 0.0);
this.grid.Model[3, 6].Background = new LinearGradientBrush(Colors.Gold, Colors.Yellow, 90.0);

Output

The following output is generated using the code above.

Applied gradient background color in specific cells in WPF GridControl

Visual properties

The visual aspects of the cell text can be controlled by the following properties.

Property Name Description
Text Holds the text to be displayed in the cell
Foreground Specifies text color
Font Controls the font properties for the text in the cell
Orientation Determines the angle of rotation of the text

1.Setting Text, Foreground and Font Properties

//Setting text, foreground and fonts
this.grid.Model[6, 1].Font.FontSize = 10;
this.grid.Model[6, 1].Text = "The quick brown fox jumps over the lazy dog";
this.grid.Model[6, 1].Foreground = Brushes.Gray;

this.grid.Model[7, 1].Font.FontSize = 12;
this.grid.Model[7, 1].Text = "The quick brown fox jumps over the lazy dog";
this.grid.Model[7, 1].Foreground = Brushes.Red;

this.grid.Model[8, 1].Font.FontSize = 14;
this.grid.Model[8, 1].Text = "The quick brown fox jumps over the lazy dog";
this.grid.Model[8, 1].Foreground = Brushes.Blue;

this.grid.Model[9, 1].Font.FontSize = 16;
this.grid.RowHeights[9] = 30d;
this.grid.Model[9, 1].Text = "The quick brown fox jumps over the lazy dog";
this.grid.Model[9, 1].Foreground = Brushes.Green;

//Setting font weights
this.grid.Model[6, 5].Font.FontWeight = FontWeights.Bold;
this.grid.Model[6, 5].HorizontalAlignment = HorizontalAlignment.Center;
this.grid.Model[6, 5].CellValue = "Font weight is Bold";

this.grid.Model[7, 5].Font.FontStyle  = FontStyles.Italic;
this.grid.Model[7, 5].HorizontalAlignment = HorizontalAlignment.Center;
this.grid.Model[7, 5].CellValue = "Font style is Italic";

this.grid.Model[8, 5].Font.FontStyle = FontStyles.Normal;
this.grid.Model[8, 5].HorizontalAlignment = HorizontalAlignment.Center;
this.grid.Model[8, 5].CellValue = "Font style is Normal";

Output

The following output is generated using the code above.

Change the font style and color in WPF GridControl

2.Setting cell orientation

this.grid.Model[12, 1].Font.Orientation = 45;
this.grid.Model[12, 1].CellValue = "Angle 45";
this.grid.Model[12, 1].HorizontalAlignment = HorizontalAlignment.Center;
this.grid.Model[12, 1].VerticalAlignment = VerticalAlignment.Center;

this.grid.Model[12, 2].Font.Orientation = 90;
this.grid.Model[12, 2].CellValue = "Angle 90";
this.grid.Model[12, 2].HorizontalAlignment = HorizontalAlignment.Center;
this.grid.Model[12, 2].VerticalAlignment = VerticalAlignment.Center;

this.grid.Model[12, 3].Font.Orientation = 180;
this.grid.Model[12, 3].CellValue = "Angle 180";
this.grid.Model[12, 3].HorizontalAlignment = HorizontalAlignment.Center;
this.grid.Model[12, 3].VerticalAlignment = VerticalAlignment.Center;

this.grid.Model[12, 4].Font.Orientation = 270;
this.grid.Model[12, 4].CellValue = "Angle 270";
this.grid.Model[12, 4].HorizontalAlignment = HorizontalAlignment.Center;
this.grid.Model[12, 4].VerticalAlignment = VerticalAlignment.Center;

this.grid.Model[12, 5].Font.Orientation = 320;
this.grid.Model[12, 5].CellValue = "Angle 320";
this.grid.Model[12, 5].HorizontalAlignment = HorizontalAlignment.Center;
this.grid.Model[12, 5].VerticalAlignment = VerticalAlignment.Center;
this.grid.Model.RowHeights[12] = 50;

Output

The following output is generated using the code above.

Change the font alignment in WPF GridControl

Borders

Cell borders can be customized to have different color, thickness and style. It is possible to have different border styles for top, bottom, left and right borders for the same cell.

Setting Borders

this.grid.Model[15, 1].Borders.Bottom = new Pen(Brushes.Blue, 1);
this.grid.Model[15, 1].Borders.Top = new Pen(Brushes.Red, 1);
this.grid.Model[15, 1].Borders.Right = new Pen(Brushes.Purple,3);
this.grid.Model[15, 1].Borders.Left = new Pen(Brushes.RoyalBlue,1);

this.grid.Model[15, 2].Borders.Bottom = new Pen(Brushes.Turquoise, 1);
this.grid.Model[15, 2].Borders.Bottom.Thickness = 5;
this.grid.Model[15, 2].Borders.Top = new Pen(Brushes.LawnGreen, 1);
this.grid.Model[15, 2].Borders.Top.DashCap = PenLineCap.Round;
this.grid.Model[15, 2].Borders.Top.Thickness = 5;
this.grid.Model[15, 2].Borders.Right = new Pen(Brushes.SteelBlue, 3);
this.grid.Model[15, 2].Borders.Right.Thickness = 5;

this.grid.Model[15, 3].Borders.Bottom = new Pen(Brushes.IndianRed, 2);
this.grid.Model[15, 3].Borders.Bottom.DashStyle = DashStyles.DashDot;
this.grid.Model[15, 3].Borders.Top = new Pen(Brushes.Indigo, 2);
this.grid.Model[15, 3].Borders.Top.DashStyle = DashStyles.DashDot;
this.grid.Model[15, 3].Borders.Right = new Pen(Brushes.Gray, 3);
this.grid.Model[15, 3].Borders.Right.DashStyle = DashStyles.DashDot;

this.grid.Model[15, 4].Borders.Bottom = new Pen(Brushes.HotPink, 2);
this.grid.Model[15, 4].Borders.Top = new Pen(Brushes.DeepSkyBlue, 2);
this.grid.Model[15, 4].Borders.Right = new Pen(Brushes.Magenta, 3);
this.grid.Model[15, 4].Borders.Bottom.DashStyle = DashStyles.Dash;
this.grid.Model[15, 4].Borders.Top.DashStyle = DashStyles.Dash;
this.grid.Model[15, 4].Borders.Right.DashStyle = DashStyles.Dash;

this.grid.Model[15, 5].Borders.Bottom = new Pen(Brushes.Maroon, 2);
this.grid.Model[15, 5].Borders.Top = new Pen(Brushes.Olive, 2);
this.grid.Model[15, 5].Borders.Right = new Pen(Brushes.CadetBlue, 2);
this.grid.Model[15, 5].Borders.Bottom.DashStyle = DashStyles.Dot;
this.grid.Model[15, 5].Borders.Top.DashStyle = DashStyles.Dot;
this.grid.Model[15, 5].Borders.Right.DashStyle = DashStyles.Dot;

this.grid.Model[15, 6].Borders.Bottom = new Pen(Brushes.Chocolate, 4);
this.grid.Model[15, 6].Borders.Top = new Pen(Brushes.Crimson, 4);
this.grid.Model[15, 6].Borders.Right = new Pen(Brushes.DarkGoldenrod, 4);
this.grid.Model[15, 6].Borders.Bottom.DashStyle = DashStyles.DashDotDot;
this.grid.Model[15, 6].Borders.Top.DashStyle = DashStyles.DashDotDot;
this.grid.Model[15, 6].Borders.Right.DashStyle = DashStyles.DashDotDot;

Output

The following output is generated using the code above.

Change the border style in WPF GridControl

Data Formats

Essential Grid allows the user to specify the format string for Text and DateTime cell values. The following table lists the various format strings supported.

Text Formats Example with Cell Value = Math.PI
0.00 3.14
C $3.14
0.00;(0.00) 3.14
###0.##% 314.16%
#0.#E+00 3L4E-01
10:##,##0.# 10.00,003.1
DateTime Example with Cell Value = DateTime.Now
d 8/10/2009
D Monday, August 10, 2009
f Monday, August 10, 2009 7.00 AM
dddd Monday, 10 August 2009
t 7.00 AM
s 2009-08-10T07:00:15

1.Setting text format

//Setting Text formats            
int rowIndex = 3;
int colIndex = 1;
GridModel model =  this.grid.Model; 

foreach (string format in new string[] 
{
	"0.00",
	"C",
	"0.00;(0.00)",
	"###0.##%",
	"#0.#E+00",
    "10:##,##0.#"
})
{
model[rowIndex - 1, colIndex].Text = format;
model[rowIndex  , colIndex].Format = format;
model[rowIndex , colIndex].CellValue = Math.PI;
model[rowIndex , colIndex].CellValueType = typeof(double);
rowIndex += 3;
}

2.Setting DateTime format

//Setting DateTime formats            
rowIndex = 2;
colIndex = 3;

foreach (string format in new string[] 
{
	"d",
	"D",
	"f",
	"dddd, dd MMMM yyyy",
	"t",
	"s"
})
{
	model[rowIndex - 1, colIndex].Text = format;
	grid.Model.ColumnWidths[colIndex] = 150d;
	model[rowIndex, colIndex].Format = format;
	model[rowIndex, colIndex].CellValue = DateTime.Now;
	model[rowIndex, colIndex].CellValueType = typeof(DateTime);
	rowIndex += 3;
}

Output

The following output is generated using the code above.

Data formats in WPF GridControl

FormatProvider

The FormatProvider in GridStyleInfo is used to format the display text in the cells. The FormatProvider property supplies an object that provides formatting information for formatting operations. The formatting operations convert the value of a type to its string representation. The FormatProvider property allows the user to control the formatting of a particular cell.

Format using FormatProvider Property

In the Grid control, you can set the FormatProvider property as shown in the following code snippet.

this.grid.Model[row, col].CellValue = Math.PI;
this.grid.Model[row, col].Format = "{0:ES}";
this.grid.Model[row, col].FormatProvider = new CustomNumberFormat();

this.grid.Model[row, col].CellValue = Math.PI;
this.grid.Model[row, col].Format = "{0:US}";
this.grid.Model[row, col].FormatProvider = new CustomNumberFormat();
Me.grid.Model(row, col).CellValue = Math.PI
Me.grid.Model(row, col).Format = "{0:ES}"
Me.grid.Model(row, col).FormatProvider = new CustomNumberFormat()

Me.grid.Model(row, col).CellValue = Math.PI
Me.grid.Model(row, col).Format = "{0:US}"
Me.grid.Model(row, col).FormatProvider = new CustomNumberFormat()

The following example illustrates the use of a class that implements the IFormatProvider interface.

public class CustomNumberFormat : IFormatProvider, ICustomFormatter
{
    private const int ACCT_LENGTH = 6;
    public object GetFormat(Type formatType)
    {
        if (formatType == typeof(ICustomFormatter))
            return this;
        else
            return null;
    }
    public string Format(string fmt, object arg, IFormatProvider formatProvider)
    {
        // Provide default formatting, if arg is not double.
        if (arg.GetType() != typeof(double))
            return HandleOtherFormats(fmt, arg);
        // Provide default formatting for unsupported format strings.
        string ufmt = fmt.ToUpper(CultureInfo.InvariantCulture);
        if (!(ufmt == "US" || ufmt == "ES"))
            return HandleOtherFormats(fmt, arg);
        // Convert argument to a string.
        string result = arg.ToString();
        if (ufmt == "ES")
        {
            CultureInfo esESCulture = CultureInfo.GetCultureInfo("es-ES");
            result = Convert.ToString(arg, esESCulture);
        }
        else
        {
            CultureInfo esUSCulture = CultureInfo.GetCultureInfo("es-US");
            result = Convert.ToString(arg, esUSCulture);
        }
        // If number is less than 6 characters, pad with leading zeroes.
        if (result.Length < ACCT_LENGTH)
            result = result.PadRight(ACCT_LENGTH, '0');
        // If number is more than 6 characters, truncate to 6 characters.
        if (result.Length > ACCT_LENGTH)
            result = result.Substring(0, ACCT_LENGTH);
            return result;
    }
    private string HandleOtherFormats(string format, object arg)
    {

        if (arg is IFormattable)
            return ((IFormattable)arg).ToString(format, CultureInfo.CurrentCulture);
        else if (arg != null)
            return arg.ToString();
        else
            return String.Empty;
    }
}

The CustomNumberFormat class converts the double value to string based on the culture specified in the format property.

The output is shown in the following screenshot:

Applied formatting in specific cells in WPF GridControl