[Solved] Excel like behavior for editing a GridView cell

[Amit Patel]

I am looking for a feature in a gridview cell that works like excel cell. For example, in excel, I can click on any cell and it would select it, but not go in edit mode but as soon as I start typing it will put that cell in edit mode.  In gridview in order to go in edit mode, user would have to double click or click once when EditTriggers set to CellClick, but in either case it still would not work the way excel cell editing works. Is there a way to achieve this? I have gone through forms and have not found anything that would be closely promising.

Thanks,
Amit

[Nedyalko Nikolov]

Hi Amit Patel,

Sorry for the late answer.
This feature is in our TODO list (already with high priority), so we will introduce it very soon (in a week or two). As soon as this feature is ready we will make it public via latest internal build program so stay tuned.

Kind regards,
Nedyalko Nikolov
the Telerik team

[Santhosh]

Please let us know when it is ready

[Nedyalko Nikolov]

Hello Santhosh,

This feature is available with the latest internal build and 2010.Q3.beta releases. We've create new EditTrigger - TextInput which is set by default and could be controlled via RadGridView.EditTriggers or GridViewDataColumn.EditTriggers property.
Let me know how it works on your end.

All the best,
Nedyalko Nikolov
the Telerik team

[Juliana]

Hello,

I set up EditTriggers="TextInput" and cell does go into edit mode when I start typing. But I also want excel-like behaviour when Delete key is clicked: clear current cell value when hit delete. I overload Deleting event of gridview like

            var item = e.Items.FirstOrDefault();
            (this.DataContext as viewModel).ClearCellValue(item, e.DataControl.CurrentColumn.UniqueName);

            e.Cancel = true;

It helps to clear the cell but  focus rectangle jumps to the first row. And when I start typing, a wrong cell goes into edit mode.
What am I doing wrong? What is the natural way do clearing cell value when EditTriggers="TextInput" (without typing smth and then hit Delete)?

Thanks,
Juliana

[Nedyalko Nikolov]

Hi Santhosh,

In order to achieve this you should override KeyboardCommandProvider like demonstrated in this blog post, because Delete key also select another item (selected item is deleted). Then you could change the value of the underlying business object (which should implement INotifyPropertyChanged) and RadGridView will reflect the change.

Greetings,
Nedyalko Nikolov
the Telerik team