Skip to main content

TcxPivotGridViewData.Cells Property

Represents a value object, which stores the calculated summary values for the specified cell and the settings used to calculate them.

Declaration

property Cells[Row: Integer; Column: Integer]: TcxPivotGridCrossCellSummary read;

Property Value

Type
TcxPivotGridCrossCellSummary

Remarks

The Cells property

  • provides access to the field which the summary values are calculated for (via the DataField property);

  • provides access to the cross cell which provides the drilldown data records used to calculate summary values and determines its location via the Owner, Owner.Column and Owner.Row properties, respectively;

  • provides access to the indexes of the data records used to calculate summary values (via the Records property);

  • provides access to the summary values that have been calculated using built-in summary functions (refer to the TcxPivotGridSummaryType topic for details);

  • allows to specify a custom summary value for a field via the Custom property. If the field is in variation mode, you can also specify the difference between this value and the previously calculated summary value using the SummaryVariation property.

The Row and Column parameters specify the zero-based row’s and column’s indexes that identify the required cell.

See Also