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
Hyperlink Formula Working Error from Excel to Calc
-
- Posts: 1
- Joined: Sat Dec 08, 2007 11:50 pm
Hyperlink Formula Working Error from Excel to Calc
Last edited by mythilyalini on Thu Dec 20, 2007 5:09 am, edited 2 times in total.
- Hagar Delest
- Moderator
- Posts: 32654
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Hyperlink Formula Working Error from Excel to Calc
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 ?
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 ?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
- Hagar Delest
- Moderator
- Posts: 32654
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Hyperlink Formula Working Error from Excel to Calc
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).
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).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10