Error when doing InsertRow

Aspose.Cells Product Family
1

Hello!

I'm trying to run "xlWB.Worksheets(i).Cells.InsertRow(iRow + 1)" In my program, and it fails if the inserted row is in a named area of the worksheet and that named area is referred to in a forumla later on.

For example,

the range A20:AA22 is named "areaname", I then try to run

xlWB.Worksheets(0).Cells.InsertRow(21)

If the formula in V23 is "=DSUM(areaname;"Int";M1:M2)/(DSUM(areaname;"Int";N1:N2)/2)", I will get a Exception, if I remove the formula it works fine.

2

Hi,

Thanks for considering Aspose.

Thanks for reporting it. Well, yes, we can reproduce the issue using your scenario.

We will figure it out soon.

Thank you.

3

Please try this attached fix.

4

Worked great, thanks for the fast reply!