FormatConditionRuleBase.AggregateConditionsUseAllListSourceRows Field

Specifies whether to always calculate boundary values in Conditional Formatting rules based on all data source records.

Namespace: DevExpress.XtraEditors

Assembly: DevExpress.XtraEditors.v25.1.dll

NuGet Package: DevExpress.Win.Navigation

Declaration

C#

public static DefaultBoolean AggregateConditionsUseAllListSourceRows

VB.NET

Public Shared AggregateConditionsUseAllListSourceRows As DefaultBoolean

Field Value

Type	Description
DefaultBoolean	A DefaultBoolean value that specifies whether to always calculate boundary values in Conditional Formatting rules based on all data source records.

Remarks

AggregateConditionsUseAllListSourceRows affects the following Conditional Formatting rules:

• FormatConditionRuleIconSet
• FormatConditionRule2ColorScale
• FormatConditionRule3ColorScale
• FormatConditionRuleAboveBelowAverage
• FormatConditionRuleTopBottom
• FormatConditionRuleUniqueDuplicate

If AggregateConditionsUseAllListSourceRows is enabled, boundary values are calculated based on all data source records regardless of the underlying filter (like in Microsoft Excel). Otherwise, filtered records are not included into calculation algorithms.

The following image shows the difference in highlighted values (above average). Values range from 0 to 10, and a “Value>4” filter is applied:

Note

If you disable AggregateConditionsUseAllListSourceRows, Conditional Formatting filters may generate unexpected results.