Steps to reproduce:
1. create a comment to a cell
2. right click that cell
3. observe context menu does not offer option to edit the comment
provided "edit comment" item in context menu
I note that:
1. The version of ms excel that I use does provide this item in the context menu, and I am therefore accustomed to having it there.
2. The current procedure to edit a comment, which is not going to be obvious to a naive user, apparently is as follows:
a. right click cell
b. select 'show comment' from context menu.
(Naive user: "What, the comment was already showing"
-- so this is a poor choice of wording.)
c. left click on comment to make it editable.
(Not obvious you need to do this to a naive user.)
d. do whatever editing is required.
e. left click on affected cell
f. select "hide comment."
(Naive user: "What, I don't want to hide the comment,
I want it to show when I hover over the cell" -- again
poor choice of wording.)
Wow, what a pain in the butt!
Now, let's compare to the equivalent process in my excel version:
a. right click cell
b. select "edit comment" from context menu.
c. edit the comment.
d. left click affected cell or anything else to return
to hover-shows-comment mode.
Note that fixing this could maybe share code with bug 83948.
Also note that I am using Version: 220.127.116.11, an option which was not offered in the pulldown for this bug report.
Operating System: Windows 7
Version: 18.104.22.168 release
Thank you for your bug report.
Was just about to submit this same bug. :D
Basically the label should be 'Edit Comment' rather than 'Insert Comment' when a cell has an already existing comment.
Aha. Thanks. I did not notice that "insert comment" actually means "edit comment" in this context.
So, in case anyone is listening, this requires a check whether there is or isn't an existing comment, then providing the appropriate verbiage in the context menu.
For that matter, a less elegant but easier [temporary] fix is to just change the wording in the context menu to "Insert or Edit Comment."
I think the quick fix might be just to change it to 'Edit Comment' because you are editing it if it exists or not. :D
Ravindra_Vidhate committed a patch related to this issue.
It has been pushed to "master":
tdf#84153: "Edit Comment" in context menu when a cell has a comment
It will be available in 5.0.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.
Migrating Whiteboard tags to Keywords: (needsDevEval)