corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotcelleventargsbase-3-586568e0.md
Gets the type of row that contains the processed cell.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
public PivotGridValueType RowValueType { get; }
Public ReadOnly Property RowValueType As PivotGridValueType
| Type | Description |
|---|---|
| PivotGridValueType |
A PivotGridValueType enumeration value that specifies the type of row in which the processed cell resides.
|
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.
|
Use the RowValueType property to identify whether the processed cell resides within the grand total row, total row, etc.
This example demonstrates how to handle the CustomCellValue event to hide field row totals and grand totals. The total values remain hidden when you expand or collapse field values.
View Example: Pivot Grid for WinForms - Hide Row Totals
private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e) {
if (e.DataField == fieldLowLevel) {
PivotGridField lastLevelField =
pivotGridControl1.GetFieldsByArea(PivotArea.RowArea).Last();
if(e.RowValueType == PivotGridValueType.Total
|| e.RowValueType == PivotGridValueType.GrandTotal
|| e.RowField != lastLevelField)
e.Value = null;
}
}
Private Sub pivotGridControl1_CustomCellValue(ByVal sender As Object, ByVal e As PivotCellValueEventArgs) Handles pivotGridControl1.CustomCellValue
If e.DataField Is fieldLowLevel Then
Dim lastLevelField As PivotGridField = pivotGridControl1.GetFieldsByArea(PivotArea.RowArea).Last()
If e.RowValueType = PivotGridValueType.Total OrElse e.RowValueType = PivotGridValueType.GrandTotal OrElse e.RowField IsNot lastLevelField Then
e.Value = Nothing
End If
End If
End Sub
See Also
PivotCellEventArgsBase<TField, TData, TCustomTotal> Class