PivotGridControl.FormatConditions Property

Gets the collection of style format rules for a pivot grid control.

Namespace: DevExpress.Xpf.PivotGrid

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

Declaration

public FormatConditionCollection FormatConditions { get; }
Public ReadOnly Property FormatConditions As FormatConditionCollection

Property Value

Type Description
FormatConditionCollection

A FormatConditionCollection object which is the collection of format conditions.

Remarks

The PivotGridControl.FormatConditions property allows you to apply conditional formatting, which involves applying appearances to data cells that match the specified rules. This property provides access to the collection of FormatConditionCollection objects containing style format conditions and permits managing this collection.

To apply conditional formatting, create a new instance of the required format type, specify its parameters and add it to the FormatConditionCollection collection using the FormatConditionCollection property.

To specify a data field (measure) to which value conditional formatting is applied, use the FormatConditionBase.MeasureName property. Use the field's PivotGridField.Name property value to refer to the field.

You can apply the format to all data cells or a specified row and column intersection.

NOTE

Note that the PivotGridControl.CustomCellValue event does not affect format conditions defined using the FormatConditions property.

See Also