Bug 75421

Summary: Show comment is not available anymore for a cell when cell content is a link
Product: LibreOffice Reporter: xtrailrunner <juergenmenge>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: jbfaure, jmadero.dev, pierre-yves.samyn
Priority: medium    
Version: 4.2.1.1 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description xtrailrunner 2014-02-24 06:48:17 UTC
If a comment is stored inside a cell normally I can show this comment by using the context menu for the cell. When there is a mail adress or hhtp adress stored as content in the cell the option to display the comment will not shown anymore in the context menu. In previous relased is was displayed. The problem is that it is not possible to see the comment anymore except hovering over the cell.
The workaround I found is to remove formatting from the cell (clear formatting).
Comment 1 Jean-Baptiste Faure 2014-03-01 22:41:00 UTC
It works for me if the cell is wide enough to have a little empty space after the hyperlink. In such a case, if you right click on the link you get the contextual menu of the link and if you right click on the empty space at the end of the cell, you get the contextual menu of the cell and you can choose the entry "Show comment".
In version 4.1.5 it is the contextual menu of the link that you can't get.

For me the current behavior is not a bug.

Best regards. JBF
Comment 2 Joel Madero 2014-03-02 16:42:11 UTC
Tested on:
Ubuntu 13.10 + Cinnamon DE
LibreOffice 4.1.5, 4.2.1, 4.3 master build from yesterday

All work. What I noticed is that you can't right click on the link itself or you get the context menu for links - but if you right click anywhere else in the cell (ie. make sure the cell is wide enough to not click on the link itself) - it works as expected.

Marking as WFM
Comment 3 xtrailrunner 2014-03-14 20:15:25 UTC
I have a spreadsheet with lots of very long hyperlinks (URL parameters). I can't extend the cell size to such an extent that these links fit into a cell. I'm sure that it worked in previous releases because I use this functionality for a long time and noticed the change immediately after updating to the current release candidate.
Comment 4 Jean-Baptiste Faure 2014-03-15 14:58:16 UTC
The problem is that you have two contextual menus, one for the cell (which allows to show the comment) and one for the hyperlink. In previous versions, only the contextual menu of the cell was reachable.

That said, it works if you right-click exactly on the border of the cell just before the pointer becomes an hand indicating that you are pointing on an hyperlink. Ok, it's not very easy ;-)

Other workarounds:
1/ use HYPERLINK() function instead of automatic recognition of link.
2/ select the whole column and right-click in another cell in the column; that shows all comments in the column.

Best regards. JBF
Comment 5 pierre-yves samyn 2014-05-24 18:59:44 UTC
Hello

Other workarounds, select the cell then: 
-Shift+F10 opens the context menu, everything available
-Insert> Comment, you can edit the comment

So works for me too...

Regards
Pierre-Yves