Gridlines in a spreadsheet are a display option in the SS software, not transferable to Thunderbird.

Gridlines in a spreadsheet are a display option in the SS software, not transferable to Thunderbird.

How to solve this issue? but I found that Outlook has not this issue.

With version 128 anyway, after you paste a table into a new message it seems to show it with the cells surrounded be a red dotted line of sorts.

Anyway, click somewhere in the table, then on the top menu, select Format -> Table -> Table Properties and set the Border to 2 pixels or something and apply it. Should change the table cell borders to black lines. When checking the email, I see the table with the grid lines then.

Never messed with inserting tables before so I don't know if there's a way to make it do this by default.

I was pasting from LibreOffice Calc. The table I pasted did not have any cell borders defined. If I were to have printed it from LibreOffice, no grid lines would have printed.

I then tried pasting in a table that had a border line defined under the column headers so that it would be there when printed. When I pasted that in, there was a black line shown where that cell border was defined and I saw it when I received that test email.

So, it seems to handle cells borders when pasting the same way as if the table was printed.

Hope that helps, Mark H.

With version 128 anyway, after you paste a table into a new message it seems to show it with the cells surrounded be a red dotted line of sorts. Anyway, click somewhere in the table, then on the top menu, select Format -> Table -> Table Properties and set the Border to 2 pixels or something and apply it. Should change the table cell borders to black lines. When checking the email, I see the table with the grid lines then. Never messed with inserting tables before so I don't know if there's a way to make it do this by default. I was pasting from LibreOffice Calc. The table I pasted did not have any cell borders defined. If I were to have printed it from LibreOffice, no grid lines would have printed. I then tried pasting in a table that had a border line defined under the column headers so that it would be there when printed. When I pasted that in, there was a black line shown where that cell border was defined and I saw it when I received that test email. So, it seems to handle cells borders when pasting the same way as if the table was printed. Hope that helps, Mark H.

All of these ways are complicated, Can this be solved from Thunderbird?

re :but I found that Outlook has not this issue.

Outlook is a Microsoft product and so is Excel etc. Microsoft is not in the habit of sharing it's code with none Microsoft products. So I'm not surprised that it works in Outlook.

If you need to share Excel documents with others via email then use the best method which is attaching the excel document. That means the recipient can use the appropriate software to see the data, but please note not everyone uses Microsoft Office products, so you might want to be sure they can actually open excel documents. I use Open Office which does a reasonable job.

You can insert data by using Edit > 'Paste without formatting' That works fine if you are only inserting copied text, but since all formattingis removed it's not going to solve a 'table' display issue.

Another alterative: Create a screendump image of the data in excel sheet and save as a jpg image, then insert the image into email instead either inline or as an attachment. After all, if you are only displaying data, an image would work perfectly well. It also means anyone can easily open an image to see the information.

It can not be solved from Thunderbird because Excel does not put the border information on the clipboard when it pastes to the HTML format for it to be pasted into Thunderbird.

Except I just tried it with the most recent version of Excel I have installed, and my formatted table appeared in Thunderbird just as it appeared in Excel. Just be warned here though. If the boxes in Excel do not appear on printed paper they will also not paste. So try print preview with your excel data. Does that show borders? If not you need to format your excel sheet to include them before you copy.

But why some third-party email clients have no this issue? such as foxmail: https://www.foxmail.com So there is a way to solve this issue.

See Bug 195012 - Retain fonts/styles when pasting tables from Excel into composition window