Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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!

share|improve this question
What HTML editor are you using? – Lekensteyn Jun 27 '11 at 20:33

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

share|improve this answer
Saving the file as HTML also works – juanmah Jun 29 '11 at 10:09

File type: XHTML will be the problem. Normaly if you copy the hyperlinked text from libre office to another WYSIWYG editor everything comes with CSS no problem. I tried and worked.

share|improve this answer

Here is another solution that uses macros. It can extract the links to another column or to another worksheet.

share|improve this answer
Welcome to Ask Ubuntu! Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference. – Seth Mar 9 '13 at 17:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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