CustomizePivotCellEventArgs.Formatting Property

Gets or sets the object that defines the cell’s format (font, alignment, background color, format string, etc.)

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Packages: DevExpress.WindowsDesktop.Wpf.PivotGrid, DevExpress.Wpf.PivotGrid

Declaration

C#

public XlFormattingObject Formatting { get; set; }

VB.NET

Public Property Formatting As XlFormattingObject

Property Value

Type	Description
XlFormattingObject	The XlFormattingObject object that defines the cell’s format.

Remarks

The following code snippet changes the background color of the “Category Name” column in the output document:

C#

//...
void op_CustomizeCell(CustomizePivotCellEventArgs e){
      if (e.ValueItemInfo != null && e.ValueItemInfo.Field == fieldCategoryName) 
      {
          e.Formatting.BackColor = Color.AliceBlue;
          e.Handled = true;
      } 
  }

VB.NET

'...
Private Sub op_CustomizeCell(ByVal e As CustomizePivotCellEventArgs)
      If e.ValueItemInfo IsNot Nothing AndAlso e.ValueItemInfo.Field = fieldCategoryName Then
          e.Formatting.BackColor = Color.AliceBlue
          e.Handled = True
      End If
End Sub