I am using your Aspose.Cells component in one of my software projects, and am finding the Workbook.CalculateFormula method to be very, very slow with my files. I have created a test console app that simply opens the file using:
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(@"C:\WebTemplate2.xlsx");
workbook.CalculateFormula();
The call to new Aspose.Cells.Workbook takes about 3 seconds, but the call to CalculateFormula takes almost 14 seconds! I am wondering if there is an issue with my file that I can correct that will speed this up, or if there is something in the component that is causing this, or some combination of the two.
I have attached a sample file that I am using to run these benchmarks tests. Please let me know if you see anything that is causing this to be so painfully slow. This is for a web application so 14 seconds will make Aspose.Cells completely unviable as an option for us. Thanks!