Excel-like Navigation while Batch Editing

[Guru]

I did some searching but couldn't find if anyone is doing this...
We are interested in achieving excel-like navigation while batch editing.

Basically when a cell is actively being edited and the enter key is pressed it goes down to the next row and becomes in edit mode (same column).
Also if possible (lower priority) if they instead click TAB it would go to the next cell to the right and be in edit mode.

In effect, editing all values in a given column would be something like the following:
Mouse click the first frow of a column
Type in value and press enter
(takes you to next row and goes into edit mode for you)
Type in value and press enter
(takes you to next row and goes into edit mode for you)
...repeat until you have done all of the rows in a column.

[Dimiter Madjarov]

Hello Zack,


This type of navigation is not officially supported. I would suggest you to disable the default navigation, bind to the edit event of the Grid and manually handle the enter key press. Here is a sample implementation, that you could use as a base and modify further according to the exact requirements.

I wish you a great day!

Regards,
Dimiter Madjarov
Telerik

 

 

[Tsvetelin]

Hello forum,

So, I've followed the sample implementation as a base, (the return key one works like a breeze I've even utilized shift + return) but I also want the tabbing functionality, and this is what I'm doing and the edit state of the next cell doesn't persist, it just flashes then goes to the delete button. The problem isn't in finding the next row and continuing to tab but just to tab on the same row. http://dojo.telerik.com/OXIda/89 Of course, my end plan is to have both working at the same time the tabbing and the return navigation.

Any help would be appreciated.
Thanks in advance.

[Dimiter Madjarov]

Hello Tsvetelin,

Switching the event in which the logic is executed from keypress to keydown seems to be working as expected. Here is the modified example. You should implement the logic for finding the next editable cell on the same row.

Regards,
Dimiter Madjarov
Telerik

 

 

[deshini]

can you please post a sample code for this type of navigation with template rows with input text boxes

[Dimiter Madjarov]

Hello deshini,

We don't have such example available at the moment.

Regards,
Dimiter Madjarov
Telerik