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

Aspose.Cells Product Family
1

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

2

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.
3

Hi,


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

4

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

5

Hi,


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

Thank you.
6

Hi,

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

7

Shakeel,

Thanks. That fixed it.

David

8

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.