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 v18.104.22.168. 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.
var options = new LoadOptions()
MemorySetting = MemorySetting.MemoryPreference
var workbook = new Workbook(“SummaryReport_Template.xlsx”, options);
var sheet = workbook.Worksheets;
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);
cells.DeleteRange(0, 0, 0, 0, ShiftType.Up);