Ask Your Question

Text box in Calc loses link upon conversion to pdf [closed]

asked 2018-11-24 20:11:46 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have several LibreOffice Calc spreadsheets containing text boxes with web hyperlinks. The text in each box is not a link, but rather the box itself has a hyperlink. On conversion to a pdf file the links are lost when opening the file with Acrobat Reader. Am I doing something wrong or is this a missing feature in LibreOffice? I have checked the box in the PDF options for cross-document links to open with internet browser. A link typed directly into a cell does work, however.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-10 22:47:48.345154


In my Dropbox is a sample spreadsheet ("testlink.ods") containing a text box with a link. If you open the file with LibreOffice, convert to a pdf file and then open it with Acrobat Reader, the link is lost. Any help on how to make the link active would be appreciated.

kappy gravatar imagekappy ( 2018-11-25 18:42:06 +0100 )edit

Hmm... The file on Dropbox appears not to be a valid .ODS file.

In fact it is not zipped .xml at all.

BigRAl gravatar imageBigRAl ( 2018-11-26 14:04:17 +0100 )edit

I have recreated the calc file using LibreOffice and also the pdf file created from within LibreOffice, zipped them, and stored them at:

You should be able to directly download the zip file. In the .ODS file you will see that you can cntrl+click anywhere in the drawn box to go to a link, but the hyperlink is lost in the pdf file.

kappy gravatar imagekappy ( 2018-11-26 15:35:21 +0100 )edit

@kappy Please avoid using external storage space on this site.

wget gravatar imagewget ( 2018-11-29 23:48:42 +0100 )edit

I have not used any storage on this site. I stored a 40KB zip file on my Dropbox simply to demonstrate an issue I'm having with LibreOffice. I was hoping someone would look at these files and suggest a solution.

kappy gravatar imagekappy ( 2018-11-30 16:16:34 +0100 )edit

@kappy Extactly what I said. Dropbox is external storage. With this website, you have the ability to add your files directly to your question, please use it :)

wget gravatar imagewget ( 2018-12-27 20:24:16 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-11-25 16:38:08 +0100

ebot gravatar image

If you have entered your hyperlink in LibreOffice, select menu File>Export as PDF ...

In the dialog box "PDF Options" in the tab "General" and by the point "General" is set for me:

  • Hybrid-PDF
  • Indexed PDF
  • Create PDF form
  • Export bookmark

Check which settings can help you.

E.g. my PDF with Hyperlink:

image description

edit flag offensive delete link more


With me Windows 10, Version 1809, 64-Bit | LibreOffice, Version: (x64).

ebot gravatar imageebot ( 2018-11-25 16:38:37 +0100 )edit

The problem is that the links are not present when opening the pdf file with Acrobat Reader, which is what most people use to read pdf files. I have tried setting PDF options as you describe, but the links are still lost. The options I have set are Hybrid-PDF, Create PDF Form, and Export bookmarks. I cannot find the option for "Indexed PDF" and don't know what this does. I'm using Windows 10 version 1803, 64 bit, LibreOffice version (x64).

kappy gravatar imagekappy ( 2018-11-25 18:19:31 +0100 )edit

Question Tools

1 follower


Asked: 2018-11-24 20:11:46 +0100

Seen: 294 times

Last updated: Nov 25 '18