Excel like behavior

How can I accomplish Excel like selection behavior, where if I have selected a range and move (click) to any other cell the range is cleared? I played around ExcelLike properties in GDBG but coudn't replicate Excel behavior. Thanks in advance Jose.

Exactly what behavior do you want? When I bring up Excel and select a range, if I click to another cell in the selected range or click to another cell outside the selected range, in either case I see the original selection go away. To maintain the selection, I have to hold down the control key as I click. This is how the grid behaves by default as well. You can probably get whatever behavior you want by handling the SelectionsChanging event. Here is sample code that retains the selection (without the control key) as long as you click within the currently selcted range.

private void grid_SelectionChanging(object sender, GridSelectionChangingEventArgs e)
{
	int row, col;
	GridRangeInfoList rangeList;
	Point pt = this.grid.PointToClient(Control.MousePosition);
	if(e.Range.IsEmpty && Control.MouseButtons == MouseButtons.Left
		&& this.grid.PointToRowCol(pt, out row, out col, -1)
		&& this.grid.Selections.GetSelectedRanges(out rangeList, false)
		&& rangeList.AnyRangeContains(GridRangeInfo.Cell(row, col)))
	{
		e.Cancel = true;
	}
}

I think I misread your question. Are you saying that clicking elsewhere does not remove the current selections? It should. What version of our libraries are you using? If you just drop a GridControl on a form in a sample project. do you see this problem?

> I think I misread your question. Are you saying that clicking elsewhere does not remove the current selections? > > It should. What version of our libraries are you using? If you just drop a GridControl on a form in a sample project. do you see this problem? > Clicking is not the problem. When I move to another cell using keyboard it is. Thanks

Try handling CurrentCellMoved and clearing the selections there.

private void gridMessages_CurrentCellMoved(object sender, GridCurrentCellMovedEventArgs e)
{
	this.gridMessages.Selections.Clear();
}

Opppsss. For some reason I cannot select the first row.

Try this code in the event.

GridCurrentCell cc = this.gridMessages.CurrentCell;
if(cc.HasCurrentCell && cc.RowIndex > 0 && cc.ColIndex > 0)
	this.gridMessages.Selections.Clear();

It doesn't seen to be related to the first row only, wherever you start doing the selection, first row selected will select only the first column. Any other recommendation?

I don't see the problem in attached sample. Do you? Have you set some styles with style.Enabled = false? If so, this will interfere with selections if you try to mouse down on a disabled cell.

Try this example using a DataBoundGrid.

I can mousedown on Code0 and drag to to 4 in the price column and I see then full rectangle highlighted (except for the current cell which is part of the selection, but not highlighted). This is teh same behavior I see in Excel where the initial mousedown cell is not included in the highlighted range. Attached is the picture I see. If you are seeing something diffferent, what version are you using. I am using a private build, 1.6.1.8.

Try to select the first 4 rows, draging from the row header. I am using 1.6.1.9

Instead of CurrentCellMoved, try KeyDown.

private void gridDataBoundGrid1_KeyDown(object sender, KeyEventArgs e)
{
	if((e.Modifiers & Keys.Shift) == 0)
	         this.gridDataBoundGrid1.Selections.Clear();
}