Apache OpenOffice (AOO) Bugzilla – Issue 100766
copy of cells does not copy the background color
Last modified: 2013-01-29 21:50:23 UTC
I have a spreadsheet that uses different background colors for several cells. If I copy marked cells and do a 'paste special' in another application, the data is pasted but not the background colors. I tried paste special - as HTML Rich Text Image Device Independent Bitmap Nothing works. I tried several target apps (Lotus Notes, Word, OpenOffice Writer) and always the same result - no color. I am pretty sure that Calc does not copy the background color information to the clipboard, but this is obviously an important issue. This is most likely a bug. I tried several other spreadsheet applications and all of them copy the background color information to the clipboard. Calc does not. Btw, text color is copied as expected. Just the background colors are missing.
Checked in OOo3.0.1 and DEV300m53 on WinXP, OOo works well. Paste special - as HTML -> with backgroud color, OOo works well Rich Text -> without backgroud color, OOo works well Image -> I can't find this item Bitmap -> with backgroud color, OOo works well >I am pretty sure that Calc does not copy the background color information >to the clipboard, but this is obviously an important issue. IMO, Calc absolutly copy the backgroud color information to the clipboard, so OOo works very well. Set it "works for me"
Closing Feel free to open it if you don't agree with my checking.
Created attachment 63905 [details] test file to reproduce
I'm sorry. It does not work for me. Even with Ooo 3.1 it does not work. I have attached an .ods file. Steps to reproduce: 1) open test.ods 2) go to sheet 'results1' 3) mark some of the cells 4) control-c 5) open Oo Writer 6) paste special 7) select html There is no color.
The background is not copied to writer in format html, rtf and bitmap, if the background color comes from a conditional formatting with formula. Pasting in gdi shows the background color. Tested with DEV300m53 on WinXP.
Meiying to Regina, >The background is not copied to writer in format html, rtf and bitmap, >if the background color comes from a conditional formatting with formula. I have tested in DEV300m53 on WinXP too. If copy the cell background color comes from a conditional formatting with formula, then paste it to Writer in format html, Can paste the backgroud to the Writer doc. Works well
Created attachment 63928 [details] File for reproducing: Copy cell B4 in sheet1 and paste it to OOo writer
The condition in B4 uses "Cell value is". The error occurs with conditions of kind "Formula is".
The condition in B4 uses "Formula is". I can paste it with backgroud in Writer too. Works well. Regina, would you like checking it once more in DEV300m53 on WinXP?
Created attachment 63930 [details] conditional formatting with condition kind "Formel is"
Open the file i100766.ods from amy2008, goto cell B4, call Format > Conditional Formatting. I see "Cell value is" in the first drop down list. With that kind of formatting the cell background is copied correctly. Open my file i100766 myexample.ods, goto cell A2, call Format > Conditional Formatting. You should see "Formula is" in the first drop down list. Try copy&paste to Writer with my file, for example range A1:A5. There are no background colors in Writer. Tested with DEV300m53.
Regina, Agree with what you said