Why LO won't show cell content

Hi! I have made an .ods spreadsheet containing table with numbers and texts. The table is formatted with background colors. On both my computers everything is fine, but the third PC won’t display cell content. When I select the cells, open the right-click menu and select “Clear Direct Formatting”, cell content appears. It’s not font color, I checked that.

Here’s how it should look:

And here’s how it looks:

Thus far only one PC out of three is having this issue. What could be the problem?

Could it be that the font you used in the spreadsheet is installed on your two PCs but not on the third? (Does the font face, as displayed in the formatting toolbar, change when you remove all direct formatting?) Just a guess, but do all three PCs run the same version of LO?

You are correct, it was the font. I don’t know what’s wrong with it on the third PC, but when I change it, the text appears. Thanks for the idea.

Could be a keyboard Page Down key sticking as happens on my Logitech K800 keyboard sometimes.


You can try to (un)tick each option in ToolsOptionsAccessibilityOptions for High Contrast


As Stanton suggested, the problem was the font. It might be damaged in the third PC and when I change it, the text appears.

Even font preview shows the text already: