Ubuntu – Copy Hyperlinks in LibreOffice

htmllibreoffice

I face the problem that I need to copy a list of hyperlinks from LibreOffice Calc to an HTML file:

I created the list in LibreOffice Calc (3.3.2) with the function hyperlink(Link-Text;Link-URL). The Links work in the spreadsheets. Until now I have not found any way to copy such a Link (Link-Text not equal Link-URL) or the list of links to any other document. I tried:

  • Copy/Paste Special in Office Calc
  • Copy/Paste to Writer
  • Upload the spreadsheet to LibreOffice Base
  • Save the file as HTML
  • Copy/Paste into an HTML editor.

-> only the URL-Text gets copied but never the link. I appreciate any help!

Best Answer

I tried this, and it worked:

  1. Select the cells you want to copy (optional)
  2. File / Export
  3. File type: XHTML
  4. Click on Selection checkbox (optional)
  5. Choose filename and click Save button

The HTML file will contain both Link-Text and Link-URL