Bug 31672 - Background Color not overriding
Summary: Background Color not overriding
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86 (IA32) Windows (All)
: medium minor
Assignee: Katarina Behrens
Whiteboard: (target:4.3.2)
Depends on:
Reported: 2010-11-16 11:13 UTC by junkedjd
Modified: 2014-10-16 20:18 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

When Color Scheme has White BG (1.43 KB, image/jpeg)
2010-11-16 11:13 UTC, junkedjd
Muted BG colors when scheme BG color is blue grey (1.44 KB, image/jpeg)
2010-11-16 11:14 UTC, junkedjd
Cell BG colors completely disappear when schema BG color is black (1.54 KB, image/jpeg)
2010-11-16 11:15 UTC, junkedjd

Note You need to log in before you can comment on or make changes to this bug.
Description junkedjd 2010-11-16 11:13:03 UTC
Created attachment 40316 [details]
When Color Scheme has White BG

When the windows color scheme has a background color other than white, background colors specified for a cell or group of cells gets muted or completely ignored.

It's almost as if the scheme background color is used to reduce the RGB of the cell background color.
Comment 1 junkedjd 2010-11-16 11:14:35 UTC
Created attachment 40317 [details]
Muted BG colors when scheme BG color is blue grey
Comment 2 junkedjd 2010-11-16 11:15:22 UTC
Created attachment 40318 [details]
Cell BG colors completely disappear when schema BG color is black
Comment 3 junkedjd 2010-11-16 11:18:11 UTC
I would expect that setting the cell background color should override any existing background colors in place.
Comment 4 Kohei Yoshida 2010-11-16 12:59:32 UTC
This is a known issue.  Someone else reported similar bug against Writer, but it's the same problem.

My tentative idea is to always use white as the document default background, regardless of themes.
Comment 5 Kohei Yoshida 2010-11-16 18:46:47 UTC
This was reported here too.

Comment 6 Kohei Yoshida 2010-11-19 07:21:29 UTC
Re-assigning to Katarina (bubli).
Comment 7 Rainer Bielefeld Retired 2011-03-13 07:43:23 UTC
Modified version to the one most nearby to the report.
A quick search found 2 unfixed bugs with target 3.3.1:
Bug 30800 - UI: grid lines disappeared in Calc for cells with background colour
Bug 31672 - Background Color not overriding.
New target?
Comment 8 Marián Kyral 2011-06-14 05:49:25 UTC
Any progress about this?

I just tested LibreOffice 3.4 and it still doesn't work. I'm using dark theme. Does not matter whether I set background color to white or automatic (dark), background colors on cells are not visible. It make me crazy sometime.

Please fix it.
Comment 9 Marián Kyral 2011-12-02 03:19:51 UTC
I'm actually testing current 3.5 branch from Gentoo package. Compiled with KDE support. Dark theme is used. Colors in cels are still not visible. 

LibreOffice 3.5.0 
Build ID: 350m1(Build:0)
Comment 10 Björn Michaelsen 2011-12-22 12:44:01 UTC
remove long missed 3.3.1 target
Comment 11 bfoman (inactive) 2013-05-16 10:40:27 UTC
This bug has not been touched by its owner for a long time. To make it clearer which bugs should be fixed by someone else please take following action:
- If you are the owner, and you are actively working on the bug, please give it an update. 
- If you are the owner, and you do not plan to work on it in the near future,
please reassign it to the default assignee and change its status to NEW.
Comment 12 Julien Nabet 2014-10-16 20:18:00 UTC
On pc Debian x86-64 with 4.3.2 LO Debian package, I don't reproduce this.
Idem on Win7 + 4.3.2 LO package.

I put Document background in Tools/Options/Appearance/Custom colors at black and cell background colors could still work.

If I missed something, don't hesitate to reopen this tracker and please give me some extra hints to reproduce it! :-)