Current Cell

[Scott Griswold]

Hello,

I am trying to implement a drag and drop operation from a tree view control to the spreadsheet control. How do I get the cell value of the cell that the item is being dropped onto?

Scott

[Ponraja A]

Hi Scott,

Sorry for the delay caused.

You can get the dropped row and column index of the grid, by using the PointToCellRowColumnIndex method as shown in the following code.

Sample Code [C#]

void SpreadSheetControl_Drop(object sender, DragEventArgs e)
{
var point = e.GetPosition(spreadSheetControl);
GridControlBase grid = spreadSheetControl.GridProperties.CurrentCell.Grid;
RowColumnIndex rowColumnIndex = grid.PointToCellRowColumnIndex(point);
var cellvalue = grid.Model[rowColumnIndex.RowIndex, rowColumnIndex.ColumnIndex].CellValue;
}

Please let us know if you have any queries.

Regards,
Ponraja