PivotCellDisplayTextEventArgs Class

Provides data for the PivotGridControl.CustomCellDisplayText event.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v18.1.dll

Declaration

C#

public class PivotCellDisplayTextEventArgs :
    PivotCellBaseEventArgs

VB.NET

Public Class PivotCellDisplayTextEventArgs
    Inherits PivotCellBaseEventArgs

Related API Members

PivotCellDisplayTextEventArgs is the data class for the following events:

• PivotGridControl.CustomCellDisplayText

Remarks

The PivotGridControl.CustomCellDisplayText event lets you customize the display text of the cells which are displayed within the Data Area.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotCellDisplayTextEventArgs class.

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#

getting-a-summary-value-for-a-previous-period-while-calculating-the-current-one-e2125/CS/Percent_Difference_From_Previous_Period_Example/Form1.cs#L26

private void pivotGridControl1_CustomCellDisplayText(object sender, PivotCellDisplayTextEventArgs e)
{

how-to-calculate-percent-and-absolute-variations-in-a-custom-direction-from-right-to-left-e2101/CS/WindowsApplication1/Form1.cs#L18

private void pivotGridControl1_CustomCellDisplayText(object sender, DevExpress.XtraPivotGrid.PivotCellDisplayTextEventArgs e)
{

how-to-differentiate-between-null-dbnull-nothing-and-0-zero-values-e3304/CS/WindowsApplication53/Form1.cs#L43

private void pivotGridControl1_CustomCellDisplayText(object sender, DevExpress.XtraPivotGrid.PivotCellDisplayTextEventArgs e)
{

how-to-implement-rank-function-in-xtrapivotgrid-e1474/CS/Form1.cs#L66

}
void pivotGridControl1_CustomCellDisplayText(object sender, PivotCellDisplayTextEventArgs e) {
    if(e.DataField != fieldRank) return;

how-to-format-cells-to-show-custom-display-text-t537319/CS/WinFormsPivotCustomCellDisplayText/Form1.cs#L18

private void pivotGridControl1_CustomCellDisplayText(object sender,
             DevExpress.XtraPivotGrid.PivotCellDisplayTextEventArgs e)
{

VB.NET

getting-a-summary-value-for-a-previous-period-while-calculating-the-current-one-e2125/VB/Percent_Difference_From_Previous_Period_Example/Form1.vb#L25

Private Sub pivotGridControl1_CustomCellDisplayText(ByVal sender As Object, ByVal e As PivotCellDisplayTextEventArgs)
    Dim pivot As PivotGridControl = TryCast(sender, PivotGridControl)

how-to-calculate-percent-and-absolute-variations-in-a-custom-direction-from-right-to-left-e2101/VB/WindowsApplication1/Form1.vb#L16

Private Sub pivotGridControl1_CustomCellDisplayText(ByVal sender As Object, ByVal e As DevExpress.XtraPivotGrid.PivotCellDisplayTextEventArgs) Handles pivotGridControl1.CustomCellDisplayText
    If e.DataField.Name = "fieldVariation" Then

how-to-differentiate-between-null-dbnull-nothing-and-0-zero-values-e3304/VB/WindowsApplication53/Form1.vb#L40

Private Sub pivotGridControl1_CustomCellDisplayText(ByVal sender As Object, ByVal e As DevExpress.XtraPivotGrid.PivotCellDisplayTextEventArgs) Handles pivotGridControl1.CustomCellDisplayText
    If Convert.ToDecimal(e.Value) = 0 AndAlso IsNullValue(e.CreateDrillDownDataSource(), e.DataField) Then

how-to-implement-rank-function-in-xtrapivotgrid-e1474/VB/Form1.vb#L71

End Sub
Private Sub pivotGridControl1_CustomCellDisplayText(ByVal sender As Object, ByVal e As PivotCellDisplayTextEventArgs) Handles pivotGridControl1.CustomCellDisplayText
    If e.DataField IsNot fieldRank Then

how-to-format-cells-to-show-custom-display-text-t537319/VB/VBWinFormsPivotCustomCellDisplayText/Form1.vb#L15

Private Sub PivotGridControl1_CustomCellDisplayText(sender As System.Object,
            e As DevExpress.XtraPivotGrid.PivotCellDisplayTextEventArgs) Handles PivotGridControl1.CustomCellDisplayText
    ' In this example, if a row total value is less than 2000, 'Low' is displayed instead.

Inheritance

Object

EventArgs

PivotCellEventArgsBase<PivotGridField, DevExpress.XtraPivotGrid.Data.PivotGridViewInfoData, PivotGridCustomTotal>

PivotCellBaseEventArgs

PivotCellDisplayTextEventArgs