Using LibreOffice Calc v26.2.1.2 on Windows 10 Pro
The embedded hyperlinks aren’t working in the exported pdf. What might be the reason(s)?
Thank you for any suggestions.
Kind regards,
Kelly
Thank you nobu for replying and for sharing links to those 2 bug reports. I beat my head against the wall for quite some time before posting my question on the forum.
Using 26.2.2.2, I tested the steps in 169929 and created a pdf.
- In Adobe Reader and in an old Adobe Acrobat X (2010) the link is entire and works
- In Firefox, PDF Viewer Plus SE and Sumatra PDF only the top line is a link
- In PDF-XchangeEditor, only the second line becomes a link,
http://reoffice.org/la - In Microsoft Edge, the first line becomes a link, the second line is marked also as a link but is preceded by the file path
WrappedHyperlinktdf169929.pdf (19.3 KB)
Version: 26.2.2.2 (X86_64)
Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5
CPU threads: 8; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win
Locale: en-NZ (en_NZ); UI: en-GB
Calc: CL threaded
If I open the file in 25.8.3.2 or earlier I cannot wrap a Ctrl+K hyperlink in Calc.
It seems it is a new functionality that when exported to pdf the link is supported only by Adobe. Maybe it is a bug in the other pdf viewers?
In any event looking online it seems that wrapped hyperlinks break when exported to pdf. Using the HYPERLINK function seems to be the way forward for exporting to pdf thaat all pdf readers can use.
@ EARNESTAL - Thank you for sharing the working link in the PDF. It remains unclear to me how you were able to get this to work; however, the displayed URL in your example, wrapped or not, isn’t exactly the same as the hyperlink embedded on a different character string than the naked URL.
The links that are missing this morning from nobu’s, now deleted posts, were partially helpful, and I hope it’s okay with all, I re-share the original Bug 169929 169929 – When Wrapped hyperlinks are exported to PDF, the link is the text in the topmost row The first 2 comments nobu had made related to 169929 and v26.2.0.0.beta1. Also, the additional comments made by steve.contrib (also back in Dec 2025) are helpful.
As captioned in the title of the Bugzilla report, that discussion began narrowly focused on Format Cells…, Alignment, Properties, and the enabled Wrap text automatically, but then gets relevantly expanded by Steve’s comment 3, and comment 4.
The problem remains, the exported PDF has non-working hyperlinks. This issue was not present in LibreOffice Calc v25.8.4.2, but is present in 26.2.1.2 - see attached Known Cemeteries of Ellsworth 20260410 0825.pdf (110.4 KB)
Below are the particular details, should they be of interest.
Version: 26.2.1.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 12; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
With cell A3 selected, Ctrl+K
Alt+F12
Options, Load/Save, General
Options, LibreOffice Calc, Compatibility
Ctrl+1
Format, Cells…, Alignment,
Format, Cells…, Font,
File, Export as PDF…, PDF Options, General
File, Export as PDF…, PDF Options, Links,
The problem is when you use the Insert hyperlink and you have active the Warp Text automatically in the page Alignment.
The problem is gone when you use the function HYPERLINK in the cells
HYPERLINK("URL" [; CellValue])
=HYPERLINK("https://help.libreoffice.org/latest/en-US/text/shared/guide/hyperlink_insert.html"; "Help for inserting hyperlinks")
@bantoniof - Thank you for your reply.
Sorry, if I seem thick, but are you telling me that 1) we have to format the cell and disable Wrap text automatically, and 2) we have write pseudo HTML code every time in each cell? I’m sure I must have gotten this wrong, but if that’s the case, it still isn’t working.
You mus NOT use the Menu > Insert > Hyperlink
You must use the function HYPERLINK:
- Delete previous hyperlink
- Place the cursor in the cell and write direct in the cell the function HYPERLINK
=HYPERLINK("https://libreoffice.org";"LibreOffice Home")
@bantoniof Thank you for clearing that up; and that the Function Wizard or Formula bar must be used.
That link worked, though the styling associated with hyperlinks no longer appears
Do you think that this is the new norm for LibreOffice or do you imagine that it’s just a work around until the bug(s) discovered in December 2025 gets fixed?
Until then, I’m thinking that maybe v25.8.6 is a better work around.
I don’t know if the HYPERLINK function existed before or after the Insert > Hyperkink menú option.
- Apparently, when you insert a hyperlink with the menu and you have auto-wrap text enabled, Calc sections the text to fit the width of the cell and breaks the hyperlink when export to PDF.
- This doesn’t happen with the function because it treats it differently.
I’ve uninstalled v26 and gone back to the previous version of LO and note that the v26 version doesn’t have the URL: field name given in the Ctrl+K Hyperlink dialog. Also, the Text: field is switched in position.
As for the existence of HYPERLINK in the Function Wizard, Formula toolbar, HYPERLINK is in:
Version: 25.8.6.2 (X86_64)
Build ID: b4b39682cd9868fa725bc664aff94278d315bd04
CPU threads: 12; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Thank you for this discussion and to all that have contributed to it.
Has anybody tested this issue in any of these current offerings?
I’m currently still using:
Version: 25.8.6.2 (X86_64)
Build ID: b4b39682cd9868fa725bc664aff94278d315bd04
CPU threads: 12; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded