Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | copy of cells does not copy the background color | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | tessarek <tessarek> | ||||||||
Component: | formatting | Assignee: | AOO issues mailing list <issues> | ||||||||
Status: | CONFIRMED --- | QA Contact: | |||||||||
Severity: | Trivial | ||||||||||
Priority: | P3 | CC: | amy2008, issues, rb.henschel | ||||||||
Version: | OOo 3.0.1 | Keywords: | oooqa | ||||||||
Target Milestone: | --- | ||||||||||
Hardware: | PC | ||||||||||
OS: | Windows XP | ||||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||
Developer Difficulty: | --- | ||||||||||
Attachments: |
|
Description
tessarek
2009-04-01 20:41:50 UTC
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 |