FieldValueCell Class

Represents a field value cell.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v17.2.dll

Declaration

C#

public class FieldValueCell :
    FieldValueCellBase<PivotGridField>

VB.NET

Public Class FieldValueCell
    Inherits FieldValueCellBase(Of PivotGridField)

Related API Members

The following members accept/return FieldValueCell objects:

• FieldValueCell.Parent

Remarks

The FieldValueCell class instances are used when handling the PivotGridControl.CustomFieldValueCells event. The FieldValueCell objects are returned by the event parameter’s PivotCustomFieldValueCellsEventArgsBase<T1, T2>.GetCell method, and provide data related to individual field value cells.

Use the FieldValueCellBase.DisplayText, FieldValueCellBase.Value and FieldValueCellBase.ValueType properties to obtain the display text of the cell, the field value it represents, and the type of the cell, respectively. To obtain whether the cell is visible and whether it is expanded or collapsed, use the FieldValueCellBase.IsVisible and FieldValueCellBase.IsCollapsed properties, respectively. To obtain whether the cell is a column or row header, use the FieldValueCellBase.IsColumn property.

Use the FieldValueCellBase<T>.Field property to obtain the field whose value the cell represents. If the cell is a data field header, or a data field header’s nested cell, use the FieldValueCellBase<T>.DataField property, to obtain the data field that identifies this cell.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FieldValueCell 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-split-field-value-cells-e2763/CS/Form1.cs#L29

// Only cells that match this predicate are split.
Predicate<FieldValueCell> condition =
    new Predicate<FieldValueCell>(delegate(FieldValueCell matchCell) {

how-to-hide-empty-field-values-columns-rows-e2807/CS/Form1.cs#L44

{
    FieldValueCell cell = e.GetCell(isColumn, i);
    if (cell == null) continue;

how-to-hide-particular-rows-and-columns-e2769/CS/Form1.cs#L30

for (int i = e.GetCellCount(false) - 1; i >= 0; i--) {
    FieldValueCell cell = e.GetCell(false, i);
    if (cell == null) continue;

how-to-export-only-selected-cells-from-the-pivotgridcontrol-e3886/CS/WindowsFormsApplication3/Form1.cs#L65

{
    FieldValueCell cell = e.GetCell(isColumn, i);
    if (cell == null) continue;

how-to-locate-field-value-cells-matching-a-particular-condition-e2772/CS/Form1.cs#L30

// matches the specified condition, represented by a predicate.
FieldValueCell cell = e.FindCell(true, new Predicate<object[]>(

VB.NET

how-to-hide-empty-field-values-columns-rows-e2807/VB/Form1.vb#L42

For i As Integer = e.GetCellCount(isColumn) - 1 To 0 Step -1
    Dim cell As FieldValueCell = e.GetCell(isColumn, i)
    If cell Is Nothing Then

how-to-hide-particular-rows-and-columns-e2769/VB/Form1.vb#L35

For i As Integer = e.GetCellCount(False) - 1 To 0 Step -1
    Dim cell As FieldValueCell = e.GetCell(False, i)
    If cell Is Nothing Then

how-to-export-only-selected-cells-from-the-pivotgridcontrol-e3886/VB/WindowsFormsApplication3/Form1.vb#L52

For i As Integer = e.GetCellCount(isColumn) - 1 To 0 Step -1
    Dim cell As FieldValueCell = e.GetCell(isColumn, i)
    If cell Is Nothing Then

how-to-locate-field-value-cells-matching-a-particular-condition-e2772/VB/Form1.vb#L34

' matches the specified condition, represented by a predicate.
Dim cell As FieldValueCell = e.FindCell(True,
                New Predicate(Of Object())(Function(dataCellValues() As Object)

how-to-split-field-value-cells-e2763/VB/Form1.vb#L33

' Only cells that match this predicate are split.
Dim condition As New Predicate(Of FieldValueCell)(Function(matchCell As FieldValueCell) matchCell.ValueType =
                                    PivotGridValueType.GrandTotal AndAlso matchCell.Field Is Nothing)

Inheritance

Object

FieldValueCellBase

FieldValueCellBase<PivotGridField>

FieldValueCell