UniqueDuplicateRuleFormatCondition Class

Assembly : DevExpress.Xpf.Grid.v25.2.Core.dll

NuGet Package : DevExpress.Wpf.Grid.Core

Declaration

C#
VB.NET

csharp

public class UniqueDuplicateRuleFormatCondition :
    ExpressionConditionBase

Public Class UniqueDuplicateRuleFormatCondition
    Inherits ExpressionConditionBase

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:
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:

XAML

xaml

<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:

C#
VB.NET

csharp

var cityFormatCondition = new UniqueDuplicateRuleFormatCondition() {
   ValueRule = UniqueDuplicateRuleFormatCondition.Unique,
   FieldName = "City",
   PredefinedFormatName = "GreenFillWithDarkGreenText"
};
view.FormatConditions.Add(cityFormatCondition);

Dim cityFormatCondition = New UniqueDuplicateRuleFormatCondition() With {
   .ValueRule = UniqueDuplicateRuleFormatCondition.Unique,
   .FieldName = "City",
   .PredefinedFormatName = "GreenFillWithDarkGreenText"
}
view.FormatConditions.Add(cityFormatCondition)

Inheritance

Object DispatcherObject DependencyObject FormatConditionBase ExpressionConditionBase UniqueDuplicateRuleFormatCondition