[Solved] Hyperlink not working

[Tucson77]

Hello. I just discovered a bug in the hyperlink function.

In a simple calc document, i do on a cell, insert an hyperlink. Then, i do paste, from a previous cut, done on a file with the windows function 'copy as a access link' (standard function in windows). For example, a warranty.pdf file on an usb disk G:

Then all is fine, i have a link, pointing toward my document linked. i test the link, all is OK.

Then i do save for the .ods file (containing the link), and reopened it. The link do not work anymore, since it has become :
file:///C:/Users/xxx/Pictures/Screenshots/%22G:/Warranty.pdf%22.

What is this ???

[Tucson77]

ARRRRRRGGGGGHHHHHHHHHHH
all my link (done again yesterday and verified after save) are ko this day.
all begins now with
C:\Users\xxx\AppData\Local\...\%22G:/Warranty.pdf%22

Open Office is a beta version ? (4.1.15 under w11)
grrr

[DiGro]

See if this helps:

Remove the quotation marks after pasting the link.

That should work

[MrProgrammer]

The link do not work anymore

I tested this procedure successfully:
• Ensure that the cell is empty
• Insert → Hyperlink → Document   (not Internet)
• Use the Open File icon next to Path
• Navigate to the file → Open
• Apply → Close → Press Enter
Be sure to perform all three actions in the last step.

done on a file with the windows function 'copy as a access link'

I don't use Windows and can't help with that method. Perhaps you can paste the link into the Path dialog box instead of using the Open File icon. The data on the clipboard from Windows must have the correct syntax for Calc, of course. If it doesn't, you will have to fix it.

Personally I never use Insert → Hyperlink in Calc. I prefer to use the HYPERLINK function. You'll have to use the correct syntax for a Windows file. If you don't know what that is, the Insert → Hyperlink dialog may be easier for you because it will create the correct syntax for the file name.

I just discovered a bug in the hyperlink function.

I suspect you have actually discovered a bug in the procedure that you're using. The path must be the exact name, not a name with extra quotes. When you add those, they ae assumed to be part of the file name. But a double quote is not allowed in the Path dialog box, so it's replaced by %22.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[DiGro]

done on a file with the windows function 'copy as a access link'

I don't use Windows and can't help with that method. Perhaps you can paste the link into the Path dialog box instead of using the Open File icon. The data on the clipboard from Windows must have the correct syntax for Calc, of course. If it doesn't, you'll have to fix that.
[snip]

In fact the option in Windows 11 is "Copy as path" (at least at my Dutch version it is).
It copies the link to the file as a path.

You can then paste it in the field Path, BUT … it places quotation marks around it.
All seems well and the link works.
Until you save the file and close it.
After re-opening, the link no longer works, as Windows adjusts the link to the file, as seen in the post from OP.
That way the file is unretrievable

Removing the quotation marks after pasting makes the link solid again.
Or use Mr. Programmers way

EDITED:
%22G:/Warranty.pdf%22 = "G:/Warranty.pdf"
The part before that probably is the directory where the OP saves his documents

[Tucson77]

Thank you for the replies
1. the hyperlinks files worked yesterday after saving the file
2. the hyperlinks have no "
3. the path is NOT where i save my documents

The document containing links is in a path absolutely different from the path of the different links.

I can redo all my links one more time (>50) but in the condition it would not be changed automatically tomorrow.
Has Open Office been tested ?

[DiGro]

Can you attach a small example here ? ( just two or three links to imaginary files is fine)
as I have no clue what you are doing (wrong)

The text in the dialog box Path should be something like : file:///G:/Warranty.pdf

Hyperlink.png (20.7 KiB) Viewed 2399 times

[Tucson77]

I do another example, following tour guidelines.
I open a new document, with the name "hew document.ods"
I put an hyperlink inside a cell with paste, after the "copy as a path" of document G:\warranty.pdf
I removed the quotes, as you said, and the link is ok.
i saved the file "new document.ods"
i reopened it and look the link, it worked

so i will propably have to redo all my links for the third time with this method.
will see tomorrow if the "new document.ods" hat not been updated by mysterious gremlins...

BUT " or no ", we can hope that, as in excel, when we put x in a link, it is not y the next day.

I will update tomorrow.

[Tucson77]

Well, this morning all is fine.
But as i do not know why the hyperlink are updated sometimes, it is possible that the bug reappear.

i will so recreate all my links by pointing the pathes without quote.

Very strange that in a base function of a universal program, doing a link, it do not work since it put ".

Anyway thank's for the previous replies.