Ask Your Question

Remove Hyperlink in Calc

asked 2017-06-12 18:48:59 +0200

dbieniek gravatar image

Right click does not provide an option for removing the link.

Tools>auto-correct>options does not remove the link.

Clinking to get the link menu an removing the link reference does not work.

I am using version (x64)


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-06-12 19:39:49 +0200

librebel gravatar image

Hello dbieniek, to remove the hyperlinks from your cells you could just select the cells and press CTRL+M ( or choose the menu "Format : Clear Direct Formatting" )

edit flag offensive delete link more


It works sometimes, others it does not. It appears to be how I select the cell. Clicking on the individual cell didn't work. However, selecting a group of cells around it, then, CTRL+M did clear them.

Thanks for helping me get on the right track!

dbieniek gravatar imagedbieniek ( 2017-06-15 19:45:40 +0200 )edit

You're welcome @dbieniek, indeed it matters how you select 1 single cell, just make sure that it gets the pink background color for selected cells, by clicking on the cell and drag the mouse around inside the cell until it becomes pink, then press CTRL+M.

librebel gravatar imagelibrebel ( 2017-06-15 20:09:53 +0200 )edit

Quoting @librebel: "by clicking on the cell and drag the mouse around inside the cell"
This doesn't work for me. I need to leave the cell's area in-between while dragging.

First LeftClick, then Ctrl+LeftClick also does the trick.

Lupp gravatar imageLupp ( 2017-10-13 12:39:24 +0200 )edit

Quoting @dbieniek: "It works sometimes, others it does not. It appears to be how I select the cell. ..."
I could no longer reproduce the issue with LibO Calc V5.4.2. Just tested, and the Ctrl+M and 'Clear Direct Formatting' from the menu both worked as expected also if the cell under focus was not highlight-selected. Concerning the ContextMenu it only worked if either it was opened using the shortcut key (Shift+F10) or if the RightClick into the area not was on the linked text itself.

Lupp gravatar imageLupp ( 2017-10-13 12:50:19 +0200 )edit

Still can't remove hyperlinks with Calc Version: (x64)

mcrobert57 gravatar imagemcrobert57 ( 2018-02-06 06:31:52 +0200 )edit

If the Clear Direct Formatting (Ctrl+M) is working for different directly set attributes but not for this pupose though the concerned cells are not protected, I only can suspect your user profile to be corrupted. You may cautiously try to reset it as described here.
(V never showed the issue for me.)

Lupp gravatar imageLupp ( 2018-02-06 10:57:49 +0200 )edit

answered 2017-10-13 12:13:45 +0200

This is a bug that has been reported repeatedly here and here and more. Please add your vote and voice to those bug reports to get them fixed.

edit flag offensive delete link more


These appear to be fairly old bug reports. What is the latest? Or should I add my 2c to those old ones anyway?

mcrobert57 gravatar imagemcrobert57 ( 2018-02-06 06:38:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-12 18:48:59 +0200

Seen: 10,002 times

Last updated: Oct 13 '17