Navigation With Arrow Buttons

[Tomasz]

Is it possible to alter the behaviour of the spreadsheet with some javascript that would allow a user to type a value into a cell and then press the down arrow to set the value and move to the next cell? Simply registering the event and changing which cell is selected doesn't work because the value in the cell doesn't actually get set and I've tried simulating an enter key press but that didn't work because of compatibility issues.

[Ivan Danchev]

Hello Tomasz,

If I understand correctly the behavior you described, the Spreadsheet already works this way. Here's a short screencast showing how values are set (indicated by the widget's change event firing) when you type in the cell and press Down Arrow key (Enter key is not pressed). The dojo example used to record the screencast. Let me know in case I misunderstood the scenario.

Regards,
Ivan Danchev
Progress Telerik

[Tomasz]

Interesting, that is not the behaviour I am getting. It might be because I am not using the newest version of telerik.

[Tomasz]

Indeed, upgrading to the newest version gave me this behaviour. Thank you.

[Tomasz]

Actually, upgrading has caused another change in the behaviour; if you enter values faster than the spreadsheet can keep up with it will make the entries blank whereas in the old version the spreadsheet would eventually catch up and enter what you typed no matter how quickly you type the values in. The spreadsheet adding blank values is not desirable. Is there any way to get the old behaviour back?

[Dimitar]

Hello Tomasz,

I am not quite sure that I can understand the scenario correctly. May I ask you to provide additional clarifications on how the described issue can be reproduced? It will be most helpful if you could provide a short video that demonstrates the issue.

Regards,
Dimitar
Progress Telerik

[Tomasz]

If you go to the spreadsheet and press 1 then down then 1 then down over and over again quickly then it is possible that a cell will not be populated with a value. I have to do it quite quickly in the dojo link Ivan sent to get the effect but this is a concern for end users using my app with slow machines and who are accustomed to inputting numbers to spreadsheets quickly. In older versions of telerik the inputs were buffered and it was impossible to get unfilled cells regardless of how quickly you entered the data.

[Dimitar]

Hello Tomasz,

I have investigated the described scenario and managed to reproduce the issue on a relatively slow machine. I have logged this as a bug with high severity in the official Kendo UI GitHub repository and you can start tracking our progress on it from issue #3959.

Also, as a token of gratitude for reporting this bug, I have updated your Telerik points accordingly.

Regards,
Dimitar
Progress Telerik

[Tomasz]

I would like to add that this bug happens when using the enter button and tab button in addition to the arrows.

[Dimitar]

Hello Tomasz,

I have updated the issue with the additional details provided.

Regards,
Dimitar
Progress Telerik