datagrid - format a value

[stephenl]

Hello

I have a datagrid defined as below
                        

Code:

columns:[[
    {field:'Open_Amt',title:'Amt',width:5, align:'right'},
    {field:'Currency',title:'Cur',width:5}									
]],

Currently, Open_Amt format shows as 12345.5

I would like to format value this to show 12,345.50

ie always show 2 places after the decimal point and also show thousands separator

Suggestions appreciated

Thank you

[jega]

Hi.

Use formatter like {field:'Open_Amt',title:'Amt',width:5, align:'right',formatter:formatOpenAmt},

   function formatOpenAmt(row){
      var formattedString = [Find the code you need. There is a lot of possibilities]
      return formattedString;
   }

Look at demo/datagrid/format datagrid columns

OR

If you pull Open_Amt from a database, the format in in your sql so json is already formatted

[stephenl]

If you pull Open_Amt from a database, the format in in your sql so json is already formatted

Great Idea - Thanks !

[jega]

You got the point, even if my text was incorrect spelled.

For others.

If data to datagrid is from a database, then format it directly in your SQL or make a view with the formated columns, and return the formatted JSON data directly to the datagrid.

Please mark topic as [SOLVED] ;-)