Copying a Range does not copy the Hyperlink

Aspose.Cells Product Family
1

Hi,


Copying a range containing a hyperlink from one sheet to another does not copy the hyperlink (although the blue text and underline style is copied correctly).
When copying a cell or range using Excel, the hyperlink is correctly kept.

I have attached an Excel file for testing with the following code:

var workbook = new Workbook(“Linky.xlsx”);
var ws = workbook.Worksheets[0];
var ws2 = workbook.Worksheets[2];
var fromRange = ws.Cells.CreateRange(0, 0, 1, 1);
var toRange = ws2.Cells.CreateRange(0, 0, 1, 1);
toRange.Copy(fromRange);

workbook.Save(“LinkyOut.xlsx”);

Best regards.
2

Hi John,


Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for .NET 8.3.1.4, and we have noticed that the hyperlinks are not getting pasted while copying a range of cells from one worksheet to another. We have logged this incident in our bug tracking system under the ticket CELLSNET-43305 for further investigation. Please spare us little time to properly analyze the problem cause, and to provide the fix (if applicable) at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.
3

Hi John,


This is to inform you that we have fixed the problem logged earlier as CELLSNET-43305. We will shortly provide the fix after incorporating other enhancements and performing QA over it. As soon as the next release containing the aforesaid fix is available for public use, we will notify you here along with the download link to the upgraded API.

Thank you for your patience with us.
4

Hi,

Thanks for your using Aspose.Cells.

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

5

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

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

Hi,


The range is now a proper hyperlink when copied, however the style is wrong.

The best way to compare it is using the same file I attached above and this code:


var workbook = new Workbook(“Linky.xlsx”);
var ws = workbook.Worksheets[0];
var fromRange = ws.Cells.CreateRange(0, 0, 1, 1);
var toRange = ws.Cells.CreateRange(2, 0, 1, 1);
toRange.Copy(fromRange);

workbook.Save(“LinkyOut.xlsx”);

You will see that the resulting copy has a different colour to the original.

Best regards.
7

Hi John,


Thank you for getting back to us.

We have evaluated your recently presented scenario while using the latest version of Aspose.Cells for .NET 8.3.2, and we are able to notice the problem. While copying the range, the hyperlink formatting isn’t getting copied. We have logged this problem under a new ticket CELLSNET-43346 and referenced it to the previously resolved ticket CELLSNET-43305 for product team’s reference. Please spare us little time to investigate the matter and provide a fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.

Please accept our apologies for the inconvenience caused to you.
8

Hi,

Thanks for your using Aspose.Cells.

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

9

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

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