Chrome: Difficulties pasting tables from Excel

[Jude Allred]

1. open an Excel 2007 spreadsheet

2. select some cells and hit ctrl+c

3. using chrome, go to ​http://ckeditor.com/demo

4. Paste the table into the editor using ctrl+v

5. right click on the newly-pasted table

6. [bug 1] the 'Table Properties' menu item is missing from the context menu.

7. view the source. [bug 2] Notice that the newly inserted table has each <tr> wrapped in a <p>, and there is no containing <table> tag.

8. [bug 3] return to wysiwyg mode- the table no longer looks like a table.

This is caused by Chrome failing to wrap the pasted HTML in a <table> tag. One workaround (which I'm currently using) is to use a special paste handler for Webkit:

if (CKEDITOR.env.webkit) {
	editor.ck.on('paste', function(evt) {
		if (evt.data.html) {
			//If this html contains table elements
			if ($('tr:first, td:first, th:first', evt.data.html).length) {
				//...but does not contain any <table> tags
				if ($('table:first', evt.data.html).length === 0) {
					//Wrap it in a table.
					evt.data.html = $('<table>').
						addClass(editor.ck.config.tableClass).
						append(evt.data.html)[0].
						outerHTML;
				}
			}
		}
	});
}

[Jude Allred]

note that in the above example, my editor instance is "editor.ck", not to be confused with CKEditor's internal 'editor' reference.

[Krzysztof Studnik]

Confirmed on Chrome 6;7; Opera 10.61; Safari with CKE 3.4.1 nightly and demo
Table formating is lost so "bug1" in point 6 is consequence of problems in point 7&8

[Jakub Ś]

Seems that this issue has expired on trunk.

It is no longer reproducible in Chrome 16 and Opera 11.60

Problems with lost formatting has been described here #6465

Problem with Safari which currently can’t handle parsing tables pasted from Excel was described here #8639

Closing this one as fixed.