Internal hyperlink trying to look outside workbook

Aspose.Cells Product Family
1

I just ran into an interesting problem - for a specific hyperlink created on a worksheet that is supposed to point to another worksheet within the workbook, Excel is treating it as if it is pointing outside the workbook.

Look at line 40 of the Summary of Engagements worksheet - this hyperlink should go to another worksheet within the workbook, just as the other hyperlinked lines around it (like 39 and 41). Instead Excel thinks it should open an external file when that hyperlink is clicked.

I have included examples of this file generated under 3.6.1.0 (our current production version - where the exact hyperlink is working fine) and under 4.1.1.6 - the version we plan on putting in production next week. In 4.1.1.6, almost all of the hyperlinks continue to work fine - the one on line 40 is an example of one that isn't working anymore.

2

Hi,

Thanks for considering Aspose.

Yes, I checked, I think the problem is the Dot (.) included in the name of the sheet. i.e., PROD. IS - 10433828.

Could you eliminate the Dot from your sheet name renaming it. And in the mean time we will resolve it very soon.

Thank you.

3

Thank you...yes, it seems like the problem is with the dot. As we are upgrading our version of the Aspose library, we can not eliminate the dot in production as the current applicaton supports having the dot there, and reports will be different if we fix the issue that way.

Do you have an ETA on the fix?

4

Hi,

Please download the fix @ the thread and try it:

<A href="</A></P> <P><FONT color=#000000>And I checked with the following code and its perfect:</FONT></P><FONT color=#000000> <P>/ Create a Workbook object</P></FONT> <P><FONT color=#000000>Workbook workbook = </FONT><FONT color=#000000>new</FONT><FONT color=#000000> Workbook();</FONT></P> <P><FONT color=#000000>workbook.Open("d:\\rchirichella_06-08-31_AP - hyperlink bad - 4116.xls");

// Obtain the reference of the first sheet

Worksheet worksheet = workbook.Worksheets[0];

// Add a hyperlink to A40 Cell.

int index = worksheet.Hyperlinks.Add("A40",1,1,"'PROD. IS - 10433828'!A1");

// Create a Hyperlink object to fetch the existing hyperlink

Hyperlink hlink = worksheet.Hyperlinks[index];

// Set the label to display

hlink.TextToDisplay = "PROD. ISSUES-TIMENX / SPEC REQ";

// Save the Excel file

workbook.Save(@"d:\internalhplnks1.xls",FileFormatType.Default);

Thank you.

5

The 4.1.1.9 update fixed the hyperlink issue with the ‘.’ being part of the internal hyperlink. Thank you!