Skip to main content

Selecting Data Cells

The ability to select multiple data cells is determined by the OptionsSelection.MultiSelect option. When this option is enabled, multiple cells can be selected in the following ways:

  • using the mouse;

  • using key combinations;

  • via code.

End-users can select cells with the mouse or keyboard as described in the Selecting Cells topic of the End-User Capabilities section. This topic describes how to select cells programmatically.

The information on the cells displayed by the pivot grid can be obtained via its ViewData.Cells and ViewData.CellsAsText properties. To programmatically select data cells, use the ViewData.Selection property.

The appearance settings used to paint the selected cells are specified by the pivot grid’s Styles.Selected property.

After selection has been changed, the OnSelectionChanged event is raised.

See Also