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

Copy and paste cells between Excel and RadGridView

1 Answer 140 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Daniel
Top achievements
Rank 1
Daniel asked on 19 Jul 2016, 09:13 AM

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?

 

1 Answer, 1 is accepted

Sort by
0
Stefan Nenchev
Telerik team
answered on 21 Jul 2016, 01:19 PM
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
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Tags
GridView
Asked by
Daniel
Top achievements
Rank 1
Answers by
Stefan Nenchev
Telerik team
Share this question
or