Performance degradation of one workbook after library version up

Performance degradation of one workbook after library version up

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

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 14 February 2022, 11:43 am EST

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