It would be nice to have "Delete All Comments" (UNO?) in Calc that would be under menu Sheet ▸ Cell Comment ▸ Delete All Comments.
That's requested in Bug 84837.
Delete (all) comments can be done via Sheet-Clear Cells by selecting all cells and leaving only comments ticked, but that's not practical, so this enhancement.
I agree, but perhaps for 'selected sheets' that it how works the other options.
Would be a useful command but not one for inclusion in the menus, especially not in the Cell Comment submenu as that submenu is to only have comment related commands for a single cell, and also when the functionality is already available in Sheet > Clear Cells.
https://gerrit.libreoffice.org/#/c/36623/ Code review needed
Gulsah Kose committed a patch related to this issue.
It has been pushed to "master":
tdf#107143 Add delete all comments command.
It will be available in 5.4.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
(In reply to Yousuf Philips (jay) from comment #2)
> Would be a useful command but not one for inclusion in the menus,
How is the user supposed to find and use it then?
> not in the Cell Comment submenu as that submenu is to only have comment
> related commands for a single cell, and also when the functionality is
> already available in Sheet > Clear Cells.
With enhancement bug 84837 we also added View All Comments and Hide All Comments under Sheet -> Cell Comment, which you want under View instead. So where to place Delete All Comment then?
(In reply to Eike Rathke from comment #5)
> How is the user supposed to find and use it then?
The single toggle show/hide entry would be in the View menu (bug 107258).
> With enhancement bug 84837 we also added View All Comments and Hide All
> Comments under Sheet -> Cell Comment, which you want under View instead. So
> where to place Delete All Comment then?
Its fine there as long as we rename 'Cell Comment' to 'Cell Comments'.
Created attachment 132944 [details]
protected sheet with unprotected comments.ods
OK, now exists Sheet ▸ Cell Comments ▸ Delete All Comments and it works (for usual unprotected sheets).
I find this menu command enough and I don't see a need for an icon in the menu.
It doesn't work on protected sheet with comments in unprotected cells. There is somewhat related bug 95883.
Should this be dealt with there or here?
(In reply to Timur from comment #7)
> OK, now exists Sheet ▸ Cell Comments ▸ Delete All Comments and it works (for
> usual unprotected sheets).
> I find this menu command enough and I don't see a need for an icon in the
Yes an icon isnt needed
> It doesn't work on protected sheet with comments in unprotected cells. There
> is somewhat related bug 95883.
> Should this be dealt with there or here?
There as each bug should deal with a single issue.
There is somewhat related bug
dragon ball super episode 116 http://dragonball-super.co/dragon-ball-super-episode-116.html
You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people and i am waiting for your next post keep on updating these kinds of knowledgeable things.
Thanks for the topic and for the answers. Very interesting.
That's useful command. Thanks for sharing.