We are experiencing slow calculation using Aspose.Cells for .NET, specifically after upgrading to version 25.1.
If you see the test below, the time to compute 100,000 calculations is twice as long between version 24.12 and 25.1. The contents of Book.xlsx is a simple 3 cell formula: 1+1=2.
[TestMethod]
public void AsposeCellsShouldCalculate12kSimpleSheetsPerSecond()
{
License license = new License();
license.SetLicense(Path.Combine(AppContext.BaseDirectory, "license\\Aspose.Cells.lic"));
// This work book contains a worksheet with 3 cells and the formula will add two cells together. The cells are filled with 1.
// So basically it is calculating a simple formula 1 + 1.
using (var stream = new FileStream(Path.Combine(AppContext.BaseDirectory, "TestData/Book1.xlsx"), FileMode.Open))
{
var wb = new Workbook(stream);
wb.FileName = "Book1.xls";
var t = DateTime.Now;
for (int i = 0; i < 100000; ++i)
{
var ib = new Workbook();
ib.Copy(wb);
ib.FileName = wb.FileName;
ib.CalculateFormula();
}
var s = DateTime.Now - t;
// We measure that Aspose.Cells will finish 100k requests in 7.5 seconds
// But 24.12 will barely pass, and 25.1.1+ will fail where the total seconds are doubled
if (s > TimeSpan.FromSeconds(7.5)) { Assert.Fail($"Performance is not good enough {s.TotalSeconds} second"); }
}
}