Slow Performance Reading Formula

Slow Performance Reading Formula

Posted by: mikael.harthin on 18 March 2021, 11:43 pm EST

• 

  mikael.harthin

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 March 2021, 11:43 pm EST - Updated 29 September 2022, 6:34 am EST

  Hi

  We are switching from Windows Forms FarPoint version 12.45.20191.0
  
  to Documents (4.0.6) and have noticed a large performance decrease in .Formula See picture. equivalent Windows Forms is fast.

  Any ideas?
  
  Mikael

  

  1062×182 37.7 KB

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 March 2021, 9:27 pm EST

  Hi Mikael,

  The latest version of GcExcel is 4.0.4 and at our end the performance when checking the formula is fine. Please find the attached sample and if you are doing something else then please modify the sample accordingly so that we can assist you better.
  
  https://www.nuget.org/packages/GrapeCity.Documents.Excel/

  Regards,
  
  Prabhat Sharma.
  
  Performance_Performance.zip

• 

  mikael.harthin

  • Post Options:
  • Link
    Copy

  Posted 8 April 2021, 7:37 pm EST

  Hi
  
  I created a demo project where you can see/test the performance differences
  
  regards,
  
  Mikael

  GrapeCitySpreadPerfDemo.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 12 April 2021, 11:58 pm EST

  Hello Mikael,

  Thank you for the sample attached.
  
  We have forwarded this to the developers and will let you know as soon as we get any update on this from their end.
  
  [Internal Tracking ID: 3974]

  Regards,
  
  Prabhat Sharma.

• 

  mikael.harthin

  • Post Options:
  • Link
    Copy

  Posted 28 April 2021, 5:03 pm EST

  Hi Prabhat,

  Just wanted to check if there is any news on this?
  
  Have you been able to reproduce the issue that we are facing?
  
  This is currently a bit of a show stopper on our end and we would need
  
  to know if this is something that will be fixed at your end in upcoming
  
  bug fixes or something we have to solve ourselves.

  Have a nice day,
  
  Mikael

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 29 April 2021, 1:35 pm EST

  Hi Mikael,

  Our developers are working on this issue.
  
  We are getting in touch with them to get the update on this.

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 17 June 2021, 3:38 am EST

  Hello,

  This issue has been fixed in the latest version of the GcExcel API version 4.1.2. Please update your project with the latest builds to avoid this issue:
  
  https://www.nuget.org/packages/GrapeCity.Documents.Excel/

  Regards,
  
  Prabhat Sharma.