Data Cell
- 2 minutes to read
Data Cells are located in the data area of the pivot grid. Data cells display Cross Cells, Total Cells and Grand Total Cells. Cross cells display summary values which have been calculated for row and column fields.
Each cross 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) and these values are identified by column and row headers.
The tables below list the main properties of the pivot grid which affect the appearance and behavior of data cells. For information on the properties, which affect the appearance of total cells and grand total cells, refer to the Subtotals and Grand Totals topics.
Visibility | A field’s Data |
Contents | A field’s Display Handle a field’s On |
Appearance | The Styles. For limit values, the Styles. To dynamically customize these style settings, handle the Styles. |
Custom Draw Event | The On |
Hints | The Options The pivot grid’s On |
Hit | The Hit |
For focused data cells:
Coordinates | The View |
Appearance | The Styles. To dynamically customize these style settings, handle the Styles. |
Behavior | The Options To scroll the focused cell into view at runtime, call the View |
For selected data cells:
Contents | The View |
Appearance | The Styles. To dynamically customize these style settings, handle the Styles. |
Behavior | The Options The On |