Created attachment 122931 [details]
Example of the "hyperlinks"

I'm using Mac OS X El Capitan and not tested elsewhere.

When entering URL in a cell in Calc, after hitting enter it automatically turns into a hyperlink. This is a style of hyperlink with a grey background and blue text.

Several problems now exist:

1. Hitting CTRL+Z does not undo the auto-hyperlink, rather, it actually removes the entire text. Seems the auto linking is not considered an undoable action and it should be.

2. You can no longer select the cell. Clicking the cell does nothing and keeps the current cell selected - it does not change selection to the clicked cell - it seems the hyperlink steals the click but because you did not Command+Click it does not open anything either, so nothing happens

3. If you use arrow keys to move the cell selection to a cell with a hyperlink (which is the only way to highlight it), you cannot edit the hyperlink text, it appears like a single block inside the text that cannot be modified within it.

4. Also, if you select with arrow keys, and then you RIGHT-CLICK the hyperlink in the formula bar (not in the cell), the text in the cell itself loses its highlighting and style. If you then click on another cell elsewhere, the hyperlink is now gone! Just by right-clicking!

5. An even worse right-click issue is after you right-click it, the cursor is in formula bar at the start and the highlighting in the cell is vanished - if you now move the cursor to after the hyperlink in the formula bar and start typing, your text appears in-between the first and second characters in the cell! So the formula bar becomes completely out of sync with the cell itself.

6. More issues too. If the hyperlink itself overflows into the next column, if you right-click the part of the hyperlink in the cell that overflows into the next column, context menu appears, and if you then cancel context menu by clicking anywhere else such as on another cell, the column underneath it now gets focus and the cell is entered and the text carrot appears. This does not happen anywhere else which is annoying. Normally if you right-click a cell and then cancel the right-click, the cell you right-click just gets focus, it doesn't show the carrot. Similar thing happens when you right-click the hyperlink cell itself, on cancelling context menu by clicking elsewhere you find yourself with text cursor inside it at end of hyperlink.

7. There should be a remove hyperlink on the context menu either way when you right-click a hyperlink.

I've had a nightmare with this where I've been needing to copy paste URLs and modify the stems.

I've attached a file showing two hyperlinks automatically created by entering URLs. (I'm actually wondering if these are even hyperlinks though... as it's so badly broken and they don't LOOK like I would expect hyperlinks to look with blue text and underline... Unless the styling is a point 8?)