Performance degradation of one workbook after library version up

Posted by: yyoshimura on 13 January 2022, 1:07 pm EST

  • Posted 13 January 2022, 1:07 pm EST

    Hi,

    We noticed that performance of the library degrades drastically with one workbook after upgrading the library from V4.1.2 to V4.2.0 or newer. Please refer attachment for reproduction.

    Following is the result of one run at our end.
    V4.1.2: 0.2 second
    V4.2.0 or later: 156 seconds

    Please help to investigate this issue. It is always happening with this workbook, so we think it should be related to some formulas in the workbook. If there are any ways to avoid this issue it will be very grateful.

    Thank you
    Regards
    gcexcelperformance.zip
  • Replied 13 January 2022, 8:15 pm EST

    Hello,

    We too can observe the difference at our end with the latest and the 4.1.2 version of API. Thus escalated this to the development team for investigation and will let you know as soon as we get the update from their end.

    [Internal Tracking Id: DOCXLS-5400]

    Regards,
    Prabhat Sharma.
  • Replied 7 February 2022, 2:55 pm EST

    Hi,

    This issue is hindering our customers' daily assignments. We are receiving claims from our customers so we want to know if there is any release schedule for this issue? If so please let us know and it'll be very grateful.

    Thank you
  • Replied 8 February 2022, 10:01 pm EST

    Hello,

    As per the development team, the reason for this bug is that the performance of dynamic array formulas is not good enough.

    They explained in more detail about this case:

    1. There are more than 800 dynamic array formulas in the worksheet "受注通期予想(名機)".

    2. When getting a formula value from a worksheet, GcExcel will calculate all the dirty dynamic array formulas in the worksheet firstly.
    3. Close and open the CalcEngine will make all the formulas in the workbook to be dirty.

    According to the above policies, you close the CalcEngine before setting value and open it before getting value, as a result, all dynamic array formulas need to be calculated every time.

    The dynamic array formula of this file is a special formula, its result is a single value, not an array, for this kind of formula, we will improve its performance in the next HF which is scheduled to be released by the end of this week.

    Regards,
    Prabhat Sharma.
  • Replied 9 February 2022, 11:27 am EST

    Thank you for your detailed and helpful explanation. We can fully understand the situation and will consider the ways to overcome this problem.

    Regards
  • Marked as Answer

    Replied 10 February 2022, 9:05 pm EST

    Hello,

    This issue has been fixed in the latest 5.0.3 release of GcExcel. Please upgrade to the latest version to resolve the issue.
    https://www.nuget.org/packages/GrapeCity.Documents.Excel/

    Regards,
    Prabhat Sharma
  • Replied 14 February 2022, 11:43 am EST

    We can confirm that it has been fixed in 5.0.3.
    Thank you for your support.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels