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."
Hi Peter, 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... Thanks,
Both Ctrl-M & "Clear Direct Formatting" work on LO 4.0.3.3 (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 5.3.1.2 (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. <menu:menuitem menu:id=".uno:OpenHyperlinkOnCursor"/> <menu:menuitem menu:id=".uno:EditHyperlink"/> <menu:menuitem menu:id=".uno:CopyHyperlinkLocation"/> <menu:menuitem menu:id=".uno:RemoveHyperlink"/> <menu:menuitem menu:id=".uno:OpenSmartTagMenuOnCursor"/> <menu:menuitem menu:id=".uno:ThesaurusFromContext"/> 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": https://git.libreoffice.org/core/+/040f348ee00a0d01653b3071be3d9886a08f87fe%5E%21 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 113840 has been marked as a duplicate of this bug. ***
Samuel, can you please explain what UI changes your patch made? Specifically... * Context menu entries <- Looks like you added this * Remove link button in the edit dialog <- Was this added? * Menu items for hyperlinks <- Has the patch changed anything? Will we now always have several entries with some disabled, or will we have less entries when there's no hyperlink? * A change of semantics for the hyperlink toolbar button. And either it changes graphic to indicate "Edit" when on a hyperlink, or it always indicate "Add/Edit" somehow. Another option is to make it into a sort of a menu-button. <- I couldn't locate something like that in the patch
(In reply to Eyal Rozenberg from comment #15) > Samuel, can you please explain what UI changes your patch made? The patch adds edit and remove hyperlink to the context menu in calc. > Specifically... > > * Context menu entries <- Looks like you added this > * Remove link button in the edit dialog <- Was this added? > * Menu items for hyperlinks <- Has the patch changed anything? Will we now > always have several entries with some disabled, or will we have less entries > when there's no hyperlink? > * A change of semantics for the hyperlink toolbar button. And either it > changes graphic to indicate "Edit" when on a hyperlink, or it always > indicate "Add/Edit" somehow. Another option is to make it into a sort of a > menu-button. <- I couldn't locate something like that in the patch Can you please check each of these issues individually in current master? There were quite a few changes with hyperlinks in current master/6.4. So please check which issues are still open and write a new bug report for each issue. Putting many issues in one bug report doesn't really help.