PivotCellBaseEventArgs.ColumnValueType Property

Gets the type of the cell’s column header.

Namespace: DevExpress.Xpf.PivotGrid

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

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 snippets (auto-collected from DevExpress Examples) contain references 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#

how-to-display-custom-text-within-data-cells-e2232/CS/DXPivotGrid_FormattingViaEvents/MainWindow.xaml.cs#L21

if (e.RowValueType != FieldValueType.GrandTotal ||
    e.ColumnValueType == FieldValueType.GrandTotal ||
    e.ColumnValueType == FieldValueType.Total) return;

how-to-customize-the-appearance-of-cells-e2517/CS/CustomAppearance/MainWindow.xaml.cs#L74

    return e.RowValueType == FieldValueType.GrandTotal ||
        e.ColumnValueType == FieldValueType.GrandTotal;
}

how-to-create-a-custom-exporter-that-supports-autorowheight-bestfit-and-fittopage-t274241/CS/WpfApplication31/PivotReportGenerator.cs#L79

    sb.AppendFormat("{0} | ", pcea.DataField);
if(pcea.ColumnValueType == FieldValueType.Value)
    sb.Remove(sb.Length - 3, 3);

how-to-format-cells-to-show-custom-display-text-t537332/CS/WpfPivotCustomCellValueDisplaytext/MainWindow.xaml.cs#L25

if (e.RowValueType == FieldValueType.Total ||
    e.ColumnValueType != FieldValueType.Total) return;
if (Convert.ToSingle(e.Value) < 2000)

VB.NET

how-to-display-custom-text-within-data-cells-e2232/VB/DXPivotGrid_FormattingViaEvents_VB/MainWindow.xaml.vb#L23

If e.RowValueType <> PivotGridValueType.GrandTotal OrElse
    e.ColumnValueType = PivotGridValueType.GrandTotal OrElse
    e.ColumnValueType = PivotGridValueType.Total Then

how-to-customize-the-appearance-of-cells-e2517/VB/CustomAppearance/MainWindow.xaml.vb#L77

Private Function IsGrandTotal(ByVal e As PivotCellBaseEventArgs) As Boolean
    Return e.RowValueType = FieldValueType.GrandTotal OrElse e.ColumnValueType = FieldValueType.GrandTotal
End Function

how-to-create-a-custom-exporter-that-supports-autorowheight-bestfit-and-fittopage-t274241/VB/WpfApplication31/PivotReportGenerator.vb#L87

End If
If pcea.ColumnValueType = FieldValueType.Value Then
    sb.Remove(sb.Length - 3, 3)

how-to-format-cells-to-show-custom-display-text-t537332/VB/VBWpfPivotCustomCellValueDisplaytext/MainWindow.xaml.vb#L21

' If the value exceeds 6000, 'High' is displayed; otherwise, 'Middle'.
If e.RowValueType = FieldValueType.Total OrElse e.ColumnValueType <> FieldValueType.Total Then
    Return