This is a migrated thread and some comments may be shown as answers.

Paste from Excel row with more columns that existing in the Grid

1 Answer 50 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Gorka S.
Top achievements
Rank 1
Gorka S. asked on 08 Aug 2019, 11:40 AM

When trying to paste a row from an Excel Sheet with 11 columns, the PastingCellClipboardContent event is only launched 10 times.

Is there any way to force the event to be launched as many times as copied range existing columns (11) ?

Regards

   AVG Solutions

1 Answer, 1 is accepted

Sort by
0
Dinko | Tech Support Engineer
Telerik team
answered on 13 Aug 2019, 11:16 AM
Hi Gorka,

My guess here is that there's empty cell copied from the excell. Empty cells are ignored when pasting into the RadGridView. You can change that by setting the ClipboardPasteMode property of the RadGridView to OverwriteWithEmptyValues.

Give this approach a try and let me know how it goes on your side.

Regards,
Dinko
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
GridView
Asked by
Gorka S.
Top achievements
Rank 1
Answers by
Dinko | Tech Support Engineer
Telerik team
Share this question
or