Last Updated: 24 Sep 2020 07:32 by ADMIN
Created on: 23 Sep 2020 07:47
Category: Spreadsheet
Type: Feature Request
Need to be able to refresh a cell calculation a number of times in a batch command for the sheet (for a monte carlo simulation) i.e. suspend layout during the operation.

I raised a support ticket for the spreadsheet control regarding performance and was asked to make a feature request. I'm running a Monte Carlo simulation in a relatively simple spreadsheet. I need to recalculate a cell value (which references other cells including a random function in a formula) and enter that in a new cell. The process is repeated 500 times so I have 500 new numbers. This is nearly instant in Excel desktop and online. In the telerik control each time I get the value of the cell and set it to the new cell it takes 1-2 seconds. Setting the new cell refreshes the one referencing the random number. The routine can take over 10 minutes to run. If I run in a batch job the cell with the random number is not recalculated so I have the same number 500 times. I need to be able to recalculate the cell without the overhead of updating the layout.  

Introduction to Monte Carlo simulation in Excel

1 comment
Ivan Danchev
Posted on: 24 Sep 2020 07:32

Hello Derek,

Thank you for submitting this feature request. It is now visible in the Feedback Portal, and the community members can vote for it.

Ivan Danchev
Progress Telerik

Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive, special prizes, and more, for FREE?! Register now for DevReach 2.0(20).