Question about row inserting

Aspose.Cells Product Family
1

Hi!

Working with Aspose.Cells I’ve faced with need to insert a new row to the end of merged range.
Using method Cells.insertRows everythig works like in Excel - the new row appears in specified index, next rows shift down, merged range expands and new row become the last but one.

The question is - can I somehow add a new row to the merged range so that it became the last one in the merged range?

Add the file for clearness.
file.zip (7.8 KB)

Thanks!

2

@nikiton,

I am afraid that you need to create the merged range with inserted row at the end once again becuase row can not be added at the end being part of existing merged range.

3

Ok.
Thanks for reply!

4

@nikiton,

You are welcome.