Thanks for your posting the samples.
We have logged your issue in our database. We will look into them and once we have some fix/update available. We will let you know.
This issue has been logged as CELLSNET-40474.
Please provide us your sample project. We will check it soon.
And we think you have to add the range to Cells.Ranges list after you create range.
Please see the following code:
Range range = w.Worksheets.GetRangeByName(“L_1_1”);
// then insert rows
We do not add the range to Cells.Ranges list for performance issue .So inserting rows/columns/ranges will not change the generated range if you do not call Cells.AddRange method.
Please also download and use the latest version: Aspose.Cells for .NET v22.214.171.124
a) How to make code work:
Please change your code as the following :
Range range = _oAsposeWorkbook.Worksheets.GetRangeByName(“L_1_1_1”);
b) Why did we change it.
We could not update the range object if it’s not in the cells.Range list.
For performance issue, we did not add named range to cells.Ranges list.
There are too many named ranges in the files of some customers . These ranges will consume too much memory.
Thanks for your posting and using Aspose.Cells for .NET.
It’s good to know that proposed solution works fine. If you are using the v7.0.0, then you will not have any difficulty upgrading to latest version.
You can upgrade your existing code easily.
I also recommend you to please download and try the latest Offline - Aspose.Cells for .NET C#/VB.NET Demos.
It will help you to get familiar with Aspose.Cells for .NET API quickly and you will be able to upgrade your existing code easily. Also, these demos use the latest version of Aspose.Cells for .NET.