Spreadsheet background color is black, not what I set it to

Discuss setup / installation issues - Add a spell checker, Language pack?

Spreadsheet background color is black, not what I set it to

Postby antfaber » Wed Dec 05, 2018 12:56 am

I just installed open office on a new computer that I have a black theme on. When I open a spreadsheet, the background color in every cell is black and, in existing spreadsheets, my choices for background color have been overridden. What do I change to make the default background color white and to have it display the background colors I've chosen in cells where I have chosen a different background color.
OpenOffice 4.1.3 on Win 7 Pro
antfaber
 
Posts: 6
Joined: Tue Jul 11, 2017 1:15 am

Re: Spreadsheet background color is black, not what I set it

Postby Bill » Wed Dec 05, 2018 3:20 am

Try changing the background and font colors in Tools > Options > OpenOffice > Appearance. If that doesn't work, try LibreOffice.
AOO 4.1.7 on Manjaro Cinnamon
Bill
Volunteer
 
Posts: 7996
Joined: Sat Nov 24, 2007 6:48 am

Re: Spreadsheet background color is black, not what I set it

Postby ak5520 » Wed Feb 06, 2019 2:32 pm

Bill wrote:Try changing the background and font colors in Tools > Options > OpenOffice > Appearance. If that doesn't work, try LibreOffice.


Sir that is not working for me. I have tried this thing. I have also tried LibreOffice. Can you please guide me.
Last edited by RoryOF on Wed Feb 13, 2019 9:03 pm, edited 2 times in total.
Reason: Edited to remove spam link added later: user banned [RoryOF, Moderator]
OpenOffice 3.1 on Windows Vista
User avatar
ak5520
Banned
 
Posts: 1
Joined: Wed Feb 06, 2019 2:31 pm

Re: Spreadsheet background color is black, not what I set it

Postby Bill » Fri Feb 08, 2019 4:54 pm

It works for me using AOO 4.1.6 on Manjaro. If it doesn't work with OOo 3.1 on Vista., then I can only suggest that you stop using a black theme with open office or find out how to modify the theme so it doesn't change the background color.
AOO 4.1.7 on Manjaro Cinnamon
Bill
Volunteer
 
Posts: 7996
Joined: Sat Nov 24, 2007 6:48 am

Re: Spreadsheet background color is black, not what I set it

Postby dcapn88 » Wed Feb 13, 2019 8:56 pm

I have a similar problem: I just changed the display screen on my laptop, and now Calc for OO4 has a different look and the cell colors on all my spreadsheets do not show (and I cannot get any background colors to show). This is the second time for this problem, but I cannot recall the fix for the last time (it was not a screen change). I can find no help for this on-line or on this site.
OpenOffice 4.1.0 on Windows7 Home
dcapn88
 
Posts: 5
Joined: Wed Jun 18, 2014 8:07 pm

Re: Spreadsheet background color is black, not what I set it

Postby Bill » Thu Feb 14, 2019 3:02 am

I don't know what you actually changed. Did you remove the old screen and replace it with a new one?
AOO 4.1.7 on Manjaro Cinnamon
Bill
Volunteer
 
Posts: 7996
Joined: Sat Nov 24, 2007 6:48 am

Re: Spreadsheet background color is black, not what I set it

Postby dcapn88 » Thu Feb 14, 2019 4:00 am

With a used one. Everything else seems fine with the new-used screen.
OpenOffice 4.1.0 on Windows7 Home
dcapn88
 
Posts: 5
Joined: Wed Jun 18, 2014 8:07 pm

Re: Spreadsheet background color is black, not what I set it

Postby Bill » Thu Feb 14, 2019 1:33 pm

Sorry, but I can't imagine anything that would cause spreadsheet backgrounds to become black by just replacing a monitor screen. It sounds more like a coincidence to me.
AOO 4.1.7 on Manjaro Cinnamon
Bill
Volunteer
 
Posts: 7996
Joined: Sat Nov 24, 2007 6:48 am

Re: Spreadsheet background color is black, not what I set it

Postby RoryOF » Thu Feb 14, 2019 2:39 pm

I could understand a change between Black and White, as this is a byte inversion, but I would expect all other colours to invert also on all applications.
Apache OpenOffice 4.1.8 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31699
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spreadsheet background color is black, not what I set it

Postby RoryOF » Thu Feb 14, 2019 2:52 pm

I think the OP should change the Windows theme to a non-dark theme as a temporary, fault-finding measure, to see if the problem persists.

Please download and try the attached file: A1 is black background and white text, B is White background and black text. B1 and A2 are set to have Gray6 background, no text.
Attachments
test_background.ods
(8.11 KiB) Downloaded 56 times
Apache OpenOffice 4.1.8 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31699
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 6 guests