Geting Range by name after copying sheet produces an Exception

Aspose.Cells Product Family
1
var workbook = new Workbook("sample.xlsx");
workbook.Worksheets.AddCopy(0);
workbook.Worksheets.GetRangeByName("test1");

Hello. this code throws an exception. sample.xlsx is attached
2

Hi,

Thanks for your posting and using Aspose.Cells.

We have tested your code with the latest version: Aspose.Cells for .NET v8.7.1.3 and found exception does not occur, however GetRangeByName returns null after copying sheet.

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-44306 - GetRangeByName returns null after copying sheet

C#
var workbook = new Workbook(“sample.xlsx”);
var before = workbook.Worksheets.GetRangeByName(“test1”);
workbook.Worksheets.AddCopy(0);

//Returns null which is wrong
var after = workbook.Worksheets.GetRangeByName(“test1”);

3
Hi Dmitry,

This is to inform you that the ticket logged earlier as CELLSNET-44306 has been marked resolved. We will shortly share the fix here after ensuring the quality and incorporating other enhancements.
4

Hi,

Thanks for using Aspose.Cells.

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

5

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

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