Workbook.CalculateFormula() taking more time

Hi Team,

We have a situation in our project where we need to calculate formulae in an excel using workbook.CalculateFormula(). There are 3 sheets in the workbook with many cross-sheet formulae and thousands of rows and columns in each of the worksheet. This aspose method is taking 5 to 6 minutes to execute. Is there a way to improve this time?

Quick response is appreciated.

Regards,

Raghav

Hi,


We recommend you to kindly try the latest version/fix: Aspose.Cells for .NET v7.3.0.2
if it makes any difference.

Also, please disable creating calculating chain (This chain is useful if you are calling CalculateFormula method many times to speedily calculate the formulas in 2nd, third, fourth and so on times. If you are calling CalculateFormula 1 or 2 times, you may disable creating the calculation chain accordingly).

See the sample code for your reference:

var workbook = new Workbook(“e:\test2\TestTemplate.xlsx”);
workbook.Settings.CreateCalcChain = false;
workbook.CalculateFormula();


If you still find any issue, kindly attach your template file, we will check your issue soon.

Thank you.