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.2.dll

NuGet Package : DevExpress.Win.Navigation

Declaration

• C#
• VB.NET

public static DefaultBoolean AggregateConditionsUseAllListSourceRows

Public Shared AggregateConditionsUseAllListSourceRows As DefaultBoolean

Field Value

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.

See Also

FormatConditionRuleBase Class

FormatConditionRuleBase Members

DevExpress.XtraEditors Namespace