DH1001
November 3, 2011, 5:36am
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
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.
DH1001
November 4, 2011, 11:07am
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
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
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 .