In version 3 of calc, you could remove all the hyperlinks from a range of cells by selecting the cells and choosing "Clear Direct Formatting." That does not work in version 4. I see that https://bugs.freedesktop.org/show_bug.cgi?id=33604 reports this is not a bug for Writer in version 3.3 and is two years old. The equivalent functionality was available in Calc at that time.
If this feature has been intentionally removed from Calc, do you expect us to edit each individual cell separately to remove that cell's link? That would be absurd. If you choose to mark this "notabug," I will have to revert back to version 3.
I realize that I can use cut + paste special/text to do this, but some of the cells may have numbers or formulas. Personally I would prefer an explicit "Remove Hyperlink" option in the menus instead of "Clear Direct Formatting."
Could you pls check in 4.0.2? I can just select more cells there with links, hit Ctrl+M and all links are removed...
Both Ctrl-M & "Clear Direct Formatting" work on LO 22.214.171.124 (Win7 Home Premium 32bit)
Mark as 'enhancement' because of request to have "Remove Hyperlink" option in menu.
For the sake of usability, I suggest to reuse the context menu entries of Writer and duplicate it for Calc:
* Open Hyperlink
* Edit Hyperlink...
* Copy Hyperlinks Location
* Remove Hyperlink
*** Bug 102911 has been marked as a duplicate of this bug. ***
This bug is still in LO 126.96.36.199 (Ubuntu 17.04) and has been around for a really long time.
Ctrl+M does not do what it's supposed to do and the link remains in the cell.
Hi the issue is that add the context menu entries from writer to calc (cell.xml and celledit.xml) the entries wasn't shown.
So there are two options from my point of view:
1. make the editHyperlink, ... actions working in calc
2. use clear direct formating
I prefer option 1 cause RemoveHyperlink and some other commands are ONLY available in context menu (which is fine) and option 2 is always possible.
So if someone fix the coding part, I'll add the Hyperlink stuff from writer.
*** Bug 120373 has been marked as a duplicate of this bug. ***
Please take a few moments to read the opening comment(s) in bug 120373, which is not an exact dupe of this one but just "close enough"; it's perspective is somewhat wider.
(In reply to Eyal Rozenberg from comment #9)
> Please take a few moments to read the opening comment(s) in bug 120373,
> which is not an exact dupe of this one but just "close enough"; it's
> perspective is somewhat wider.
Indeed. If you don't know that Ctrl+M does the trick, you're lost..
(In reply to Cor Nouws from comment #10)
> Indeed. If you don't know that Ctrl+M does the trick, you're lost..
(and that also clears formatting that you may not want to be removed)
The command RemoveHyperlink is only available in sw apps cause the uno command is defined in WriterCommands.xcu so the Hyperlink uno commands has to be moved to generic first and can than be used in the calc context menu.
Samuel Mehrbrodt committed a patch related to this issue.
It has been pushed to "master":
tdf#62561 Add remove/edit hyperlink to calc context menu
It will be available in 6.4.0.
The patch should be included in the daily builds available at
https://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.
*** Bug 113840 has been marked as a duplicate of this bug. ***