RadNumeric - disable keydown decrease the value

[Koen]

Hi,

I am using the radgrid to provide my customer with a data entry form. The customer is very used to excel and the way it works, and like similar functionality. Right now the RadGrid is pretty much doing what I want, I can move around with the keys in the grid to different rows. However, as most of the data is numeric, when I press the down key I both go down in the grid AND the value of the numeric field I am on at that point decreases. Is there an easy way to disable that if I press the down key on a numeric field that the value decreases by one?

[Viktor Tachev]

Hi Koen,

If you would like to use a control that resembles Excel then you should take a look at the RadScheduler control.

• http://demos.telerik.com/aspnet-ajax/spreadsheet/examples/overview/defaultcs.aspx

With that said, I am attaching a sample project where the arrow keys can be used to navigate through the cells of RadGrid. Also one column is using numeric inputs. Give the sample a try and see how it works for you.

Regards,
Viktor Tachev
Telerik

[Koen]

Hi Viktor, thanks a lot, I will take a look at the project. I looked at the spreadsheet example, and this is exactly what my customer wants... IF :) I can lock all the cells apart from the cells where data needs to be inserted. I have seen that the numeric validation etcetera works :)

[Viktor Tachev]

Hello Koen,

The Spreadsheet control gives the option to disable some of the cells. Check out the get_enabled() and set_enabled() methods described in the article below. You can use similar logic to keep only some of the cells enabled.

• http://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/client-side-programming/objects/spreadsheetrange

Regards,
Viktor Tachev
Telerik