Hyperlinks without subaddresses are lost when saving with Aspose.Cells

Aspose.Cells Product Family
1

PFA Excel workbook.


Using Aspose.cells version 8.3.2.0.

There is a hyperlink without a subaddress in Sheet1, C3.
When you mouse over the cell the cursor turns into the hand, and you see a screen tip.

Using the code below :

Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(“LostHyperlinks.xlsx”);
wb.Save(@“outLostHyperlinks.xlsx”);

You will see that in the output workbook, Sheet1, cell C3 no longer has a hyperlink.

? range(“C3”).Hyperlinks.Count = 0
2

Hi Dean,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after running your sample code with your source Excel file. Hyperlink in cell C3 is lost when file is saved back using Aspose.Cells.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43419 - Hyperlinks without subaddresses are lost when saving with Aspose.Cells

I have attached the output Excel file for a reference.

C#

string filePath = @“F:\Shak-Data-RW\Downloads\LostHyperlinks.xlsx”;


Workbook workbook = new Workbook(filePath);

workbook.Save(filePath + “.out.xlsx”);

3

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.3.2.5 and let us know your feedback.

4

This appears to work.


Thanks a bunch! Any idea when this will be release ?

Thanks again,

Dean

5

Hi Dean,

Thanks for your feedback and using Aspose.Cells.

The next official major release v8.4.0 which will include this fix too is expected on the first week of March, 2015.

6

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

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