FieldValueCellBase.ValueType Property

Gets the type of the cell.

Namespace: DevExpress.XtraPivotGrid.Data

Assembly: DevExpress.PivotGrid.v19.1.Core.dll

Declaration

C#

public PivotGridValueType ValueType { get; }

VB.NET

Public ReadOnly Property ValueType As PivotGridValueType

Property Value

Type	Description
PivotGridValueType	A PivotGridValueType enumeration member that specifies the type of the cell.

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

The ValueType property defines whether the current cell represents a field value, or it is an automatic total, grand total or custom total column/row header. In the first instance, use the FieldValueCellBase.Value property to obtain the field value.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ValueType 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-hide-particular-rows-and-columns-e2767/CS/ASPxPivotGrid_HidingColumnsAndRows/Default.aspx.cs#L33

if (object.Equals(cell.Value, "Employee B") &&
    cell.ValueType != PivotGridValueType.Total)
    e.Remove(cell);

how-to-split-field-value-cells-e2762/CS/ASPxPivotGrid_SplittingCells/Default.aspx.cs#L27

new Predicate<FieldValueCell>(delegate(FieldValueCell matchCell) {
return matchCell.ValueType == PivotGridValueType.GrandTotal &&
    matchCell.Field == null;

winforms-pivot-grid-hide-specific-columns-and-rows/CS/Form1.cs#L37

if (object.Equals(cell.Value, "Employee B") &&
    cell.ValueType != PivotGridValueType.Total)
    e.Remove(cell);

VB.NET

how-to-hide-particular-rows-and-columns-e2767/VB/ASPxPivotGrid_HidingColumnsAndRows/Default.aspx.vb#L39

' it is removed with all corresponding rows.
If Object.Equals(cell.Value, "Employee B") AndAlso cell.ValueType <> PivotGridValueType.Total Then
    e.Remove(cell)

how-to-split-field-value-cells-e2762/VB/ASPxPivotGrid_SplittingCells/Default.aspx.vb#L46

Private Function AnonymousMethod1(ByVal matchCell As FieldValueCell) As Boolean
    Return matchCell.ValueType = PivotGridValueType.GrandTotal AndAlso _
        matchCell.Field Is Nothing

winforms-pivot-grid-hide-specific-columns-and-rows/VB/Form1.vb#L43

' it is removed with all corresponding rows.
If Object.Equals(cell.Value, "Employee B") AndAlso cell.ValueType <> PivotGridValueType.Total Then
    e.Remove(cell)