Posted 10 September 2017, 10:57 am ESTHi 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 !
Posted by: candrez on 10 September 2017, 10:57 am EST
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.