RadGridView - Drag and Trend Behavioiur

[Scott]

I am looking to mimic Spreadsheet behaviour where a user selects two or more cells in a row and then the user drags to the right to trend and fill in additional values according to the linear trend. 

How could I go about overloading the RadGridView to provide behaviour like this? I have seen posts about using CustomAdorner to give a thick line around the selected cells. What would be required to change the mouse cursor when the "Think" line around the selected cells is hovered over, and capture the dragged-over cells when the user executes the drag operation?

Any help you can provide would be much appreciated.

[Martin Ivanov]

Hi Scott,

You can consider using the RadSpreadsheet for WPF control.

If you need to use the GridView, then you can enable drag-to-select by setting the SelectionMode property to Extended and the DragElementAction to Select.

<telerik:RadGridView SelectionMode="Extended"  DragElementAction="Select"/>

To enable dragging of the selected rows and then moving/copying them to another cell range, you will need to write custom code. You can find some code showing custom drag and drop in the following SDK sample: https://github.com/telerik/xaml-sdk/tree/master/GridView/DragDropWithLines. The example doesn't show your exact requirement, but you can use it as a reference for your own implementation.

To change the cursor during drag/drop, you can use the GiveFeedback event of DragDropManager.

I hope this information.

Regards,
Martin Ivanov
Progress Telerik