Workbook CalculateFormula very slow

Aspose.Cells Product Family
1

Hi

I have been trying to use the Workbook.CalculateFormula() method to refresh the formulas on a spreadsheet but this seems to be very slow when dealing with a large number of formulas.

I have atatched an example spreadsheet showing the tyep of daat I am working with. My test code just looks like:

string templatePath = @"C:\TEMP\GRG_ALLCompsNov.xlsx";

string fileName = @"C:\TEMP2\GRG_ALLCompsNov.xlsx";

Aspose.Cells.Workbook myWorkbook = new Workbook();

myWorkbook.Open(templatePath);

myWorkbook.CalculateFormula();

myWorkbook.Save(fileName, Aspose.Cells.FileFormatType.Excel2007Xlsx);

If I remove the step to calculate formulas then this takes a few seconds - with the step included this does not complete even after 5 minutes.

Can you advise what I can do about this?

Many Thanks

2
Hi,

Thanks for the sample file.

I can notice the issue as you have mentioned. I tried the following code with v7.3.5.3 (latest version/fix) using the template file, it takes more time than it should.

Sample code:


string templatePath = @"e:\test2\GRG_ALLCompsNov.xlsx";

string fileName = @"e:\test2\outGRG_ALLCompsNov.xlsx";

Aspose.Cells.Workbook myWorkbook = new Workbook(templatePath);
//This also does not make any difference.
//myWorkbook.Settings.CreateCalcChain = false;

myWorkbook.CalculateFormula();

myWorkbook.Save(fileName);

I have logged a ticket with an id "CELLSNET-41350" for your issue. We will look into your issue soon.

Thank you.
3

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.4.0.1 and let us know your feedback.

4

The issues you have found earlier (filed as CELLSNET-41350) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.