[Solved] Paste from Excel issue with blank cells

[Matthew]

I have a radGridView that is used to paste excel data (which can contain blank values in certain fields).

What I am experiencing is that these Blank values are being ignored and the remaining cells on the line to shift left to replace the empty cell.

For example the data in Excel...

Col 1 Col 2      Col3
130        65          Tree 321
213                      Tree 923
293        93          Tree 320

Would paste into the GridView as...

Col 1      Col 2      Col 3
130        65          Tree 321
213        Tree 923
293        93          Tree 320

Any ideas on why, as well as what I need to do for this to paste in to the proper locations?

[Matthew]

I got this to work by specifying...

rgvBulkEntry.ClipboardPasteMode = GridViewClipboardPasteMode.Cells | GridViewClipboardPasteMode.OverwriteWithEmptyValues;

[Combinations]

Thanks, this helped me!