XRPivotGrid.PrintCell Event

Enables you to render a different content for individual data cells.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v23.2.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

C#

public event EventHandler<CustomExportCellEventArgs> PrintCell

VB.NET

Public Event PrintCell As EventHandler(Of CustomExportCellEventArgs)

Event Data

The PrintCell event's data class is DevExpress.XtraReports.UI.PivotGrid.CustomExportCellEventArgs.

Remarks

The PrintCell event is raised for each cell when the XRPivotGrid is being printed. You can handle this event to change the cell’s appearance and contents in a printed document.

Example

This example demonstrates how to change the appearance of Pivot Grid cells based on their values, using the XRPivotGrid.PrintCell event.

To learn more, see Look and Feel.

C#

using System;
using System.Drawing;
using DevExpress.XtraReports.UI;
// ...

private void xrPivotGrid1_PrintCell(object sender, 
    CustomExportCellEventArgs e) {
    if (e.ColumnIndex == 1 && Convert.ToDouble(e.Value) > 50) 
        e.Appearance.BackColor = Color.AliceBlue;
}

VB.NET

Imports System
Imports System.Drawing
Imports DevExpress.XtraReports.UI
' ...

Private Sub xrPivotGrid1_PrintCell(ByVal sender As Object, _ 
ByVal e As CustomExportCellEventArgs) Handles xrPivotGrid1.PrintCell
    If e.ColumnIndex = 1 AndAlso Convert.ToDouble(e.Value) > 50 Then
        e.Appearance.BackColor = Color.AliceBlue
    End If
End Sub

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the PrintCell event.

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#

winforms-dashboard-pivot-custom-export/CS/WinformsExport/Form1.cs#L43

if(pivot4 != null) {
    pivot4.PrintCell += PivotPrintCell;
    pivot4.PrintFieldValue += PivotPrintFieldValue;

VB.NET

winforms-dashboard-pivot-custom-export/VB/WinFormsExport/Form1.vb#L45

If pivot4 IsNot Nothing Then
    AddHandler pivot4.PrintCell, AddressOf PivotPrintCell
    AddHandler pivot4.PrintFieldValue, AddressOf PivotPrintFieldValue