PivotCellValueEventArgs Class

Provides data for the PivotGridControl.CustomCellValue event.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v18.1.dll

Declaration

C#

public class PivotCellValueEventArgs :
    PivotCellBaseEventArgs

VB.NET

Public Class PivotCellValueEventArgs
    Inherits PivotCellBaseEventArgs

Related API Members

The following members accept/return PivotCellValueEventArgs objects:

• PivotCustomChartDataSourceDataEventArgs.CellInfo

Related API Members

PivotCellValueEventArgs is the data class for the following events:

• PivotGridControl.CustomCellValue

Remarks

The PivotGridControl.CustomCellValue event fires for each cell, allowing you to replace cell values with custom ones.

Use the event parameter’s PivotCellValueEventArgs.Value property, to specify a new value for the cell.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotCellValueEventArgs 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#

how-to-calculate-multiple-custom-totals-with-summarytype-set-to-custom-e3815/CS/XtraPivotGrid_MultipleCustomTotals/Form1.cs#L59

// provides an appropriate Custom Total value.
private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e) {

how-to-implement-sorting-for-a-custom-cell-value-e2149/CS/ImplementSortingforaCustomCellValue/Form1.cs#L39

private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e) {
    if(e.DataField == fieldProductAmount1 && e.Value != null) {

how-to-access-other-cell-value-while-calculating-the-current-cell-e1110/CS/WinAppCustomCellValue/Form1.cs#L28

private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e)
{

Reporting_how-to-change-the-names-of-the-controls-added-in-the-end-user-designer-e4463/CS/WindowsFormsApplication1/XtraReport1.cs#L49

private void xrPivotGrid1_CustomCellValue(object sender, DevExpress.XtraPivotGrid.PivotCellValueEventArgs e) {

how-to-access-api-of-underlying-controls-in-the-winforms-viewer-t197114/CS/Dashboard_ControlAccess/Form1.cs#L23

void pivotGridControl_CustomCellValue(object sender, PivotCellValueEventArgs e) {
    if (e.Value != null && (decimal)e.Value < 2000)

VB.NET

how-to-calculate-multiple-custom-totals-with-summarytype-set-to-custom-e3815/VB/XtraPivotGrid_MultipleCustomTotals/Form1.vb#L61

Private Sub pivotGridControl1_CustomCellValue(ByVal sender As Object, _
                                              ByVal e As PivotCellValueEventArgs) _
                                          Handles pivotGridControl1.CustomCellValue

how-to-implement-sorting-for-a-custom-cell-value-e2149/VB/ImplementSortingforaCustomCellValue/Form1.vb#L41

Private Sub pivotGridControl1_CustomCellValue(ByVal sender As Object, ByVal e As PivotCellValueEventArgs) Handles pivotGridControl1.CustomCellValue
    If e.DataField Is fieldProductAmount1 AndAlso e.Value IsNot Nothing Then

how-to-access-other-cell-value-while-calculating-the-current-cell-e1110/VB/WinAppCustomCellValue/Form1.vb#L21

Private Sub pivotGridControl1_CustomCellValue(ByVal sender As Object, ByVal e As PivotCellValueEventArgs) Handles pivotGridControl1.CustomCellValue
    ' Calculates the 'Percent' field values.

Reporting_how-to-change-the-names-of-the-controls-added-in-the-end-user-designer-e4463/VB/WindowsFormsApplication1/XtraReport1.vb#L45

Private Sub xrPivotGrid1_CustomCellValue(ByVal sender As Object, ByVal e As DevExpress.XtraPivotGrid.PivotCellValueEventArgs)

how-to-access-api-of-underlying-controls-in-the-winforms-viewer-t197114/VB/Dashboard_ControlAccess/Form1.vb#L27

Private Sub pivotGridControl_CustomCellValue(ByVal sender As Object, _
                             ByVal e As PivotCellValueEventArgs)
    If e.Value IsNot Nothing AndAlso CDec(e.Value) < 2000 Then

Inheritance

Object

EventArgs

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

PivotCellBaseEventArgs

PivotCellValueEventArgs