[Solved] Background colors won't show in spreadsheet

Issues with installing under all versions of MS Windows
Post Reply
GardenSpider
Posts: 2
Joined: Sun Dec 09, 2007 11:14 pm

[Solved] Background colors won't show in spreadsheet

Post by GardenSpider »

I am unable to change the background and border colors in the spreadsheet in Calc. I was using Format/Cells/Background. But the background stays white and borders are always black. I can change the text color with no problem.

Initially, the background and border colors were missing in the Page Preview also. I turned off Tools/Options/OpenOffice.org/Accessibility/Use system colors for page previews. The backgrounds and borders now display the correct colors in Page Preview, but not in the spreadsheet.

I was using Microsoft Windows XP Home Edition and Open Office Calc 2.1. Upgrading to 2.3 didn't help.
Last edited by GardenSpider on Mon Dec 10, 2007 9:59 pm, edited 1 time in total.
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Background colors won't show in spreadsheet

Post by acknak »

Create a new user login and try running OOo from that login. If that works, you may have problems with your normal user settings (profile) and need to rename them or remove them.
AOO4/LO5 • Linux • Fedora 23
GardenSpider
Posts: 2
Joined: Sun Dec 09, 2007 11:14 pm

Re: Background colors won't show in spreadsheet

Post by GardenSpider »

Thanks. That helped narrow down my search.

The Accessibility settings were causing the problems. My computer is usually in High Contrast mode. It looks like Open Office doesn't completely compensate for that.

High Contrast can be turned off permanently: Start / Control Panel / Accessibility Options / Display / Use High Contrast / uncheck. Or, more conveniently, it can be toggled on and off: left ALT + left SHIFT + PRINT SCREEN.
Post Reply