17

When I copy/paste from a website into gnumeric (or LibreOffice Calc) from a website, I want to be able to quickly strip away all hyperlinks and leave just text.

How do I do this?

Solutions in either program will be accepted, although gnumeric is preferred.

5

In Gnuneric: Menu "Edit" -> "Clear..." -> "Formats and Hyperlinks":

enter image description here

Another way is selecting the cells to edit, right-click and select "Remove [n] Hyperlinks".

25

In LibreOffice Calc (Version: 4.1.3.2; Build ID: 410m0(Build:2):

  • select the cells containing hyperlinks
  • Click on Format > Clear Direct Formatting (or just press Ctrl+M)

That's all.

  • When typing in a username@hostname.com Calc automatically turns it into a link (including wonky formatting), when all I really wanted was just the text. – bgStack15 Mar 3 '17 at 14:27
  • When clicking "Clear Direct Formatting" make sure you have the mouse pointer above the cell, not the actual link. It doesn't work for me if I right click the link. – Andrew May 14 '18 at 18:10
1

When you copy the info, and you're ready to paste, click on Edit --> Paste Special --> Unformattted text, and once the new window opens, review the info,choose your text import settings, and then click OK. See images below.

The text example in the last image, are links from a website, and it got pasted as text, and not hyperlinks.

enter image description here

enter image description here

enter image description here

  • Sadly, this is only intermittently available - usually paste special is greyed out. – David Oneill Mar 29 '14 at 22:18
0

In LibreOffice Calc (Version: 4.3.7.2; Build ID: 4.3.7.2-2.el6_9.2):

  1. Click Edit => Links...
  2. Click 'Break Link' and 'Yes' on every line item
  3. Click Close

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.