Pasting from Excel into covered cells

[Sara Dickinson]

Hi,

I have a grid with a row containing columns with covered cells (3 per column). When I try to paste multiple (e.g. 3) cells from Excel into that row, only the first column is updated. From debugging I can see that GridControl.OnPasteCellText is called 3 times for columns 1,2 and 3 because there are 3 pieces of data to paste. But because the cells are covered the data should be pasted into columns 1,4 and 7. Have a missed setting a flag on the table or do I need to write a custom paste method to do what I want?

[Administrator]

Hi,

We are currently looking into this issue and will update you the details.

Thanks for your patience.
Best Regards,
Megavannan

[Administrator]

Hi Sara,

The Attached sample demonstrates the covered cell custom pasting in a grid. It implements the ClipboardPaste event to manually assign the cell value in a grid.

Here is a sample.
http://www.syncfusion.com/Support/user/uploads/CopyPaste_4bb54183.zip

Let me know if you are looking something different.

Best Regards,
Haneef

[Sara Dickinson]

Hi Haneef,

I was afraid this was the answer.... thanks. Sara.