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).
Source code:
Dim license As Aspose.Cells.License = New Aspose.Cells.License
license.SetLicense("Aspose.Cells.lic")
Dim excel As Aspose.Cells.Workbook = New Aspose.Cells.Workbook
Thanks for the update. The formulas are now being updated correctly. However, with 4.4.0.0 it took 36 seconds to generate the file in my project. With 4.4.0.30 it takes 200 seconds to generate with the CPU running between 50 and 60% for most of that. I have tried it 3 times with each version to ensure that the results are accurate. Do you know of any reason why it would be so much slower?