Copy and paste cells between Excel and RadGridView

2 posts, 0 answers
  1. Daniel
    Daniel avatar
    4 posts
    Member since:
    Aug 2015

    Posted 19 Jul Link to this post

    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?

     

  2. Stefan Nenchev
    Admin
    Stefan Nenchev avatar
    277 posts

    Posted 21 Jul Link to this post

    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.
  3. UI for WPF is Visual Studio 2017 Ready
Back to Top