UniqueDuplicateRuleFormatCondition Class
A Unique-Duplicate conditional format.
Namespace: DevExpress.Xpf.Grid
Assembly: DevExpress.Xpf.Grid.v21.2.Core.dll
NuGet Package: DevExpress.Wpf.Grid.Core
Declaration
Remarks
The Unique-Duplicate conditional format allows you to format cells whose values are unique or duplicate.
The image below shows a grid column whose City cells are green if their values are unique.
To create the Unique-Duplicate conditional format in code, create the UniqueDuplicateRuleFormatCondition class instance and specify the following settings:
- Specify the comparison logic by setting the UniqueDuplicateRuleFormatCondition.Rule property.
- Use the FormatConditionBase.FieldName property to specify the column’s field name to which to apply the conditional format.
Specify the target cells’ formatting in one of the following ways:
- Specify the predefined format using the FormatConditionBase.PredefinedFormatName property.
- Set the custom format using the ExpressionConditionBase.Format property.
- Set a selective expression using the UniqueDuplicateRuleFormatCondition.SelectiveExpression property if it is necessary to select data records to which the rule should be applied.
- Add the resulting UniqueDuplicateRuleFormatCondition instance to the TableView.FormatConditions (or TreeListView.FormatConditions) collection.
The following code sample illustrates how to define a conditional format in markup:
<dxg:TableView.FormatConditions>
<dxg:UniqueDuplicateRuleFormatCondition Rule="Unique" FieldName="City" PredefinedFormatName="GreenFillWithDarkGreenText" />
</dxg:TableView.FormatConditions>
The code sample below illustrates how to define the same conditional format in code-behind:
var cityFormatCondition = new UniqueDuplicateRuleFormatCondition() {
ValueRule = UniqueDuplicateRuleFormatCondition.Unique,
FieldName = "City",
PredefinedFormatName = "GreenFillWithDarkGreenText"
};
view.FormatConditions.Add(cityFormatCondition);