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

Pasting from Excel skips empty cells

1 Answer 104 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Vinod
Top achievements
Rank 1
Vinod asked on 22 Oct 2015, 03:54 PM

When copying multiple cells from an excel sheet to the GridView, empty cells are skipped and following non-empty cells are moved forward. See attached screenshots for an illustration.

This behavior is undesirable for obvious reasons. Is this a bug or a feature. If it's a feature, is there a workaround?

1 Answer, 1 is accepted

Sort by
0
Maya
Telerik team
answered on 22 Oct 2015, 07:18 PM
Hello Vinod,

You can modify this behavior by setting ClipboardPasteMode property of RadGridView. In this case you can set it to"OverrideWithEmptyValues". Check out the "Pasting" article for further reference, 

Regards,
Maya
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
GridView
Asked by
Vinod
Top achievements
Rank 1
Answers by
Maya
Telerik team
Share this question
or