[Solved] Spreadsheet background colours

Discuss the spreadsheet application

[Solved] Spreadsheet background colours

Postby helpkeith » Wed Dec 12, 2018 10:04 pm

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
Last edited by helpkeith on Fri Dec 14, 2018 10:33 pm, edited 1 time in total.
Open Office 4.1.6 on Windows 7
helpkeith
 
Posts: 4
Joined: Wed Dec 12, 2018 11:12 am

Re: Open Office Spreadsheet background

Postby Villeroy » Wed Dec 12, 2018 10:20 pm

What exactly are you doing to change the back color of which object?
What happens when you try?
What do you expect to happen?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26104
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Open Office Spreadsheet background

Postby helpkeith » Wed Dec 12, 2018 11:04 pm

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.
Open Office 4.1.6 on Windows 7
helpkeith
 
Posts: 4
Joined: Wed Dec 12, 2018 11:12 am

Re: Open Office Spreadsheet background

Postby Zizi64 » Wed Dec 12, 2018 11:26 pm

Can you upload an ODF type sample file here?
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.4 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.1.4 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7576
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Open Office Spreadsheet background

Postby Villeroy » Thu Dec 13, 2018 12:22 am

menu:Edit>View>Highlight Values = OFF (Ctrl+F8 toggles on and off)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26104
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spreadsheet background colours

Postby helpkeith » Thu Dec 13, 2018 10:53 am

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
Open Office 4.1.6 on Windows 7
helpkeith
 
Posts: 4
Joined: Wed Dec 12, 2018 11:12 am

Re: Spreadsheet background colours

Postby Zizi64 » Thu Dec 13, 2018 8:02 pm

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.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.4 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.1.4 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7576
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved]Spreadsheet background colours

Postby helpkeith » Fri Dec 14, 2018 10:36 pm

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
Open Office 4.1.6 on Windows 7
helpkeith
 
Posts: 4
Joined: Wed Dec 12, 2018 11:12 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 18 guests