This is a migrated thread and some comments may be shown as answers.

Navigation With Arrow Buttons

9 Answers 37 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Tomasz
Top achievements
Rank 1
Tomasz asked on 24 Jan 2018, 06:33 PM
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.

9 Answers, 1 is accepted

Sort by
0
Ivan Danchev
Telerik team
answered on 26 Jan 2018, 01:23 PM
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
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Tomasz
Top achievements
Rank 1
answered on 26 Jan 2018, 02:28 PM
Interesting, that is not the behaviour I am getting. It might be because I am not using the newest version of telerik.
0
Tomasz
Top achievements
Rank 1
answered on 26 Jan 2018, 03:45 PM
Indeed, upgrading to the newest version gave me this behaviour. Thank you.
0
Tomasz
Top achievements
Rank 1
answered on 26 Jan 2018, 03:53 PM
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?
0
Dimitar
Telerik team
answered on 30 Jan 2018, 02:25 PM
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
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Tomasz
Top achievements
Rank 1
answered on 30 Jan 2018, 02:42 PM

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.

0
Dimitar
Telerik team
answered on 01 Feb 2018, 10:25 AM
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
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Tomasz
Top achievements
Rank 1
answered on 01 Feb 2018, 02:36 PM
I would like to add that this bug happens when using the enter button and tab button in addition to the arrows.
0
Dimitar
Telerik team
answered on 02 Feb 2018, 05:40 AM
Hello Tomasz,

I have updated the issue with the additional details provided.

Regards,
Dimitar
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Spreadsheet
Asked by
Tomasz
Top achievements
Rank 1
Answers by
Ivan Danchev
Telerik team
Tomasz
Top achievements
Rank 1
Dimitar
Telerik team
Share this question
or