Ask Your Question

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

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

Johnny S. gravatar image

updated 2015-08-28 09:24:52 +0200

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 close merge delete


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 +0200 )edit

2 Answers

Sort by » oldest newest most voted

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

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 +0200 )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 +0200 )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 +0200 )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 +0200 )edit

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

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

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

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 +0200 )edit
Login/Signup to Answer

Question Tools



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

Seen: 6,665 times

Last updated: Apr 22 '15