Array formula references aren't updated on delete of row or column

If you delete a row or column array formula references aren't being updated. Also if you delete a row the autofilter row isn't being updated.

To duplicate:

Dim excel As Workbook = New Workbook(Application.StartupPath & "\Input.xlsx")

' Delete column on the data sheet

excel.Worksheets(1).Cells.DeleteColumn(0, True)

' Delete row on the data sheet

excel.Worksheets(1).Cells.DeleteRows(0, 1, True)

excel.Save(Application.StartupPath & "\Output.xlsx")

Thanks,

David

Hi,


Well, using your sample code with your template file, I can find the issue as you have mentioned. I have logged a ticket for it with an id: CELLSNET-40057. We will look into it to figure it out soon.

Thank you.

Hi,


Please try the latest version/fix v7.0.2.4. We have fixed the issue now.

Amjad,

Thank you for the fix. The formulas are now updating correctly. However, the autofilter row is still not being updated when rows are deleted.

Thanks,

David

Hi,


Yes, I noticed the issue. I have logged it and we will also figure it out soon.

Thank you.

Hi,

We have fixed this issue. Please download:
Aspose.Cells for .NET v7.0.2.6

Shakeel,

Thanks. That fixed it.

David

The issues you have found earlier (filed as CELLSNET-40057) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.