Page 1 of 1
[Solved] Spreadsheet background colours
Posted: Wed Dec 12, 2018 10:04 pm
by helpkeith
My wife has encountered a problem with her spreadsheets. She is unable to display the background colours (colors) although they appear correctly on the menu display. I suspect the problem is in the setting of one of the hundreds of Windows modules - but how can I find out & change it? She is on Windows 7. Your experienced thoughts would be gratefully received. Keith
Re: Open Office Spreadsheet background
Posted: Wed Dec 12, 2018 10:20 pm
by Villeroy
What exactly are you doing to change the back color of which object?
What happens when you try?
What do you expect to happen?
Re: Open Office Spreadsheet background
Posted: Wed Dec 12, 2018 11:04 pm
by helpkeith
Thanks to the team for your quick response. My wife is one of a team using the spreadsheets to transcribe info in parallel & differences are highlighted. These differences are indicated by using background colour in cells for which the transcribers disagree in their readings (the input is from manuscripts dating from about 1710). If the background colours do not work, she cannot tell which data need to be re-checked. The colours are turned on/off using the key-strokes Alt-O, select "cell", press "enter", select "background", select colour required. But these colours no longer display in the cells selected in the spreadsheet. They did until there was a restart problem with her laptop a few days ago. Does this clarify the problem? As I said, I think it's not an Open Office problem, more a Windows feature.
Re: Open Office Spreadsheet background
Posted: Wed Dec 12, 2018 11:26 pm
by Zizi64
Can you upload an ODF type sample file here?
Re: Open Office Spreadsheet background
Posted: Thu Dec 13, 2018 12:22 am
by Villeroy
menu:Edit>View>Highlight Values = OFF (Ctrl+F8 toggles on and off)
Re: Spreadsheet background colours
Posted: Thu Dec 13, 2018 10:53 am
by helpkeith
Hi! Before I fiddle about with sending files, let me give you a couple more symptoms I have noticed.
During the logon period into Windows, one of the welcome screens displays as black on white instead of the usual white on blue. When I go into Open Office, the menu appears on a black background instead of white. This means that the words appear as black on black & are therefore illegible. Does this suggest anything? I have tried Windows troubleshooting without success. By the way, the version says Windows 7 Ultimate on logon. Keith
Re: Spreadsheet background colours
Posted: Thu Dec 13, 2018 8:02 pm
by Zizi64
During the logon period into Windows, one of the welcome screens displays as black on white instead of the usual white on blue. When I go into Open Office, the menu appears on a black background instead of white.
It seems a display driver problem.
Re: [Solved]Spreadsheet background colours
Posted: Fri Dec 14, 2018 10:36 pm
by helpkeith
Many thanks for the clue - I was able to use the troubleshoot option on the control panel display item to establish that there was a fault that could be automatically corrected. Keith