I use client side library jqGrid. When I display column I use format options of column like this

<div class="sfcode"><span style="color: #0000ff;">{ name: &#39;Salary&#39;, index: &#39;Salary&#39;, width: 100, align: &#39;right&#39;, sortable: false,<br /> editable: true, formatter: &#39;number&#39;,<br /> formatoptions: { decimalSeparator: ",", thousandsSeparator: ".", decimalPlaces: 2} }</span><br /> </div>

1 2 3 4

<div class="sfcode"><span style="color: #0000ff;">{ name: &#39;Salary&#39;, index: &#39;Salary&#39;, width: 100, align: &#39;right&#39;, sortable: false,<br /> editable: true,  formatter: &#39;number&#39;,<br /> formatoptions: { decimalSeparator: ",", thousandsSeparator: ".", decimalPlaces: 2} }</span><br /> </div>

So, I format number to use “,” for decimal separator and “.” for thousands separator. But when I edit row this column has numbers formatted like “.” for decimal separator and “,”for thousands separator.

Does anyone have idea how change format of number when I am in edit mode (Form edit). Even if I include localization file (“grid.locale-de.js”) number in column is formatted like “1.234,22” but on edit form there is “.” For decimal separator which is for users very confusing. And validation of entered value is also recognized as mistake…. Is this behavior bug or am I missing something??

How can I correct this behavior? I would like to have same formats (as in my code) in display and edit mode. Thank you for any help!