Start Building Professional
Web Apps Today

NumberFormat issue

I am using a grid with one of the column type as edn and using NumberFormat of 0,000.00. This formats and works okay if the user just enters any number. But if alpha is entered after the number (eg:23sds) or a comma (eg:23,000.00) it converts to 23.00.
I would want to warn the user that alpha is not a valid number. And should be able to ignore the commas the user enters. Could you let me know how I can do it?

Thanks in advance.

While it possible to inject custom validation in normal edit process through onEditCell event, in case of built in formating the custom code can be injected only after value of cell already formated which is not usable in your case.
The only solution in your case - is create a custom excell with custom formating or validation rules.