We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Workbook CalculateFormula very slow

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

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.

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.

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.