Interplay Gnome Accessibility and LibreOffice Calc

My experimentation with Gnome Settings > Accessibility > Seeing > High contrast has left me in a place I don’t want to be.

Having made the High Contrast setting, I opened a LO Calc file that contains rows of data for each day since February 2021. Some calculated fields have conditional formatting, others just calculated values. Background colours of all fields (including conditionally formatted ones) were eliminated (i.e. white), text colours of conditionally formatted alone retained. I experimented a little to see what might be possible in this situation, (but leaving the file, in general, in its original state, saved it and reset the High Contrast to ‘off’. High Contrast was not for me in this case.

On opening the file next day…shock!! All data fields (whether entered or calculated) except header lines and conditionally formatted fields were blank. To see my data, I had to reselect High Contrast.

Clearly, I can try to restore an older file and re-enter the latest days’ data. But the High Contrast toggle seems to be partly irreversible. By the way, the file preview in LO main page is totally blank whether High Contrast is ‘on’ or ‘off’.

Can anyone tell me how otherwise to restore my LO Calc file to its original (pre-High Contrast) state?

Problem partially solved! My mistake was to have experimented with background colours without realising that ‘no fill’ had been selected for background, so I suppose I was displaying white text on white background…

But nevertheless on saving and reopening the apparently repaired Calc file the fields all still all blank.

@hnimmo If you create a test user, log in as that test user and confirm if the issues is present there, if not then it will be a config for the affected user, rather than a system wide issue.

How do I give a test user access to ‘my’ files?

Not sure if ‘white on white’ is the correct explanation, so I take that back. What I can say is that a double-click on any occupied cell reveals its contents. Blank returns on leaving the cell.

@hnimmo use one from a backup? Create a quick test one? Copy the file over as root user and change ownership to the test user?

I copied the file to the test user. It shows exactly the same behaviour as under ‘my’ account.

@hnimmo then that sounds like a bug for sure, I suggest starting here to create one https://en.opensuse.org/openSUSE:Submitting_bug_reports. I think your opening post explains your issue.

Bug submitted 1245645 – Anomaly after resetting GNOME Accessibility High contrast toggle

1 Like