We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

DeleteRange issue with Hyperlinks collection

Aspose.Cells Product Family
#1

Hi, I'm having an issue where I'm using the Hyperlinks collection and deleting a range of cells.

When I delete cells, the text is moved appropriately, but the Hyperlinks collection on the sheet is still attached to the old cell.

This is causing an issue as the text in the cell does not line up with the actual click event.

Please see attached project. When you run it you will see the "1" doesn't have a link and "2" has a hyperlink to http://1.com

#2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after running the following sample code you provided with the latest version: Aspose.Cells
for .NET v8.1.2.3. After delete cells, although the text is moved up but they are pointing to old links

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-42904.

I have attached the Before and After output results for comparison.

C#


var options = new LoadOptions()

{

MemorySetting = MemorySetting.MemoryPreference

};


var workbook = new Workbook(“SummaryReport_Template.xlsx”, options);

var sheet = workbook.Worksheets[0];

var cells = sheet.Cells;


for (int i = 1; i < 10; i++)

{

var cellToOperateOn = cells[i, 0];

cellToOperateOn.PutValue(“http://” + i + “.com”);

sheet.Hyperlinks.Add(cellToOperateOn.Name, cellToOperateOn.Name, “http://” + i + “.com”, i.ToString(), null);

}


workbook.Save(“BeforeDeleteRange.xlsx”);


cells.DeleteRange(0, 0, 0, 0, ShiftType.Up);

workbook.Save(“AfterDeleteRange.xlsx”);

#3

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.1.2.4

We have fixed your issue now.

Let us know your feedback.

Thank you.
#4

Thanks for your quick reply and resolution. We are only using nuget for our vendor references so I haven't been able to confirm in our production environment. When will the new version be pushed to nuget?

#5

Hi,


We are scheduled to publish our next official version (v8.2.0) of the product within the next couple of weeks time, you will be notified here about the new release when it is published.

Thank you.
#6

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

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