But before we get into that, how are you doing the copying/pasting? Is it paste special of the graphics, or a straight paste of the Calc cells?Īcknak wrote:Are you pasting with a simple paste, or are you using Paste Special and choosing some specific data format?

If necessary, I can try to dust off some of that stuff, I think I still have all the pieces. There were also some strange problems about the formats only copying correctly if the cells were visible on the screen during the copy. I wound up writing some rather tricky macros to do the copying. I had some PM exchanges with dummydecoy as a result of that. Similar problems have come up before: viewtopic.php?f=9&t=43083&p=198721

Is there a technique or work-around that gets me the correct cell color in a pasted image file? But, when I copy the cell-set of the form to an OO-Writer document (so I can have history for my work), the cell colors al=ways turn into the last condition (which is, in this case, this does not work) when pasted into my document. Lew_Merrick wrote:Acknak - Conditional formatting works within the spreadsheet.

Openoffice calc cell color