Rank 2
I have a RadGridView with a GridViewDecimalColumn. I want to allow the user to move up and down to other rows using the up/down arrow keys, but it changes the value instead. This occurs even if I set ShowUpDownButtons to false.
I found an old example on the forum that explains how to change this behavior here: https://www.telerik.com/forums/gridviewdecimalcolumn-up-down-key. However when I try the code there, I can't get it to work. GridSpinEditorElement is not found. I have the Telerik.WinControls and Telerik.WinControls.UI namespaces included.
I looked up GridSpinEditorElement, to see if I needed a different namespace, and it seems it's no longer available. I'm referencing this page:
https://docs.telerik.com/devtools/winforms/api/html/t_telerik_wincontrols_ui_gridspineditorelement.htm
It says it's obsolete and shows version 2018.1.220.40. I'm on version 2018.3.911.40.
How can I implement this code now without GridSpinEditorElement?
Thanks
4 Answers, 1 is accepted
You need to use the RadSpinEditorElement class instead. Otherwise, the code is valid and will work for this case.
I hope this will be useful. Let me know if you have additional questions.
Regards,
Dimitar
Progress Telerik
Rank 2
private void radGridView_CellEditorInitialized(object sender, GridViewCellEventArgs e){ if (e.ActiveEditor is GridSpinEditor editor) { var element = editor.EditorElement as RadSpinEditorElement; element.InterceptArrowKeys = false; element.KeyDown -= new KeyEventHandler(element_KeyDown); element.KeyDown += new KeyEventHandler(element_KeyDown); }}private void element_KeyDown(object sender, KeyEventArgs e){ if (sender is RadSpinEditorElement element) { var gridView = element.ElementTree.Control as RadGridView; if (e.KeyData == Keys.Down) { gridView.GridNavigator.SelectNextRow(1); } else if (e.KeyData == Keys.Up) { gridView.GridNavigator.SelectPreviousRow(1); } }}Thanks for sharing your solution.
Do not hesitate to contact us if you have other questions.
Dimitar
Progress Telerik
Rank 1
Hi Dimitar,
This is Gridviewdecimalcolumn and I have iterated the ChildRows collection for each parent row and evaluating the sum programmatically.
Private Sub IterateRows()
For Each row As GridViewRowInfo In template.Rows
MsgBox("Baris Header : " & row.Cells(5).Value)
Dim hierarchyRow As GridViewHierarchyRowInfo = TryCast(row, GridViewHierarchyRowInfo)
If hierarchyRow IsNot Nothing Then
IterateChildRows(hierarchyRow)
End If
Next
End Sub
Private Sub IterateChildRows(ByVal rowInfo As GridViewHierarchyRowInfo)
Dim currentView As GridViewInfo = rowInfo.ActiveView
Dim totalsum As Double
totalsum = 0
For Each view As GridViewInfo In rowInfo.Views
rowInfo.ActiveView = view
For Each row As GridViewRowInfo In rowInfo.ChildRows
'MsgBox("Baris Detail : " & row.Cells(13).Value)
totalsum = totalsum + row.Cells(13).Value
Next
Next
'MsgBox(totalsum)
rowInfo.ActiveView = currentView
End Sub
Now, how to assigned the obtained result to the respective parent cell's value ? Thanks