StyleFormatConditionBase.Condition Property

Gets or sets the comparison operation used by the style condition object.

Namespace: DevExpress.XtraEditors

Assembly: DevExpress.XtraEditors.v19.2.dll

Declaration

C#

[DefaultValue(FormatConditionEnum.None)]
[XtraSerializableProperty]
public FormatConditionEnum Condition { get; set; }

VB.NET

<DefaultValue(FormatConditionEnum.None)>
<XtraSerializableProperty>
Public Property Condition As FormatConditionEnum

Property Value

Type	Default	Description
FormatConditionEnum	**None**	A FormatConditionEnum enumeration value which specifies the comparison operation.

Available values:

Name	Description
None	The style is not applied to any cell.
Equal	The style is applied to cells (or corresponding rows) whose values match the StyleFormatConditionBase.Value1 property value.
NotEqual	The style is applied to cells (or corresponding rows) whose values do not match the StyleFormatConditionBase.Value1 property value.
Between	The style is applied to cells (or corresponding rows) whose values fall into the range specified by the StyleFormatConditionBase.Value1 and StyleFormatConditionBase.Value2 properties.
NotBetween	The style is applied to cells (or corresponding rows) whose values fall outside of the range specified by the StyleFormatConditionBase.Value1 and StyleFormatConditionBase.Value2 properties.
Less	The style is applied to cells (or corresponding rows) whose values are less than that specified by the StyleFormatConditionBase.Value1 property.
Greater	The style is applied to cells (or corresponding rows) whose values are greater than that specified by the StyleFormatConditionBase.Value1 property.
GreaterOrEqual	The style is applied to cells (or corresponding rows) whose values are greater or equal to the StyleFormatConditionBase.Value1 property value.
LessOrEqual	The style is applied to cells (or corresponding rows) whose values are less or equal to the StyleFormatConditionBase.Value1 property value.
Expression	The style is applied to cells (or corresponding rows) if the StyleFormatConditionBase.Expression evaluates to true.

Example

The following example shows how to create a condition to style grid rows, and specify criteria for the condition using a string expression.

The condition’s criteria is specified by the StyleFormatConditionBase.Expression property. The expression selects rows that do not contain null in the Region field. Rows that match this condition will be painted in light pink.

The following image shows this condition applied to an XtraGrid control.

C#

using DevExpress.XtraGrid;

StyleFormatCondition condition1 = new DevExpress.XtraGrid.StyleFormatCondition();
condition1.Appearance.BackColor = Color.SeaShell;
condition1.Appearance.Options.UseBackColor = true;
condition1.Condition = FormatConditionEnum.Expression;
condition1.Expression = "[Region] != ?";
gridView1.FormatConditions.Add(condition1);

VB.NET

Imports DevExpress.XtraGrid

Dim condition1 As StyleFormatCondition = New DevExpress.XtraGrid.StyleFormatCondition()
condition1.Appearance.BackColor = Color.SeaShell
condition1.Appearance.Options.UseBackColor = True
condition1.Condition = FormatConditionEnum.Expression
condition1.Expression = "[Region] != ?"
GridView1.FormatConditions.Add(condition1)

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Condition property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-enable-users-to-design-gridview-format-conditions-at-runtime-e3717/CS/GridViewFormatCondition/CustomConditionItems.cs#L19

{
    if (fcondition.Condition != FormatConditionEnum.None)
        if (fcondition.Condition != FormatConditionEnum.Expression)

how-to-enable-users-to-design-pivotgridcontrol-format-conditions-at-runtime-t145142/CS/PivotGridFormatCondition/CustomConditionItems.cs#L20

{
    if (fcondition.Condition != FormatConditionEnum.None)
        if (fcondition.Condition != FormatConditionEnum.Expression)

how-to-implement-styleformatconditions-in-vgridcontrol-e4106/CS/StyleFormatConditionsForXtraVerticalGrid/Form1.cs#L38

condition1.Appearance.Options.UseBackColor = true;
condition1.Condition = FormatConditionEnum.Expression;
condition1.Expression = "[OrderCost] < 1000 AND [OrderCost] > 300";

how-to-serialize-treelists-formatconditions-e1984/CS/E1984/SerializableFormatCondition.cs#L70

ColumnName = style.Column == null? string.Empty:  style.Column.Name;
Condition = style.Condition;
Value1 = style.Value1;

how-to-change-appearance-priority-in-gridcontrol-e4869/CS/AppearancePrioritySample/Form1.cs#L27

condition1.Appearance.Options.UseBackColor = true;
condition1.Condition = FormatConditionEnum.Expression;
condition1.ApplyToRow = false;

VB.NET

how-to-enable-users-to-design-pivotgridcontrol-format-conditions-at-runtime-t145142/VB/PivotGridFormatCondition/CustomConditionItems.vb#L17

Public Overrides Function ToString() As String
    If Not fcondition.Condition = FormatConditionEnum.None Then
        If Not fcondition.Condition = FormatConditionEnum.Expression Then

how-to-enable-users-to-design-gridview-format-conditions-at-runtime-e3717/VB/GridViewFormatCondition/CustomConditionItems.vb#L16

Public Overrides Function ToString() As String
    If fcondition.Condition <> FormatConditionEnum.None Then
        If fcondition.Condition <> FormatConditionEnum.Expression Then

how-to-implement-styleformatconditions-in-vgridcontrol-e4106/VB/StyleFormatConditionsForXtraVerticalGrid/Form1.vb#L41

condition1.Appearance.Options.UseBackColor = True
condition1.Condition = FormatConditionEnum.Expression
condition1.Expression = "[OrderCost] < 1000 AND [OrderCost] > 300"

how-to-serialize-treelists-formatconditions-e1984/VB/E1984/SerializableFormatCondition.vb#L90

ColumnName = If(style.Column Is Nothing, String.Empty, style.Column.Name)
Condition = style.Condition
Value1 = style.Value1

how-to-change-appearance-priority-in-gridcontrol-e4869/VB/AppearancePrioritySample/Form1.vb#L28

condition1.Appearance.Options.UseBackColor = True
condition1.Condition = FormatConditionEnum.Expression
condition1.ApplyToRow = False