PivotCellBaseEventArgs.ColumnValueType Property

Gets the type of the cell’s column header.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public FieldValueType ColumnValueType { get; }

VB.NET

Public ReadOnly Property ColumnValueType As FieldValueType

Property Value

Type	Description
FieldValueType	A FieldValueType enumeration member that specifies the type of the cell’s column header.

Available values:

Name	Description
Value	Corresponds to a field value.
Total	Corresponds to an automatic total.
GrandTotal	Corresponds to a grand total.
CustomTotal	Corresponds to a custom total.

Remarks

Use the PivotCellBaseEventArgs.RowValueType property to obtain the type of the cell’s row header.

Related GitHub Examples

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

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#

wpf-pivotgrid-hide-column-totals/CS/HowToBindToMDB/MainWindow.xaml.cs#L19

private void PivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e) {
    if (e.ColumnValueType == FieldValueType.GrandTotal
           && e.DataField == fieldDiscount)

VB.NET

wpf-pivotgrid-hide-column-totals/VB/HowToBindToMDB/MainWindow.xaml.vb#L18

Private Sub PivotGridControl1_CustomCellValue(ByVal sender As Object, ByVal e As PivotCellValueEventArgs)
    If e.ColumnValueType = FieldValueType.GrandTotal AndAlso e.DataField Is fieldDiscount Then
        e.Value = Nothing