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:
C#
Range range = w.Worksheets.GetRangeByName(“L_1_1”);
range.Worksheet.Cells.AddRange(range);
// then insert rows
//copy range.
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.
We actually did try to run even on the latest version of the Aspose as well. Anyhow i have made a sample project which simulates our problem.
One thing i would like to know is that with the new version why an existing functionality which was working fine has suddenly disappeared OR was it a bug in the previous version which is fixed now?
PS: IMHO the transition from X version of Aspose to Y version should be smooth. Currently its a bit difficult to do this. Upgrades should always be smooth for clients.
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.