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();
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?