• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Fixed Inconsistent behaviour when pasting tables from Excel

Jon W

Well-known member
#1
When I copy and paste a table in Google Chrome (Windows 8.1, Excel 2013), I get:
upload_2013-9-14_12-44-57.png

When I copy and paste the same table in IE11 (Windows 8.1, Excel 2013), I get:

a b c

d e f

g h i


When I copy and paste the same table in Google Chrome/IE10 (Windows 8, Excel 2013):
a b c
d e f
g h i
 
Last edited:

Jon W

Well-known member
#3
Not just IE11.

The IE11 behaviour is actually the preferred behaviour for me because when pasted it displays a HTML table. This could then be converted easily into a table BB code using an add-on.

It should be noted that Chrome defaults to the same behaviour as IE11 in places where image uploads are not allowed (i.e. conversations). Otherwise I would probably prefer the Chrome behaviour.
 

Mike

XenForo developer
Staff member
#4
IE11's paste behavior was bugged--mostly because of the user agent change--which meant that none of the paste clean up happened with it. I've sorted that.

I've changed Chrome's behavior to prefer using an HTML paste, even when there's a file-based version of it. This one of the first times I've noticed this come up. We were doing something similar before only when there were images in the HTML, but now I'm doing it all the time. It's sort of cool that there's an image format available too, though it's definitely not the exact option we want here.

Note that aside from when an image was pasted, there always was a table there. It's submitted to the server and can be parsed if desired. Since we don't have any alternative for tables, we parse them down as can be seen above.