Excel-hyperlink with adress and subadress

Aspose.Cells Product Family
1

Hi, an Excel-hyperlink has an adress and also a subadress. Is there any way to get the subadress with Aspose.Cells?

2

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

Thank you for considering Aspose.

We are not clear about your required feature (sub-address of Hyperlink in MS Excel). Please create a sample excel file to show the sub-address feature of hyperlink. We will check it and get back to you soon.

Thank You & Best Regards,

3

Hi, in cell D5 I have added a hyperlink that is splitted into an address "http://www.google.de/" and a subaddress "imghp?hl=de&tab=wi". In Excel this is delimited by a "#". With a VB macro you can read the hyperlink of that cell with the associated address and subaddress. Aspose.Cells returns only the address part "http://www.google.de/" of the hyperlink. There is no way to get the subaddress part in this case or the complete link (address+subaddress).

4

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

Thank you for sharing the details and template file.

We have added your required feature as feature enhancement in our internal issue tracking system with issue id: CELLSNET-16718. We will look into it and get back to you soon.

Thank You & Best Regards,

5

Hi,

Please try the attached version. <span style=“font-size: 11pt; font-family: “Arial”,“sans-serif”;”>Now, the address will be same as in MS Excel.

Thank you.

6

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

While trying to keep the API as straightforward and clear as possible, we have decided to recognize and honor the common development practices of the platform; we have re-arranged API Structure/ Namespaces.

With this release, we have reorganized the API classes for Aspose.Cells component. This change has some major aspects that we follow. We have added new namespaces. The entire API (classes, interfaces, enumerations, structures etc.) were previously located in the Aspose.Cells namespace. Now, certain sets of API have been moved to their relative namespaces, which make the relationship of classes (with their members) and namespaces clear and simplified. It is to be noted here, we have not renamed existing API (classes, enumerations etc.) but, I am afraid you still need to make certain adjustments in your existing projects accordingly.

For complete reference, please see the product’s API Reference.