Loosing background colour when copy/paste table to email

English
,
#1

Hello,

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: 5.1.4.2
Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a

Thank you for your help.

#2

Similar problem when copy a table from website to odt document, loose the background color of cells.

#3

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.

EDIT

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.

#4

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).

#5

… 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

#6

… 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.

#7

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.

#8

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”.

#9

See edited reply.

#10

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.