Performance

Posted by: candrez on 10 September 2017, 10:57 am EST

  • Posted 10 September 2017, 10:57 am EST

    Hi again, I've been using the spreadsheet on my project, I need to use it as a "Live updating spreadsheet", but I have a couple of troubles related with perfomance, Could you please provide me an example or a way to improve the updating process for each cell ? At this moment is really poor, Thanks again !
  • Replied 10 September 2017, 10:57 am EST

    You may use SuspendEvent/ResumeEvent methods to surround the updating process for each cell. If the process causes UI refresh, you may use AutoRefresh=false/true to surround it. If there is lot of formula in cells, you may use SuspendCalcService/ResumeCalcService to surround the process.

    I am curious what updating process for each cell you did, maybe there is another better way to improve performance.

Need extra support?

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

Learn More

Forum Channels