I have a spreadsheet I’ve created in Excel 2003 that I would like to use via Open Office Calc 3.2. This spreadsheet has a ton of comments, and in Excel I can view or hide them as I wish. I can’t seem to figure out how to hide them in Open Office. Anyone know?
Bump?
The only way I can find to do it is by right clicking on a cell that contains a comments and then unticking Show Comment from the context menu. I can’t find a global show or hide setting though.
I noticed that when creating a comment in Calc it is not shown by default.
If Imasquare’s advice works, can you just highlight the entire document and untick that checkmark? That might work. Whether they’ll remain hidden next time you open the document depends on how OOCalc saves XLS files.
Unfortunately, it’s been a while since I’ve used OpenOffice–I prefer to mix and match office suite programs. So sorry if this doesn’t help.
Hey, sorry it’s taken me so long to get back to this. Yes, it appears the only way to hide comments is to click on each individual cell. Perhaps one day when I’m either bored or uncharacteristically ambitious I will go through my spreadsheet and hide them all.
Thanks for your help, guys.