I'm trying to make a markdown table in Microsoft Excel, I copied multiple rows then went to paste the text into a post, and I get this result:
Whereas I'd have expected the table to have been pasted as below in notepad++:
|0|1|2|3|4|5|6|7|8|9
|0|4|2|2|3|2|1|3|err|1
|err|0|err|err|err|err|err|err|err|err
|err|4|0|1|3|2|err|3|err|err
|err|3|1|0|2|1|err|2|err|err
|err|2|err|err|0|err|err|2|err|err
|err|4|2|1|2|0|err|3|err|err
|1|4|2|2|3|1|0|4|err|1
|err|1|err|err|err|err|err|0|err|err
|1|5|2|2|3|2|1|4|0|1
|1|4|2|1|2|1|1|3|err|0
Could this be fixed? Converting tables to images is the opposite of what I normally want to do in an edit (image to markdown table!). There's a related bug where isn't not clear what you want paste: Copying text from OneNote and pasting creates an image instead of text but as you should never be pasting an image of a table in, we should actually fix this one!
If the devs can see a `text/HTML' data type on the clipboard event, and then interrogate the html returned you can detect where it's come from:
> arguments[0].clipboardData.getData('text/HTML')
`<html xmlns:v="urn:schemas-microsoft-com:vml"\r\nxmlns:o="urn:schemas-microsoft-com:office:office"\r\nxmlns:x="urn:schemas-microsoft-com:office:excel"\r\nxmlns="http://www.w3.org/TR/REC-html40">\r\n\r\n<head>\r\n<meta http-equiv=Content-Type content="text/html; charset=utf-8">\r\n<meta name=ProgId content=Excel.Sheet>\r\n<meta name=Generator content="Microsoft Excel 15">
Which reveals xmlns:x="urn:schemas-microsoft-com:office:excel" i.e. it's from Excel!
Which presumably means you could change behaviour based on where the content is pasted from, and paste plain text? Pasting table data as a markdown table would be above and beyond this bug fix, and should not be considered a duplicate.
