How to configure a RadGridView to copy and paste like Excel?

[Matt]

If a user sees a grid that looks like Excel, they expect it to function the same as Excel. I'm not very familiar with Telerik grids, but the OOTB copy/paste functionality doesnt seem to work the identical to Excel.

Our users need to be able to select a single cell and paste a single cell. This seems to work.

They also need to be able to select a single cell and paste its value in many cells. This only seems to paste the value in the last selected cell, not all selected cells.

Before:

After

Select multiple continuous cells from a row and paste to a single cell, and have all copied cells pasted starting at the selected paste location. This seems to work

Select multiple continuous cells from a row and paste to a selection of continuous rows and have all copied cells pasted. This seems to only work on the last row

Before

After

Here are my current grid settings:

DataRadGrid.AllowAddNewRow = false;
DataRadGrid.AllowColumnChooser = false;
DataRadGrid.AllowColumnReorder = false;
DataRadGrid.AllowDeleteRow = false;
DataRadGrid.AllowEditRow = true;
DataRadGrid.AllowMultiColumnSorting = true;
DataRadGrid.AllowRowReorder = false;
DataRadGrid.AllowRowResize = false;

DataRadGrid.BeginEditMode = RadGridViewBeginEditMode.BeginEditOnKeystroke;
DataRadGrid.EnableAlternatingRowColor = true;
DataRadGrid.EnableCustomDrawing = true;
DataRadGrid.EnableFiltering = true;
DataRadGrid.EnableGrouping = false;
DataRadGrid.EnableHotTracking = false;
DataRadGrid.HorizontalScrollState = ScrollState.AlwaysShow;
DataRadGrid.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.None;
DataRadGrid.MasterTemplate.ShowFilteringRow = false;
DataRadGrid.MasterTemplate.ShowHeaderCellButtons = true;
DataRadGrid.MasterView.TableSearchRow.ShowClearButton = true;
DataRadGrid.MultiSelect = true;
DataRadGrid.SelectionMode = GridViewSelectionMode.CellSelect;
DataRadGrid.ShowColumnHeaders = true;
DataRadGrid.VerticalScrollState = ScrollState.AlwaysShow;
DataRadGrid.EnterKeyMode = RadGridViewEnterKeyMode.EnterMovesToNextRow;

Are there settings I can use to mimic Excel, if not, is there boilerplate code to achieve this?

Thanks,

matt

[Dinko | Tech Support Engineer]

Hi Matt,

Thank you for contacting us.

I understand that RadGridView resembles Excel, however, it is a different control. The control, which resembles Excel functionalities and look, is the RadSpreadsheet control. You can check it out and see if it will work for your scenario. 

Now for the copy/paste requirement: RadGridView doesn't support such copy/paste functionality as in Excel. However, the following KB article demonstrates a sample approach on how you can plug into the pasting behavior and manipulate the values of the selected cells according to the requirements that you may have: How to Paste a Single Value to All Selected Cells in RadGridView 

You can extend the code in the KB to add support for a different scenario. I hope that this KB will work for you.

Regards,
Dinko | Tech Support Engineer
Progress Telerik

[Matt]

Thank you, I will check out the RadSpreadsheet control and your article.

Thanks again,

matt