Entering decimal comma

[KR]

Hello,

Please take a look at http://jsfiddle.net/1k5r9j0v/1/

Formatting is done by using format: '##.###,00' in the colmodel. This works great!

However, when editing the values, it does not allow comma as decimal mark. Is there a way of allowing this? Our users must be able to input an amount like 1234,56.

Do I have to use data type string instead?

Thank you.
KR.

[paramvir]

Thanks for sharing jsfiddle.

That would require disabling the filterKeys feature in column.editModel and customizing the editor to replace "." by "," during initialization and replace "," by "." during saving data from editor.

Code: [Select]

                editModel: { filterKeys: false },
                editor: {
                   init: function(ui){
                  var $inp = ui.$cell.find("input"),
                    val = $inp.val();
                    //replace "." by "," 
                    val = val.replace(".",",");
                    $inp.val(val);
                  },
                  getData: function(ui){                   
                    var val = ui.$cell.find("input").val();
                    //replace "," by "." 
                    val = val.replace(",",".");                   
                    return parseFloat(val);
                  }
               }               

http://jsfiddle.net/1k5r9j0v/2/

[KR]

Thank you!