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'.