Hyperlinks not moving with sorted cells

Aspose.Cells Product Family
1

I have an issue with the DataSorter and cell hyperlinks. The below code does not move the hyperlinks with the cells. The cell "A5" is still pointing to the second worksheet although the "A LINK TO OTHER SHEET" text has moved to cell "A1".

'USING ASPOSE CELLS 7.1.2.0
Dim WORKBOOK As New Aspose.Cells.Workbook
Call WORKBOOK.Worksheets.Add()
Dim WORKSHEET1 = WORKBOOK.Worksheets(0)
Dim WORKSHEET2 = WORKBOOK.Worksheets(1)
Call WORKSHEET1.Hyperlinks.Add(0, 0, 1, 1, "http://www.google.com")
Call WORKSHEET1.Hyperlinks.Add(2, 0, 1, 1, "http://www.aspose.com")
WORKSHEET1.Cells(4, 0).Value = "A LINK TO OTHER SHEET"
Call WORKSHEET1.Hyperlinks.Add(4, 0, 1, 1, "Sheet2!A10")
WORKSHEET2.Cells(9, 0).Value = "DESTINATION HERE"

WORKBOOK.DataSorter.Key1 = 0
WORKBOOK.DataSorter.Sort(WORKSHEET1.Cells, 0, 0, 4, 0) '<--- Should move hyperlinks
WORKBOOK.Save("C:\TESTFOLDER\Sample.xlsx")

2

Hi,


After an initial test, I can find the issue as you have mentioned by using your sample code.

I have logged a ticket with an id: CELLSNET-40504. We will look into it soon.

Thank you.
3

Hi,

Please download and try this fix: Aspose.Cells for .NET v7.1.2.4

We have fixed this issue.

4

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

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