Free Support Forum -

Range sliding


I’m currently working with Aspose.Excel

When I add a range a worksheet, and then add a row above it later on, the startrow of the range is not updated.

Is it possible to have the ranges slide with the addition of new rows, as it currently works in Excel?



Hi Paul,

You can insert row first then add a range.

This change may affect many users. If I change the code and they upgrade to the new version, their previous code will have to be changed.

I understand the code compatibility issue.

Adding range sliding would definitely be useful for users who load templates with ranges predefined (like me). Would it be possible to add a boolean hook into the Excel component that would let the user define whether he/she wishes for ranges to slide (it could be defaulted to false to insure compatibility with existing code bases).