Ask Your Question
0

One of my sheets is greyed out when open in Libre but not when open in excel

asked 2017-11-23 13:10:58 +0200

PsiPriest gravatar image

One of the sheets of a spreadsheet with several sheets is greyed out (it has a grey background and cells do not show) when I open it with LibreOffice but not when I open it with EXCEL. What causes this? How do I remove the grey background?

edit retag flag offensive close merge delete

Comments

Note that no background is selected for any of the sheets and if I go into formating for that sheet it seems to be formatted in exactly the same way as all the other sheets.

PsiPriest gravatar imagePsiPriest ( 2017-11-23 13:20:27 +0200 )edit

Also, the greyed out sheet does not print?

PsiPriest gravatar imagePsiPriest ( 2017-11-23 13:36:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-07-21 02:45:41 +0200

updated 2019-07-21 02:47:08 +0200

Update: Oops; my answer applies to LibreOffice Writer, even though the question was for LibreOffice Calc. However, the grey bug exists in Writer too, and here's how to fix it in Writer:

It's a bug/glitch. I am observing it in LibreOffice Writer 5.1.6.2 on Linux Ubuntu 16.04.

To fix:

  1. View --> uncheck "Field Shadings (Ctrl + F8)"
  2. View --> re-check "Field Shadings (Ctrl + F8)"

Done! It should be back to white now.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-11-23 13:10:58 +0200

Seen: 775 times

Last updated: Jul 21 '19