Last Updated: 24 Sep 2020 07:32 by ADMIN

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

Last Updated: 11 Aug 2020 10:27 by ADMIN
Created by: Scott
Comments: 0
Category: Spreadsheet
Type: Feature Request
Implement Telerik.Web.Spreadsheet for .Net Core
Last Updated: 22 Jun 2020 18:38 by Sudeshna
Created by: Sudeshna
Comments: 0
Category: Spreadsheet
Type: Bug Report

Bug report

Reproduction of the problem

  1. Download the excel file attached in Ticket ID: 1469596
  2. Open it in the Spreadsheet.
  3. Filter a column, for example the "Anatomy" column, deselect all and leave only "Abdo".
  4. Filter another column, for example Timepoint Name. Deselect all and select only V31. Note that this value does not match any "Abdo" row. Because of that, in Excel "V31" is not even available in the filter, once the "Anatomy" column is filtered by "Abdo". In the Spreadsheet the second column can be filtered by "V31".

Current behavior

No data is displayed after filtering the second column (expected), but the header is duplicated.

Additional notes: the file has been tested against the Open XML SDK tool and it reports 4 issues related to Fonts, however, the duplication occurs even after modifying the original file and applying an arbitrary font and font-size to the whole document, so that it passes the tool's verification successfully.

Expected/desired behavior

No data is displayed and there is no header duplication.


  • Kendo UI version: 2020.2.607
  • jQuery version: x.y
  • Browser: [all]