PivotCellEventArgsBase<TField, TData, TCustomTotal>.GetCellValue(Object[], Object[], TField) Method

Returns a cell value calculated for the specified column and row field values, against the specified data field.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

public object GetCellValue(
    object[] columnValues,
    object[] rowValues,
    TField dataField
)
Public Function GetCellValue(
    columnValues As Object(),
    rowValues As Object(),
    dataField As TField
) As Object

Parameters

Name Type Description
columnValues Object[]

An array of column values.

rowValues Object[]

An array of row values.

dataField TField

A T object that specifies the data field, against which the required cell value is calculated.

Returns

Type Description
Object

A summary value calculated for the specified column and row field values, against the specified data field.

Remarks

Consider the pivot grid displayed in the image below.

GetCellValue

The following table illustrates how to use the GetCellValue method to obtain specific cell values.

Cell C# Visual Basic
Blue e.GetCellValue(new object[] {1995, 1}, new object[] {"Alice Mutton"}, fieldProductAmount); e.GetCellValue(New Object() {1995, 1}, New Object() {"Alice Mutton"}, fieldProductAmount)
Red e.GetCellValue(new object[] {1995}, new object[] {"Chai"}, fieldProductAmount); e.GetCellValue(New Object() {1995}, New Object() {"Chai"}, fieldProductAmount)
Green e.GetCellValue(null, new object[] {"Chang"}, fieldProductAmount); e.GetCellValue(Nothing, New Object() {"Chang"}, fieldProductAmount)
See Also