Slow Performance Reading Formula

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

  • Posted 18 March 2021, 11:43 pm 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



  • Marked as Answer

    Replied 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
  • Replied 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
  • Replied 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.
  • Replied 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
  • Replied 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.
  • Replied 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.
Need extra support?

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

Learn More

Forum Channels