PivotGridControl.GetCellInfo(Int32, Int32) Method

Returns an object that contains information on the specified cell.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Packages: DevExpress.WindowsDesktop.Wpf.PivotGrid, DevExpress.Wpf.PivotGrid

Declaration

C#

public PivotCellBaseEventArgs GetCellInfo(
    int columnIndex,
    int rowIndex
)

VB.NET

Public Function GetCellInfo(
    columnIndex As Integer,
    rowIndex As Integer
) As PivotCellBaseEventArgs

Parameters

Name	Type	Description
columnIndex	Int32	A zero-based integer that identifies the visible index of the column.
rowIndex	Int32	A zero-based integer that identifies the visible index of the row.

Returns

Type	Description
PivotCellBaseEventArgs	A PivotCellBaseEventArgs object that contains information on the specified cell.

Remarks

The GetCellInfo method returns a PivotCellBaseEventArgs object that contains information on the specified cell. It specifies the type of the cell, the cell’s value and display text, whether it is focused or selected, etc. It also allows an array of records associated with this cell to be retrieved via the PivotCellBaseEventArgs.CreateDrillDownDataSource method.

To identify a cell, pass the indexes of the row and column that contain the cell as the GetCellInfo method parameters. The valid row indexes lie between 0 and PivotGridControl.RowCount - 1. The valid column indexes lie between 0 and PivotGridControl.ColumnCount - 1.

The PivotGridControl.FocusedCell property identifies the indexes of the row and column that contain the focused cell. To get the coordinates of the selected cells, use the PivotGridControl.Selection property.

Use the PivotGridControl.GetFocusedCellInfo method to get information on the focused cell.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the GetCellInfo(Int32, Int32) method.

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-create-a-custom-exporter-that-supports-autorowheight-bestfit-and-fittopage-t274241/CS/WpfApplication31/PivotReportGenerator.cs#L46

for(int i = 0; i < pivot.RowCount; i++) {
    PivotCellBaseEventArgs pcea = pivot.GetCellInfo(0, i);
    if(pcea.RowValueType == FieldValueType.Value) {

VB.NET

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

For i As Integer = 0 To pivot.ColumnCount - 1
    Dim pcea As PivotCellBaseEventArgs = pivot.GetCellInfo(i, 0)
    For Each field As PivotGridField In pcea.GetColumnFields()