Copy Hyperlinks in LibreOffice
I tried this, and it worked:
- Select the cells you want to copy (optional)
- File / Export
- File type: XHTML
- Click on Selection checkbox (optional)
- Choose filename and click Save button
The HTML file will contain both Link-Text and Link-URL
Here is another solution that uses macros. It can extract the links to another column or to another worksheet.