Hyperlink Formula Working Error from Excel to Calc

Discuss the spreadsheet application

Hyperlink Formula Working Error from Excel to Calc

Postby mythilyalini » Mon Dec 17, 2007 8:49 pm

In Excel
=hyperlink("a/a.xls","abc")
=hyperlink("../../a/a.xls","abc")
These Functions work Proper in Excel

After Conversion to Calc
=hyperlink("a/a.xls";"abc")
=hyperlink("../../a/a.xls";"abc")

These functions not work in Calc.

Kindly do needful.

Regards
Kumarasmy
Last edited by mythilyalini on Thu Dec 20, 2007 5:09 am, edited 2 times in total.
mythilyalini
 
Posts: 1
Joined: Sat Dec 08, 2007 11:50 pm

Re: Hyperlink Formula Working Error from Excel to Calc

Postby Hagar Delest » Mon Dec 17, 2007 10:58 pm

1. No multi-posting (I'll delete your other thread) please.
2. No bump every 20 min (I've removed it) but perhaps it was a mistake, clicking wrongly on the quote button.
3. Can you add some precisions about the 'partial' link feature ? What do you mean by 'partial' ? relative ?
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28585
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Hyperlink Formula Working Error from Excel to Calc

Postby Hagar Delest » Thu Dec 20, 2007 9:14 am

I know that for 'normal' hyperlinks (those that are not in formulas), the link seems to be absolute because they include the whole path but they are relative in fact (I know, nothing can tell you that looking at the link). Perhaps it's the same for the hyperlink function. Try to put the whole path and make some tries moving the folder to check if OOo retrieves the data correctly.

NB: please no PM to 'bump' a topic. And beware, if you edit your post instead of replying the thread to give more information, the thread won't be tagged as updated (jumps up the threads list in the index) and nobody (subscribed to the thread) will get any notice (mail notification).
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28585
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: RusselB and 16 guests