separate 3 digits of a 3-digit number into a uniDbgrid

[SayeyeZohor]

Hello.
How to separate 3 digits of a 3-digit number into a uniDbgrid cell?

[Sherzod]

3 hours ago, SayeyeZohor said:

How to separate 3 digits of a 3-digit number into a uniDbgrid cell?

Hello,

Sorry, can you please explain in more details?

[SayeyeZohor]

Hello
I have a database in which there is a table.one of its fields is integer type.
Now when I display this field in Grid it shows  8546110069 while I want to display  in Dbgrid like 85,463,110,069
Please keep in mind I want   these 3 digit of the 3 are seprate from as client side and a code which written in Client event

[alfr]

Just type in the format you need in the DisplayFormat field on the field in the table or query object. i.e DisplayFormat = #,###,###,###

 

[SayeyeZohor]

I dont want to change the data set.Any changes that need to be done will only be on Dbgrid and as client side

[Sherzod]

1 hour ago, SayeyeZohor said:

I dont want to change the data set.Any changes that need to be done will only be on Dbgrid and as client side

Maybe something like this?

function reconfigure(sender, store, columns, oldStore, oldColumns, eOpts) 
{
    Ext.util.Format.thousandSeparator  = ",";
    
    //for example columnIndex=3
    columns[3].renderer = function(v) {
        return Ext.util.Format.number(v, "0,000")   
    };
}

 

[SayeyeZohor]

excellent
Thank you