.I have a language file that defined the decimal seperator as “,” for numbers. E.g. 12,34.
When viewing data in columns that have “formatter:number” the grid correctly displays it in this format.
But when editing inline, the format is changed back to the original format with a decimal, thus the number becomes 12.34. This is confusing for the end user who of course wants to see and edit data in a consistent format.
The inline editing is started from a “formatter:action” button.
The docs state: “All predefined types are compatible with the editing modules. This means that the numbers, links, e-mails, etc., are converted so that they can be edited correctly.”
Any help would be appreciated.
Hello,
The documentation explain it very goog. JavaScript does not understand numbers with decimal separators. Such numbers are treated as string. That is the reason that we display in grid the number with decimal separator as comma, but when edit it the predefined formatter convert it to a way that it can be understand for JavaScript.
In order to solve your problem you will need to use custom formatter and unformat function and then use serializeRowData to convert back the number to a valid number, since your database understand numbers with decimal separator as point.
Below is the code:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<script> jQuery("#grid_id").jqGrid({ ... colModel: [ ... {name:'price', index:'price', width:60, align:"center", editable: true, formatter:numFormat, unformat:numUnformat}, ... ], // this for inline edit searializeRowData: function( row ) { row.price = row.price.replace(",","."); return row; }, ... }); function numFormat( cellvalue, options, rowObject ){ return cellvalue.replace(".",","); } function numUnformat( cellvalue, options, rowObject ){ return cellvalue; } </script> |
Hope this helpls
Kind Regards
Hello,
To be a honest I do not have tested this.
So my question is:
Which editing module do you use?
Form edit, inline edit or cell edit?
Every such module has its own serialize function.
I will check this and will try to prepare a example, since this is a basic question.
Kind Regards
Hello,
Sorry, it is not clear – in the head section of the code tab (HTML) you will see the links, but they are not readable ok.
This is the link to the new fixed file
Kind Regards
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
