Copy and paste cells between Excel and RadGridView

[Daniel]

I need to have formatted numbers in RadGridView, my columns looks like below:

<telerik:GridViewDataColumn DataMemberBinding="{Binding MarketValue}"
                                          DataFormatString="n2">
                  <telerik:GridViewDataColumn.CellEditTemplate>
                      <DataTemplate>
                          <TextBox Text="{Binding MarketValue, StringFormat=n2}"></TextBox>
                      </DataTemplate>
                  </telerik:GridViewDataColumn.CellEditTemplate>
</telerik:GridViewDataColumn>

based on this post: http://www.telerik.com/forums/numeric-input-with-decimals-in-gridviewmaskedinputcolumn#oNu7_qiNFkS-vjfxCML3sQ

 

I want to have an opportunity to copy multiple cells from the Grid and paste them into excel file or notepad and it works out-of-th-box.

Unfortunately I cannot reverse it - I cannot change some values in excel file, copy them and paste into RadGridView. Is there any way to do it easily?

 

[Stefan Nenchev]

Hello Daniel,

I have used the sample project from the other thread and was able to copy values from excel and paste them into the RadGridView control. Please check the following video that I have recorded at my end - http://screencast.com/t/HzO4N6rluPKg.

Can you please update me whether you have set the ClipboardPasteMode property of RadGridView to None for some reason? Please review our documentation regarding the paste functionality - Pasting. Sharing more details regarding your overall setup will be appreciated.

Regards,
Stefan Nenchev
Telerik by Progress