Can’t set background color in individual cells

English
#1

LibreOffice 7.4.7.2, OS Linux 6.1

I can’t set background color in individual cells. Sometimes I get color by double-clicking on a cell, but as soon as I click on another place, the background disappears. I tried also save .ods as .xlsx, but
calc-gaz.ods (13.4 KB)
no difference.

OK, I found the partial workaround: in Debian, Settings Manager > Appearance > Style had changed to “High Contrast”. Choosing anything else allow change the cell background colors. But changing back to “High Contrast” destroys the cell colors again.

#2

Some of the cells are altered (direct formatting and style formatting). Can you recognize the altered backgrounds?
calc-gaz_grantler.ods (14.4 KB)


EDIT
@laguna
Is this question connected to your question in

How to convert Calc spreadsheet into web application

?

#3

Yes, I can see cell colors backgrounds in your file. But only when in Debian, Settings Manager > Appearance > Style is in a different position than “High Contrast”. I don’t think if I can use calculator without direct formatting and style formatting, so yes, cells will be altered.

No direct relation to my another question though.

#4

He had appended the question there and I suggested to keep this separate.

So you can actually change the colour, but high contrast prevents visibility on your screen.

1 Like
#5

In Calc, click Tools - Options - LibreOffice - Accessibility and set High Contrast to Disabled.

Click the Help button in the dialogue if you want to see the reason

#6

there is no option High Contrast. There is “Automatically detect high contrast mode of operating system” - its already unchecked, but this not help. OS settings override LibreOffice settings.

#7

Try and see if it works with a temporary user profile, LibreOffice user profile - The Document Foundation Wiki

Make sure to untick Automatically detect high contrast mode of operating system in the temporary profile

#8

It works with a temporary user profile, but only when Debian Settings > Appearance > Style is not a “High Contrast” theme.

#9

Try unticking Automatically detect high contrast mode of operating system and then restarting the system. Otherwise, it sounds like a problem with your installation of LibreOffice if unticking Automatically detect high contrast mode of operating system in the temporary profile has no effect.

Disabling High Contrast in LibreOffice when the system is set to High Contrast definitely works in my Mint Linux

Version: 25.8.4.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-NZ (en_NZ.UTF-8); UI: en-US
Ubuntu package version: 4:25.8.4~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded

#10

In a temporary user profile the option “Automatically detect high contrast mode of operating system” has already been unticked.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.