I am using the 'number' type for entering floating point numbers into a jqGrid grid. I am able to format the floats for rendering witha ma (we use a man in Europe as decimal seperator). However the input fields (edit form or inline) still assume that that entered floating point numbers use a dot and not a ma.

formatoptions: {decimalSeperator : ','}

seems to influcence the rendering but not the validation of the input data.

Any reasonable options here?

I am using the 'number' type for entering floating point numbers into a jqGrid grid. I am able to format the floats for rendering witha ma (we use a man in Europe as decimal seperator). However the input fields (edit form or inline) still assume that that entered floating point numbers use a dot and not a ma.

formatoptions: {decimalSeperator : ','}

seems to influcence the rendering but not the validation of the input data.

Any reasonable options here?

• javascript
• jqgrid

• I think, The spelling of the word "seperator" is not correct. Modify spelling as "separator" – amin Commented Jul 8, 2018 at 5:26

1 Answer 1

You can create your own custom formmaters.

http://www.trirand./jqgridwiki/doku.php?id=wiki:custom_formatter

The guide explains it well. You must create a formmater and an unformmater for editing.

Create a formatting function like this:

<script>
    jQuery("#grid_id").jqGrid({
    ...
       colModel: [ 
          ... 
          {name:'price', index:'price', width:60, align:"center", editable: true, formatter:numFormat, unformat:numUnformat},
          ...
       ]
    ...
    });

    function numFormat( cellvalue, options, rowObject ){
        return cellvalue.replace(".",",");
    }

    function numUnformat( cellvalue, options, rowObject ){
        return cellvalue.replace(",",".");
    }
</script>

You can also append $ or other formatting in these functions.