How to: Apply a Data Bar Format to a Column

• Apr 19, 2019

Important

This documentation topic describes legacy technology. We no longer develop new functionality for the GridControl and suggest that you use the new DataGridView control instead.

This example demonstrates how to apply a data bar format to the Total column in a GridControl. Data bars fill column cells proportionally based on cell values relative to other cells. A longer bar corresponds to a higher value, and a shorter bar corresponds to a lower value.

1. Create a new DataBarFormatCondition class instance.
2. Set this object’s FormatConditionBase.FieldName property to Total. This column provides values to test against the formatting rule and the specified format will be applied to this column.
3. Assign one of the predefined bar styles to the FormatConditionBase.PredefinedFormatName property. All available format names are listed in the Predefined Format Names document.
4. To apply a conditional formatting rule represented by the created DataBarFormatCondition object, add this object to the GridControl.FormatConditions collection.

C#

using DevExpress.Mobile.DataGrid;
// ...

DataBarFormatCondition condition = new DataBarFormatCondition();
condition.FieldName = "Total";
condition.PredefinedFormatName = "LightBlueGradientDataBar";

grid.FormatConditions.Add (condition);