[wp-trac] [WordPress Trac] #27909: Pasting Tables from Excel Strips Tables

[WordPress Trac]

#27909: Pasting Tables from Excel Strips Tables
--------------------------+--------------------
 Reporter:  DH-Shredder   |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  3.9.1
Component:  TinyMCE       |     Version:  3.9
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+--------------------
Description changed by DH-Shredder:

Old description:

> Prior to 3.9, one could copy/paste cells directly from Excel into TinyMCE
> (either directly or with Paste from Word).
>
> Now, after paste, it inserts the numbers, followed by an É, stripping all
> table HTML.
>
> Sample pasted HTML after pasting into 3.8.x, in case it helps:
> {{{
> <table width="260" border="0" cellspacing="0" cellpadding="0"><!--
> StartFragment--> <colgroup><col span="4" width="65" /> </colgroup>
> <tbody>
> <tr>
> <td align="right" width="65" height="15">1</td>
> <td align="right" width="65">5</td>
> <td align="right" width="65">2</td>
> <td align="right" width="65">5</td>
> </tr>
> <tr>
> <td align="right" height="15">8</td>
> <td align="right">2</td>
> <td align="right">1</td>
> <td align="right">3</td>
> </tr>
> <!--EndFragment--></tbody>
> </table>
> }}}
>
> Sample screenshots attached.

New description:

 Prior to 3.9, one could copy/paste cells directly from Excel into TinyMCE
 (either directly or with Paste from Word).

 Now, after paste, it inserts the numbers, followed by an È, stripping all
 table HTML.

 Reproduced on Mac Excel 2011:
 * Open Excel
 * Enter a few numbers into two lines
 * Copy Cells
 * Paste into WordPress Visual Editor

 Sample pasted HTML after pasting into 3.8.x, in case it helps:
 {{{
 <table width="260" border="0" cellspacing="0" cellpadding="0"><!--
 StartFragment--> <colgroup><col span="4" width="65" /> </colgroup>
 <tbody>
 <tr>
 <td align="right" width="65" height="15">1</td>
 <td align="right" width="65">5</td>
 <td align="right" width="65">2</td>
 <td align="right" width="65">5</td>
 </tr>
 <tr>
 <td align="right" height="15">8</td>
 <td align="right">2</td>
 <td align="right">1</td>
 <td align="right">3</td>
 </tr>
 <!--EndFragment--></tbody>
 </table>
 }}}

 Sample screenshots attached.

--

--
Ticket URL: <https://core.trac.wordpress.org/ticket/27909#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform