Hi,
Thanks for your posting and using Aspose.Cells.
Please download and try the latest version: Aspose.Cells
for .NET v8.6.0.2 and see if it makes any difference and resolves your issue.
If your issue still occurs the please provide us your sample code or sample console application project along with your source excel files for our investigation. We will look into it and help you asap.
Hi,
https://goo.gl/fjhrpz
.
Hi,
Thanks for your posting and using Aspose.Cells.
We have tested this issue with the following sample code using the latest version but the process seems to be taking lot of time. Although the file size itself is large so it seems to be a usual thing.
We have therefore logged this issue in our database for investigation. We will look into it and improve if if possible. Once, there is some news for you regarding this issue we will update you asap.
This issue has been logged as
- CELLSNET-43945 - Slow Workbook calculation
C#
string filePath = @“D:\Downloads\templates\case1.xlsx”;
Workbook workbook = new Workbook(filePath);
Stopwatch sw = new Stopwatch();
sw.Start();
workbook.CalculateFormula();
sw.Stop();
Debug.WriteLine("--------------" + sw.ElapsedMilliseconds);
+100500 to the originator!!
Hi,
Thanks for your posting and using Aspose.Cells.
We have logged your comment in our database against this issue for product team consideration. We will look into it and implement/fix it if possible. Once we will have some update for you, we will let you know asap.
Thanks for using Aspose.Cells.
The reason of lower CPU usage is because Aspose.Cells does not support multi-threads calculation. As you might have found, ms excel can use the total 4 cpus when calculating formulas but Cells can only use one of them. We may consider to improve our calculating engine with support of multi-threads in future for newer versions, but it is a complicated task to rebuild cells model to support multi-threads calculation and we are afraid we cannot support it soon.
Hi,