Ask Your Question

loosing background colour when copy/paste table to email

asked 2016-07-26 14:45:48 +0200

miro gravatar image

updated 2016-07-26 15:49:04 +0200


I want to copy a table where cells have a background colour based on a condition. When I copy/paste the table in an email ( like gmail) the background colour is not copied and the cell has a white background. But : if the background colour is not obtained from a conditional formating (= you simply change the background colour of the cell with ctrl+1 for example) , then the background colour does appear whe you copy/paste in my email.

Is this a setting that needs to be changed in calc ?

Version: Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a

Thank you for your help.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-07-26 17:21:01 +0200

floris v gravatar image

updated 2016-07-28 11:04:12 +0200

No. It's decidedly not something wrong about Calc. An e-mail message body cannot get formatting beyond what HTML has to offer, and HTML, as far as I know, doesn't cater for conditional formatting. Send the file as an attachment and the recipient will be able to view all you put into it.


After a lot of tinkering about with this I found that conditional formatting based on the cell values can be copy/pasted to the Thunderbird mail editor, but conditional formatting based on the formula MOD(ROW();2)=0, or something like that, can't. The only thing that seems to work is to first copy to a Writer document, then copy the pasted copy and paste that into the mail editor.

edit flag offensive delete link more


Hello, I actually want to copy my table with the background colour, not the condition. I have a conditional formating in order to alternate row colors in a filtered table. If I understand well, the issue comes from the fact that conditional formating doesn't "simply" take the background color when you want to copy/paste to a wysiwig editor ? I mentioned gmail, but I also need to paste the tables in my phplist for a mailing (wysiwyg editor).

miro gravatar imagemiro ( 2016-07-27 01:23:55 +0200 )edit

... I have noticed that the cell with a background color obtained via conditional formating, doesn't show a backgroung when you press ctrl+1 .. you only see a background color on the screen. In that case if you copy and paste the table the background color will not appear in the wysiwig editor. If the cell has been colored with a "real" background ( = you can see it with ctrl+1) then when you copy/paste in an other wysiwig editor you do see the background color. Sorry for my basic explanations

miro gravatar imagemiro ( 2016-07-27 01:30:06 +0200 )edit

... but when you use excel or google sheets with such conditional formating ( alternate row colors), then you can copy and paste with the formating ( = cell background colors) not the conditions. So I wonder if it is a setting to be changed in calc or it is a normal behavior.

miro gravatar imagemiro ( 2016-07-27 01:34:39 +0200 )edit

Reread my reply carefully. HTML doesn't have tags for conditional formatting and therefore can't display it. That has nothing to do with Calc or Excel. It's normal behavior.

floris v gravatar imagefloris v ( 2016-07-27 10:06:04 +0200 )edit

Hello Floris. Yes I do understand what you have written about HTML and conditional formating tags. The fact is that in order to alternate row colors in a filtered table I must use conditional formating, and then I want to copy that table in a wysiwig editor for a mailing. My question is how can I copy/paste a table with the alternate row colors ? In excel or google sheets you just copy/paste and it works, the background color is copied not the condition "logic".

miro gravatar imagemiro ( 2016-07-28 10:01:48 +0200 )edit

See edited reply.

floris v gravatar imagefloris v ( 2016-07-28 11:04:57 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-26 14:45:48 +0200

Seen: 1,292 times

Last updated: Jul 28 '16