Ask Your Question

Why LO won't show cell content [closed]

asked 2017-02-01 15:39:06 +0200

Aigars gravatar image

updated 2017-02-01 15:41:44 +0200

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: image description

And here's how it looks: image description

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Aigars
close date 2017-02-02 08:32:40.172595


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?

stanton gravatar imagestanton ( 2017-02-01 18:25:15 +0200 )edit

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.

Aigars gravatar imageAigars ( 2017-02-02 08:29:04 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2017-02-02 08:31:46 +0200

Aigars gravatar image

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: image description

edit flag offensive delete link more

answered 2017-02-01 22:39:33 +0200

Zjho gravatar image

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

edit flag offensive delete link more

answered 2017-02-02 08:05:13 +0200

pierre-yves samyn gravatar image


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


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-02-01 15:39:06 +0200

Seen: 126 times

Last updated: Feb 02 '17