Ask Your Question

How to hide all comments in Calc (Libre Office 4.2)? [closed]

asked 2014-07-19 13:55:38 +0100

Johnny S. gravatar image

updated 2020-08-09 14:46:41 +0100

Alex Kemp gravatar image

Since last Libre Office update, all comments on a Calc page are appearing, obscuring view of cell content, and the only way to hide them seems to be to click on the individual cells, one at a time. When the sheet is re-opened the next time, all the comments are visible again. Very annoying, please help!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-09 14:46:50.328112


This must be a newly introduced bug. With .xls the comments act as expected, but as .xlsx they all show, when they shouldn't.

rd21292 gravatar imagerd21292 ( 2014-12-20 19:38:28 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-07-19 16:25:15 +0100

m.a.riosv gravatar image

Click on the blank top-left box of the rows-columns header, to select all cells, or the range you want, and right-click on any cell on the selected range and select hide.

edit flag offensive delete link more


Thank you: so simple, yet it worked! I feel very stupid now, but can't tell you how relieved I am!

Johnny S. gravatar imageJohnny S. ( 2014-07-22 19:50:37 +0100 )edit

This hides the comments in the open sheet, but when I close it and re-open I have the same problem. Can the file be saved as it appears when I close it?

Alan T gravatar imageAlan T ( 2014-09-26 12:19:29 +0100 )edit

In version, this showing all comments all the time is there, for at least the .xlsx file format. What setting needs to be set to have comments only show when the mouse hovers over the cell? Saving as .xls works, but why not in .xlsx?

rd21292 gravatar imagerd21292 ( 2014-12-20 19:39:06 +0100 )edit

But saving as .xls means having to deal with the row heights problems, which means we have to choose between not having comments always show vs. normal editing of cells causing rows to get higher when they shouldn't. We have to decide which bug causes the least problems.

rd21292 gravatar imagerd21292 ( 2014-12-21 17:51:10 +0100 )edit

I joined because of helpful info like this! Sadly, I cannot yet upvote...sniff

DavidM123x gravatar imageDavidM123x ( 2019-01-10 02:05:33 +0100 )edit

answered 2015-04-22 00:02:28 +0100

You can check this extension:

It worked super for me. Also supports xslx xls and odf formats.


edit flag offensive delete link more


Nemo_bis gravatar imageNemo_bis ( 2017-10-01 14:56:06 +0100 )edit

Question Tools



Asked: 2014-07-19 13:55:38 +0100

Seen: 7,770 times

Last updated: Apr 22 '15