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.6 and LO 6.2.0.3 on Manjaro MATE
Bill
Volunteer
 
Posts: 7319
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.6 and LO 6.2.0.3 on Manjaro MATE
Bill
Volunteer
 
Posts: 7319
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.6 and LO 6.2.0.3 on Manjaro MATE
Bill
Volunteer
 
Posts: 7319
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.6 and LO 6.2.0.3 on Manjaro MATE
Bill
Volunteer
 
Posts: 7319
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.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29434
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 20 times
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29434
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 9 guests