Using Aspose.Cells 4.4.0 for .Net.
I have multiple sheets with multiple inserts and deletes on each one to output the data. Some of the formulas that refer to other sheets are not being updated correctly to take account of all of these inserts and deletes and end up pointing at the wrong rows. I have attached a simple example that shows that the SUM formula is incorrect at the end (although formulas using CELL1+CELL2+CELL3+CELL4 are updated correctly).
Dim license As Aspose.Cells.License = New Aspose.Cells.License
Dim excel As Aspose.Cells.Workbook = New Aspose.Cells.Workbook
excel.Worksheets(0).Cells.InsertRows(0, 2, True)
excel.Worksheets(0).Cells.DeleteRows(0, 1, True)
excel.Worksheets(1).Cells.InsertRows(0, 2, True)
excel.Worksheets(1).Cells.DeleteRows(0, 1, True)