HI,
I used to use the behaviour on this thread (http://www.telerik.com/community/forums/silverlight/gridview/radgridview-copy-paste-to-from-excel-questions.aspx) in order to have Cell and Row sellection mode and Copy and Paste from Excel working as expected.
Now I have this:
SelectionMode="Extended"
SelectionUnit="Mixed"
ClipboardPasteMode="OverwriteWithEmptyValues,AllSelectedCells"
When I Copy and Paste to/from Excel it works perfectly, but when I try to Copy and Paste to/from the grid it ignores the empty cells if the selection is vertical, when it's horizontal it works fine. Like this:
Before copy/paste
How can I make this vertical selection to work?
Thanks,
Adriano.
I used to use the behaviour on this thread (http://www.telerik.com/community/forums/silverlight/gridview/radgridview-copy-paste-to-from-excel-questions.aspx) in order to have Cell and Row sellection mode and Copy and Paste from Excel working as expected.
Now I have this:
SelectionMode="Extended"
SelectionUnit="Mixed"
ClipboardPasteMode="OverwriteWithEmptyValues,AllSelectedCells"
When I Copy and Paste to/from Excel it works perfectly, but when I try to Copy and Paste to/from the grid it ignores the empty cells if the selection is vertical, when it's horizontal it works fine. Like this:
Before copy/paste
- Column 1 - Column 2 - Column 3
- - Value 2 -
- Value 4 - Value 5 -
- - Value 8 - Value 9
So I select all cells in Column 1 press CTRL+C and select the cell with Value 2, so the final grid is going to be like this (ignoring empty cells):
- Column 1 - Column 2 - Column 3
- - Value 4 -
- Value 4 - Value 5 -
- - Value 8 - Value 9
How can I make this vertical selection to work?
Thanks,
Adriano.