Bug 84837

Summary:	VIEWING: Add option in View menu to hide and unhide comments
Product:	LibreOffice	Reporter:	Jay Philips <philipz85>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	cno, gtimur, raal
Version:	Inherited From OOo
Hardware:	Other
OS:	All
Whiteboard:
i915 platform:		i915 features:
Bug Depends on:
Bug Blocks:	85594

Description Jay Philips 2014-10-09 13:32:37 UTC

While following the 'libreoffice' keyword on twitter, i stumbled on a tweet at < https://twitter.com/PascalRichier/status/519994784942141440 > where the user linked to a macro to hide comments in calc < http://moorlater.com/2014/05/22/macro-to-hide-all-comments-in-libreoffice-calc/ >. Looking that writer has the ability to hide and unhide comments in its View menu, i think it maybe useful to also have it in calc.

Comment 1 Cor Nouws 2014-10-09 14:37:17 UTC

Hi Jay ;)
Is the current summary what is meant?

Another question: I guess it must handle all comments selected cells ?

(Drat: some time back a feature was introduced that via context menu all comments could be made visible - is lost now ..)

Comment 2 Jay Philips 2014-10-09 14:52:32 UTC

Hi Cor,

Your modified summary is fine and yes it should hide all comments that are visible, as i'm assuming thats what the macro is doing.

The macro seems to have been created primarily because xlsx files in LibO were in 3.5 always showing comments (bug 45874).

Comment 3 raal 2014-10-18 04:57:17 UTC

You can select whole sheet (CTRL+A) -> Right click -> Hide comment/Show comment

Comment 4 Timur 2014-10-31 10:53:28 UTC

Repeating https://bugs.freedesktop.org/show_bug.cgi?id=85594#c2 I think that there should be:
1. 'Show All Comments' and 'Hide All Comments' in View menu
2. new buttons with icons for 'Show All Comments' and 'Hide All Comments' in Standard toolbar
It's only available now from ShowNotes extension http://extensions.libreoffice.org/extension-center/shownotes.

(In reply to raal from comment #3)
> You can select whole sheet (CTRL+A) -> Right click -> Hide/Show comment
I took some test file with a couple of comments and saw that it takes 10 seconds in LO 4.2. and 4.4. for that, I don't know why it's so slow, while ShowNotes works immediately.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.