Workbook wb = new Workbook(@“Test.xlsx”);
Stopwatch sw = Stopwatch.StartNew();
wb.CalculateFormula();
Console.WriteLine($“{sw.ElapsedMilliseconds}ms”);
It will take about 1 minite to calculate formula.
Test.7z (556.…... If the search range is simple reference, such as...caching and re-arranging the range data(so even though the formulas...