Suspend sorting data is pasted

[Huy]

I have exactly the same problem as described here

http://www.telerik.com/forums/suspend-sorting-during-paste

Basically I want to disable column sorting when users wants to paste their data into the grid
Just let the column unsorted and let user decide whether they want to sort again

I tried this on Pasting event of the grid, but it doesn't work

private void OnGridPasting(object sender, GridViewClipboardEventArgs e)
{
    ((RadGridView) sender).CurrentColumn.SortingState = SortingState.None;
}

It actually doing nothing, the column still get sorted on pasting, and I can see the sorting caret on the column header, which is weird !!

So I switched to PastingCellClipboardContent event and do this

private void OnPastingCellClipboardContent(object sender, GridViewCellClipboardEventArgs e)
{
    e.Cell.Column.SortingState = SortingState.None;
}

The sorting caret on column header disappears, but as the data being modified, they still get sorted <-- I believe this is a bug

What else can I do to get my problem solved?

Thanks

[Dimitrina]

Hello,

I attached a demo solution to illustrate how you can save the current sort configuration and then clear it just before pasting the data and add it back after the pasting has finished. 

Basically, the reply posted by my colleague Rossen Hristov in the referred topic still applies. Keep in mind a SortDescriptor will be evaluated and the data will be sorted accordingly once it is added to the SortDescriptors collection.

Regards,
Dimitrina
Telerik