Cell

• Jul 05, 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	The PivotGridAppearancesBase.Cell and PivotGridFieldAppearances.Cell properties. The PivotGridControl.CustomAppearance event.
Summary	PivotGridFieldBase.SummaryType, PivotGridFieldBase.SummaryDisplayType
Visibility	PivotGridFieldOptions.ShowValues
Contents	PivotGridControl.Cells
Customizing Display Values	The PivotGridControl.CustomCellDisplayText event.
Customizing Appearances Dynamically	The PivotGridControl.CustomDrawCell and PivotGridControl.CustomAppearance events.
Format	PivotGridFieldBase.CellFormat

 

Focused Cell:

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

 

Selected Cells:

Bounding Rectangle	PivotGridCells.Selection
Appearance	PivotGridAppearances.SelectedCell