Calculate formula on large excel data of more 140K rows not working and taking too much time to calculate formulas on excel using Aspose Cells

@sridharravva2020,

We evaluated your sample code segment. The Excel file you provided in the zipped archive does not seem your original file, we do not find any sheet you specified in your code, Even, we run your code with your file accordingly, it finished rapidly after loading the template file. In short, we could not find any performance issue. It is best that you provide exact simulation code with original file as it is compulsory for us to reproduce the issue on our end first. So, please do the needful and provide us the sample application (runnable) with original files to show the issue, we will check it soon.

@sridharravva2020,

We are pleased to inform you that we have improved the formula engine for such kind of formulas. We hope the new fix (upcoming) will resolve your performance issue. By our test, the time cost can be reduced to about 5 minutes with the improvement. We will share the fix for your testing soon.

Keep in touch.

@sridharravva2020,

Please try our latest version/fix: Aspose.Cells for .NET v20.7.2 (attached)
Aspose.Cells20.7.2 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.7.2 For .Net4.0.Zip (5.4 MB)

We have made significant improvement for formula calculations. With the new fix you should get the expected performance.

Let us know your feedback.

The issues you have found earlier (filed as CELLSNET-47387) have been fixed in Aspose.Cells for .NET v20.8. This message was posted using Bugs notification tool by Amjad_Sahi