Number format without group separators

[Stefano Enrico]

Hi,

i have a grid where i want to display number without group separators. I use {0:n2} format

http://jsplayground.syncfusion.com/Sync_qmyrx2ec

how can I do?

Thanks

Stefano

[Seeni Sakthi Kumar Seeni Raj]

Hi Stefano,  

 

We could see you would like to remove the group separator. This can be achieved using the queryCellInfo event of the Grid. In this event, we will format the respective cells as shown in the following code example.  

 

<script type="text/javascript"> 

    $(function () { 

        $("#Grid").ejGrid({ 

            dataSource: window.details, 

            columns: [ 

                     { field: "Number", textAlign: ej.TextAlign.Right, width: 110 }, 

                     { field: "Currency", format: "{0:c2}", textAlign: ej.TextAlign.Right, width: 110 }, 

                     { field: "Date", format: "{0:MM/dd/yyyy}", textAlign: ej.TextAlign.Right, width: 110 } 

            ], 

            queryCellInfo: function (args) { 

                if (args.column.field == "Number") 

                    $(args.cell).text(Number(args.data.Number).toFixed(2)); 

            } 

        }); 

    }); 

</script> 

 

Refer to the following API Reference and sample demo. 

 

https://help.syncfusion.com/api/js/ejgrid#events:querycellinfo 

http://jsplayground.syncfusion.com/fv4ckjbd 

 

Regards,  

Seeni Sakthi Kumar S.