Batch Highlighting Cells

[Marc]

I'd like to highlight cells, in a range.forEachCell method, but each cell has to have a different highlight (background colour) based on some rules. It's quite slow. Is there a way to do this quicker?

Thanks,

Marc

[Stefan]

Hello Marc,

I can suggest checking the background method of the Spreadsheet range. This is a faster option to set the background:

http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range#methods-background

I made an example to demonstrate this with a bigger range:

http://dojo.telerik.com/iQAYA

If this is not an option, please send a runnable example demonstrating the current implementation, I and will investigate if it can be optimised. 

Regards,
Stefan
Telerik by Progress

[Marc]

Hi Stefan,

To highlight the cell, I am using the .background method. However, my problem is that I am selecting a massive range (5000 cells for instance), and each cell has to have a check to determine which background colour is applied. Is there any other way around this?

Marc

[Marc]

Hi, 

Sorry I did not read your request for an example. I have provided one below, I believe you should be able to access it, although it's the first time I've used the Dojo site so hopefully you can see it.

http://dojo.telerik.com/@marclazell/AkOwi

Thanks

Marc

[Stefan]

Hello Marc,

Thank you for the provided example.

I observed the same behaviour on my end. As this is calling the background method on 10 000 cells, the operations are slow as they require many DOM manipulations.

I can suggest based on the expected data, to set only the first colour on the whole range, and then based on the data to only change it on the cells that are different as this will greatly reduce the numbers of times of background method is called and also the loading time:

http://dojo.telerik.com/oHuXe

I hope this will help speed up the process.

Regards,
Stefan
Telerik by Progress

[Marc]

Hi Stefan,

Thanks for the investigation - you came to the same kind of conclusion I did. Although - your suggestion is genius. Thank you!

I will check this, and as long as the first colour applied to all cells is the one which is statistically applied more often than not with the logic, then this should help.

Thanks again

Marc