Cell

• Aug 01, 2018

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

 

Each cell displays a summary calculated against a data field for a subset of the 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) and 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.

Appearance	PivotGridAppearancesBase.Cell PivotGridFieldAppearances.Cell
Summary	PivotGridFieldBase.SummaryType, PivotGridFieldBase.SummaryDisplayType
Visibility	PivotGridFieldOptions.ShowValues
Contents	PivotGridControl.Cells
Cell Content Customization	PivotGridControl.CustomCellValue PivotGridControl.CustomCellDisplayText
Cell Appearance Customization	PivotGridControl.CustomDrawCell PivotGridControl.CustomAppearance
Format	PivotGridFieldBase.CellFormat

 

Focused Cell:

Coordinates	PivotGridCells.FocusedCell
Appearance	PivotGridAppearances.FocusedCell, PivotGridOptionsSelection.EnableAppearanceFocusedCell

 

Selected Cells:

Bounding Rectangle	PivotGridCells.Selection
Appearance	PivotGridAppearances.SelectedCell