No background color when pasting cells from Calc as RTF in Writer
Steps to Reproduce:
1. open Calc
2. Add a background color to the cells
3. Copy them
4. Special as RTF in Writer
The other way around is working (table in Writer), pasting it as RTF in Calc.
Work around: HTML paste
No background color
Should be working.
User Profile Reset: No
Build ID: 7e1cabd96526cb7befc5ea5073358093efbe12d0
CPU threads: 4; OS: Windows 6.3; UI render: default;
TinderBox: Win-x86@42, Branch:master, Time: 2018-06-27_23:39:20
Locale: nl-NL (nl_NL); Calc: CL
I confirm it with
Version: 126.96.36.199.beta2 (x64)
Build ID: 0f4d2060bc90b4008fbc8e6d9a49ec7eeea60b78
CPU threads: 4; OS: Windows 10.0; UI render: GL;
Locale: en-US (de_DE); Calc: CL
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
Still present in
Version: 188.8.131.52 (x64) / LibreOffice Community
Build ID: f67b1ddedeb24fca1c5938e7cebfab73d708b35b
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-GB
I'm assuming this and bug 93362 are somewhat related (feel free to correct me if not).
Sample spreadsheet with some conditional formatting as well (which doesn't get copied, either): attachment 147289 [details]
Perhaps this is related to bug 112053?
In the sense that both are pointing at the same fact that the background color is not supported?
If the original OOo implementation was to mimick MSWord on Windows, then this is by design:
\cbN Background color (default is 0).
N specifies the color as an index of the color table.
Note: Windows versions of Word have never supported this control word (see \chcbpatN for Word background color).
I can reproduce this simply on Mac with TextEdit, saving the string "cowsay" with a black background produces (on the relevant lines) the code:
> \f0\fs24 \cf2 \cb3 cowsay
pasting the same RTF content into LO makes the black background disappear, and saving the file as RTF does not include the \cb3 (for black) as expected: