Free Support Forum - aspose.com

Partial hyperlink not working

Aspose.Cells Product Family
#1

Hi!


I am adding an hyperlink to a workbook using the following:
worksheet.Hyperlinks.Add(row, col, 1, 1, link);

The link is added to the Excel as it should and everything is fine for the following links:
http://www.aspose.com (or anything else that stsrts with http://)
\mycomputer\mypath (or anything else that starts with \)

However, if the link is not complete, by example: www.google.ca (no http), Excel displays a pop-up message saying that it “Cannot open the specified file”. If I enter the link manually in Excel, everything is fine. I noticed that the tooltips are not the same.

Is there a way to make incomplete hyperlinks work?

Thank you!
Marie
#2

Hi Marie,

Well, I think MS Excel works same as Aspose.Cells.
If you could check, when the Address is simple “www.aspose.ca”, MS Excel won’t navigate to the correct link unless you provide full url e.g “http://www.google.ca/”. When you start typing manually in Hyperlink dialog’s Address field e.g “www…”, MS Excel automatically adds “http://” at the start for you.

Thank you.



#3

Hi Amjad,


Thanks for your response.

However, “www.aspose.ca” doesn’t work because it does not exist. If you enter “www.aspose.com”, even without the full url, it works.

Is there a way to do the same with Aspose?

Thanks
Marie
#4

Hi Marie,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We have found your mentioned issue after further testing. We will look into it and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id: CELLSNET-15222.

Thank You & Best Regards,

#5

Hi,

Please try the attached version, we have fixed your mentioned issue.

Thanks.

#6

Thanks this fix worked for me too.


Every time I used _worksheet.Hyperlinks.Add(row, column, 1, 1, url); the value was been replaced with the URL for me it was not just partial but proper Urls that work in a previous version. Got this when I upgrade from 4.7.1 to 4.8.2 not sure when it was broken.

Thank you for fix !
Toby
#7

The issues you have found earlier (filed as 15222) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.