Copy - Paste from Excel

[Dario Gomez]

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.

[Schlurk]

I had a similar problem and fixed it using this:

<telerik:RadEditor

runat="server"

ID="RadEditor1"

StripFormattingOptions="NoneSupressCleanMessage, Span">    .....

</telerik:RadEditor>

[LeBear]

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.

[Rumen]

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

[rohit]

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.

[Ianko]

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