Cell

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

 

veCell

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

See Also