Excel Selection in GridDataControl

[Francisco]

Hi all,
I'm using GridDataControl and GridControl.
It is possible to have the 'excel selection' in the GridDataControl

I'd like to select:
- Multiple rows.
- Multiple columns.
- A range form A2 to C4.

Best

Francisco

[Francisco]

Setting the 'AllowSection' on the grid it doesn't work.

It is possible select many rows, many columns on the GridDataControl?

Best
Francisco

[Rajasekar]

Hi Francisco,

You can achieve your requirement by using the below code snippet,

For Multiple Row Selection:

dataGrid.ListBoxSelectionMode = GridSelectionMode.MultiExtended;
dataGrid.AllowSelection = GridSelectionFlags.Row;

For Multiple Column Selection:

dataGrid.ListBoxSelectionMode = GridSelectionMode.None;
this.dataGrid.AllowSelection = GridSelectionFlags.Column | GridSelectionFlags.Multiple | GridSelectionFlags.Shift;

Please let us know if you have any queries.

Thanks,
Rajasekar