A newer version of this page is available. Switch to the current version.


Cells display summary values that have been calculated for row and column fields. Cells are located in the Data Area of a pivot grid.




Each cell displays a summary calculated against a data field for a subset of records in the control's underlying data source. All records from this subset have matching values in a column field(s) and row field(s). These values are identified by column and row headers.


The table below lists the main properties that affect the appearance of data cells. For information on properties that affect the appearance of total cells and grand total cells, refer to the Totals and Grand Totals topics.




PivotGridStyles.CellStyle (via PivotGridSettings.Styles.CellStyle)

PivotGridField.CellStyle (via MVCxPivotGridField.CellStyle)


PivotGridFieldBase.SummaryType (via MVCxPivotGridField.SummaryType)

PivotGridFieldBase.SummaryDisplayType (via MVCxPivotGridField.SummaryDisplayType)

Customizing Display Values

The PivotGridSettings.CustomCellDisplayText event.


PivotGridFieldBase.CellFormat (via MVCxPivotGridField.CellFormat)

See Also