Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

FormatConditionBase.Expression Property

Gets or sets the expression used to apply the corresponding conditional formatting rule. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v24.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

#Declaration

public string Expression { get; set; }

#Property Value

Type Description
String

A String value that specifies the expression used to apply the conditional formatting rule.

#Remarks

Use the Expression property to specify a condition for expression based conditional formats (ExpressionConditionBase class descendants). Refer to the Conditional Formatting topic to learn more about conditions.

The Expressions Overview topic contains a list of operators, functions and constants you can use in the expressions.

The code sample below illustrates how to define a conditional format with an expression in markup.

<dxpg:PivotGridControl.FormatConditions>
    <dxpg:FormatCondition ColumnName="Category" MeasureName="Category" Expression="Contains([Category], 'ai')" PredefinedFormatName="LightRedFillWithDarkRedText"/>
</dxpg:PivotGridControl.FormatConditions>

The code sample below illustrates how to define the same conditional format in code-behind.

var symbolFormatCondition = new FormatCondition() {
    Expression = "Contains([Category], 'ai')",
    RowName = "Category",
    MeasureName = "Category",
    PredefinedFormatName = "LightRedFillWithDarkRedText"
};
pivotGridControl1.FormatConditions.Add(symbolFormatCondition);

For indicator-type conditional formats (IndicatorFormatConditionBase class descendants) you can use the Expression property to specify a complex custom expression that returns a value based on several parameters (e.g., several columns in a row).

See Also