Performance problem with specific workbook

Aspose.Cells Product Family
1

Hi,
We are currently using other library (GcExcel) in our product and comparing the result with your product. Most of the time your product is performing same or better than GcExcel, but the problematic workbook is performing 4 or 5 times slower at our end.

We are getting and setting lots of cells during the process and when getting cell values with formulas we want to get the latest values so we need to calculate the cells before getting the values. We don’t know how the formulas will be so we can only choose to calculate formulas recursively for the precise results.

Please refer attachment for reproduction.

We need to explain the reasons why this workbook is performing so poorly to our stakeholders and hope that there are some ways to achieve the same or better performance that GcExcel. Thank you.

Best regards
Wenjin

GcExcelPerformance.zip (4.2 MB)

2

@wwu
By using the sample project for testing on the latest version v24.6, we can reproduce the issue. Performance issues were found with multiple calls to the Cell.Calculate(CalculationOptions options) method.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-56001

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

Hi, John

Thank you for the swift response. We are looking forward to the fix.

4

@wwu,

Sure, we will keep you posted with any updates on the resolution once it is available.