Hyperlink stopped working after upgrade

English
, , , ,
#1

I upgraded Ubuntu 13.04 to 13.10 and Libreoffice version is now 4.1.2.3.

My problem is that now HYPERLINK function doesn’t work anymore in my CALC sheet (below the french name of the function):

LIEN.HYPERTEXTE("vnd.sun.star.script:standard.avisEcheance.printToPdf?language=Basic&location=document";"PDF")

When I click on the cell, nothing happen whereas before, it would run basic code (instructions to print to PDF). The same for other Hyperlink calls in the file…

Is it a known bug ? I don’t have anterior version of LO to have confirmation my problem is due to the upgrade though

#2

I´m working with LibreOffice Version: 4.1.3.2 on OpenSUSE 13.1 now and having the same problems.
With version 4.0.1 there were no problems. We have a lot of problems while this is not working anymore.
How can we give this problem a hi priority on the bug-list? Because i’m pretty sure it is a bug :frowning:

#3

I have a similar problem, with LibreOffice Version: 4.1.6.2 on OpenSUSE 13.1, but it seem to be limited to the case when the path contains spaces or not ASCII characters like è, é, ü, ä, etc.
It is definitely a bug. I do not know whether somebody may have interest to fix it, since Version 4.2 is already out…

#4

Update: I installed Version: 4.2.5.2. Problem persist.
However, under Windows, using 4.2.4.2, the problem does not appear.

#5

I have the same problem with LibreCalc Version 4.2.4.2 on Ubuntu. Has someone already written a bugfix for LibreCalc on Linux ? Or is there a buglist, where i can post this bug ?

#6

Ok, there is a buglist, and the bug is reported 2013-10-28 :frowning:
https://bugs.documentfoundation.org/show_bug.cgi?id=70959

#7

Hallo

@Stefan70

its still reported since October/2013 but nobody works on it

#8

:(, I would donate 20$ for libreoffice, if someone fix this bug.

#9

thanks to @Markus1 Mohrhard, karolus, Andreas Säger, … the Bug is fixed in the Daily-Version of LibreCalc. :slight_smile:

#10

There is a security option in:

Menu/Tools/Options/LibreOffice/Security/Options - Ctrl-click required to follow hyperlinks

#11

I unchecked the Ctrl-click option, closed then reopened my file, (macro enabled), still nothing happen when I click on the cell containing the HYPERLINK.

Moreover, I just opened it with libreoffice 4.0.2 and it works just fine (although the security option Ctrl+click is checked!)

#12

Instead of putting the HYPERLINK directly into the cell -which obviously is broken since new version 4.1.2.3 of LO- I call the LINK using a form button, and it works great.

Draw a push button, then copy your link under the “ACTION” property (which is an open web page action) in this way, you can still pass arguments to your macro:

vnd.sun.star.script:standard.avisEcheance.printToPdf?language=Basic&location=document&argument1=variable
#13

this is only a workaround. buttons dont suit my needs. I think someone should fix the bug in Libre-Calc.

#14

Okay, I have over 6,000 absolute hyperlinks in a spreadsheet and they no longer work. I tried ctrl-click, I tried the way I have always done this (just clicking it) and the links do not work! Relative hyperlinks still work but I need a way to “fix” this problem. I didn’t create this problem, I don’t like the idea of manually editing 6,000+ absolute hyperlinks that were working fine just yesterday.

#15

I just did what mariosv wrote above and it runs fine for me now. First I tried to run the hyperlink with Ctrl+click and it worked fine, then I went on Tools/Options/Security/Options and I unchecked that option. It worked fine for me both ways. Thanks, Mario!

#16

Here is another workaround wich is also not perfekt. It uses the doubleclick-event of the sheet.

#17

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.