Copy - Paste from Excel

6 posts, 0 answers
  1. Dario Gomez
    Dario  Gomez avatar
    3 posts
    Member since:
    Oct 2009

    Posted 01 Oct 2009 Link to this post

    When we do a “copy – paste”   from excel, the format gets lost, it only keeps the structure of the table, the rest is a flat text. 
    The same behavior is present in your demonstration page (version Q2 2009 SP1 2009.2.826).  Our workaround is to paste the copied structure in Word and then to copy it from Word to the RAD editor to preserve the format.

  2. Schlurk
    Schlurk avatar
    812 posts
    Member since:
    May 2009

    Posted 02 Oct 2009 Link to this post

    I had a similar problem and fixed it using this:
     
    <telerik:RadEditor 
       runat="server" 
       ID="RadEditor1" 
       StripFormattingOptions="NoneSupressCleanMessage, Span">
       .....
    </telerik:RadEditor>  

  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. LeBear
    LeBear avatar
    233 posts
    Member since:
    May 2006

    Posted 28 Sep 2010 Link to this post

    I've tried to do this (version 2010.1.415.35), and it doesn't preserve cell borders, background colors, and font colors.  Is this possible?  (Yes, the Word workaround is there, but...)

    Thanks.
  5. Rumen
    Admin
    Rumen avatar
    12849 posts

    Posted 30 Sep 2010 Link to this post

    Hi LeBear,

    The content area of the editor is a standard editable IFRAME element. The conversion from XML to HTML of the pasted content from MS Excel is not done by the editor, but by MS Excel and the browser. Could you please paste the same content in the attached HTML page having an editable IFRAME in it and see whether the same behavior will occur.

    If you get a different results in the editable IFRAME, please send us a sample excel file (along with screenshots demonstrating your test in RadEditor an in the IFRAME) and we will test it.

    Best regards,
    Rumen
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  6. rohit
    rohit avatar
    1 posts
    Member since:
    Dec 2013

    Posted 05 Aug 2014 Link to this post

    We are having similar issue. When I copy paste from excel all the formatting gets copied however the cell alignment does not get copied. I am getting the font, styles e.t.c applied correctly when I copy paste from excel however the enter alignment of the cells is not preserved. Please can anybody let me know work around on this. We are also using the copy to word and then radeditor approach as mentioned above.
  7. Ianko
    Admin
    Ianko avatar
    1535 posts

    Posted 06 Aug 2014 Link to this post

    Hello Rohit,

    As Rumen explained in his message, the RadEditor control do not have the power to manipulate the data pasted from Excel.  

    When content is pasted, the content processed is controlled by the desktop applications i.e., browser and MS Excel in this case.

    This matter cannot be handled by somehow configuring an web application.

    As the content pasted is upon standards based on the XML logic behind Excel and Word files, they can transfer the content between them successfully. Therefore, I suggest prompting the users to paste Excel content in editable HTML element by firstly processing it first trough the MS Word processor (i.e, paste content from Excel to Word and then in RadEditor). This way the content inserted will be more reliable and suitable for e.g., the RadEditor control.

    Regards,
    Ianko
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017