I have a Telerik numeric text box in an editor template with an onblur that doesn't seem to fire when tabbing between columns on a single row.  As soon as I either click or hit enter the onblur does fire.  Is there something I am missing here?

Can you put an entire row into edit mode by clicking on one of the cells?  I assume you would use OnRowClick, but how do you put that row into edit mode (inline editing).  This may solve my issue as well.

Wes

Marin,

Is it possible to run update handler when moving between cells?  I have implemented the onblur inside of editor template and that seems to work when clicking between cells, but I also need to update values when moving between cells with tab vs waiting for the entire row.

I understand the desire to only fire when the entire row is updated so only making a single round trip to the database, but I'm updating local variables so performance is not as much of a concern between cells.

Thanks.

Wes

Thanks Marin and Eric.

Marin,

I understand your position on this and I will give it a rest after this.  I just wanted to clarify what kind of functionality we are looking for in the context of a web grid. 

I have attached a (40 second) screen capture video (no audio) of me demonstrating grids in other web applications that our clients use.  The applications are shown in the following order: Business Central, Salespad, and Quickbooks Online.  All 3 are web applications and have the navigation functionality in their grids that we are looking to duplicate in our application.

I understand if this is outside of the scope of what you have planned for the Telerik Blazor Datagrid control. We will just have to try to duplicate it ourselves or rely on a control from another vendor.

Thanks,

Brenon

Thanks Eric. Great post.

Don't mean to pile on... so huge apologies Marin. Glad that discussion is going on, and we definitely appreciate the technical challenges.

We'll continue to follow.

Seth

Hi folks. Marin and I have had this debate for a while now and it's covered pretty well here. I do understand his perspective. I've also made it clear that coming from a financial background, data grids that do not edit intuitively as a table do not go over well with users. It's worth noting that a lot of the behavior described is not limited to Excel - but is common with almost every popular solution for editing tables that exists. That said, Marin has his limitations and a wide audience to cater to.

It may be worthwhile to check out ComponentOne's blazor grid:

https://demos.componentone.com/blazor/blazorexplorer/FlexGrid/NewRow

They seem to have achieved a more intuitive editing interface for the grid. To be honest, for my use-case in my Blazor environment, I ended up sticking with Telerik. However, wanted to point out that this is an option.

Eric

Marin,

Thanks for your very prompt response and feedback!

I definitely acknowledge that there are a lot of differences from Excel and the DataGrid.  As Seth mentioned what we are actually trying to do is mimic behavior of a WPF DataGrid we use in another application of ours.  I haven't used Telerik's WPF Datagrid but I assume it would have similar features to be able to navigate throughout the grid with the keyboard while in edit mode.  The TAB (and SHIFT-TAB for backwards) functionality to go to the next cell while in edit mode seems extremely standard across almost every editable datagrid. 

For the other directions, I understand the challenges of dealing with conflicts of expected functionality with other keys such as the arrow keys, but presumably a different key combination could be used?  Maybe CTRL+Arrow or some other modifier?

If this is really not something you would have any interest in implementing would it at least be possible to get some kind of key capture at the top level of the Grid so we can do our own logic without having to implement the same logic in a template for every column? It seems like having key events at the top grid level would be a useful feature in general for other purposes as well.

Thanks,

Brenon

Marin,

Thank you for your feedback.

Perhaps comparing the data grid to excel is not appropriate. The standard to which we (I work with Brenon) are holding the Blazor grid is behavior of a data grid for WPF, or at least getting close. While I'm not intimately familiar with Telerik's WPF grid, we have many users on a competitor's WPF grid and standard "Excel like" behavior, such as using the down arrow to complete numeric cell editing and select the cell in the row below, is expected. Multiple keystrokes to edit a cell, particularly cells in adjacent rows, is not really acceptable.

The up/down behavior of arrows, for users in financial or inventory types of applications, is also not really valuable (my own opinion). We've been able to disable that behavior by not showing arrows and setting Step (I think that's the property) to zero. So in this case, up/down is doing nothing from a cell being edited.

We will work with capturing keyboard events and see if we can get close to desired behavior.

Regards,

Seth

We also are looking for some more efficient keyboard navigation features in the Grid, especially when it comes to navigating while editing.

Right now there does not seem to be a way to use the keyboard navigate efficiently while editing.  When not in edit mode, the Navigable="true" setting does let you switch between cells, but then once you are in edit mode you have to exit edit mode before resuming navigation.

In our application users need to be able to efficiently navigate both vertically and horizontally in the grid while performing edits.  Right now we are using Inline editing so that we can at least tab between fields horizontally, but there is no way to easily navigate one cell down and continue editing.  We have tried using Incell editing along with Navigable="true", however the navigation is very inefficient while editing. 

For example when editing a text or numeric field using Inline with Navigable to get to the next cell over you need to do several steps:

- Close edit mode (Enter key)

- Navigate (using arrow keys) to the next cell over or down

- Enter Edit mode (Enter or F2)

- Manually select existing text or number using CTRL+A or mouse

- Begin typing new value

It would be nice if it worked more similarly to Excel or other data grids such that there was a single key to press to navigate to the next cell and then you could just begin typing the new value. For example a proposed workflow would be when starting in edit mode of a cell:

- Press TAB (moves to cell to the RIGHT, puts it in edit mode, and selects current value)

- Begin typing new value

Similar workflow with different key combinations could move LEFT, DOWN, or UP.

If there is a way to accomplish this today I would be very interested in hearing it.  I have looked into trying to handle it myself but there do not seem to be key events on the grid that would allow me to attempt such a thing; short of adding my own handler to every cell via templates.

Hello Marin,

thanks a lot for this info.  This was the missing puzzle piece to get rid of the save/cancel buttons with incell-editing.

Regards,

René