Topic on Talk:VisualEditor

Copy and Paste a Table from Microsoft Excel

5
Marc-André Aßbrock (talkcontribs)

I tried to copy and paste a table from LibreOffice Calc into the VisualEditor and I was very happy that it works.

However, I can't copy tables from Microsoft Excel into the VisualEditor. I tried it on our own installation, as well as on de.wikipedia.org. The result was the following: The text of all the cells was written in one line. The columns were separated by two spaces, the lines by four spaces.

While searching on the internet I got the impression, that other people successfully copied from Excel to the VisualEditor.

My questions are: Does it in principle work? And if it works in principle: What is the trick to make it work?

Thanks in advance for any answer.

Whatamidoing (WMF) (talkcontribs)

Hmm. It works in principle, but whether any given spreadsheet/any given version works... I don't know. Were you able to test a very small table (just a few cells, with no fancy formatting)?

In the meantime, have you considered exporting it as a .csv file? You can drag-and-drop .csv files into the visual editor, and it will convert them to tables for you.

ESanders (WMF) (talkcontribs)

We use HTML to paste from spreadsheets. To see what HTML Excel is producing, you can paste into the right side of this: https://edg2s.github.io/content-editable-sandbox/ which will help us investigate. You can also do the paste with the developer console open (F12) and see if there are any errors listed.

50.74.80.182 (talkcontribs)
Reply to "Copy and Paste a Table from Microsoft Excel"