treegrid : different setMathRound for different column

Discontinued products Uncategorized discussions
#1

Hi,



i have a treegrid with 10 columns.



the 5 first are integer and the 5 last ones are decimal



if i don’t write : mygrid.setMathRound(2);



math calculation give me lots of number after the ‘.’



so i write mygrid.setMathRound(2) but in the 5 first column which are some quantities, i have 4.00 or 10.00 instead of 4 and 10.



Can i specify mygrid.setMathRound(0) for the 5 1st columns and mygrid.setMathRound(2) for the next ones ??



Best regards,

Olivier giovanelli



Ps : i am a pro user

#2


You can use method setNumberFormat() - set mask for formatting numeric data. Works only for the “end” or “ron” columns. Method has parameters:


setNumberFormat(mask, cInd, p_sep, d_sep)


mask - numeric mask; for example 0,000.00 - 1,234.56


cInd - column index


p_sep - char used as decimal part separator (point by default)


d_sep - char used as groups separator (comma by default)


So in your case method should looks like that:


mygrid.setNumberFormat(“0,000”,INDEX);


where INDEX - index of a necessary column.

#3

yes but how can i tell this method that (for example) the 2nd column is an integer without any decimal ?

#4


Code will looks like that:


mygrid.setNumberFormat(“0,000”,1);

#5

Well it doesn’t work

Take a look , i just took a screenshot

the last column … i have lots of number after the .

and i don’t know why because all the number are xxx.xx

my code :
mygrid = new dhtmlXGridObject(‘gridbox’);
mygrid.setHeader(<?php echo utf8_encode('"Réseau / programme,Affichages,Clics,Ventes,#cspan,#cspan,Formulaires,#cspan,#cspan,Gains totaux en €,#cspan,#cspan,e-cpm,e-cpc",null,["text-align:center;    vertical-align:middle;","text-align:center;vertical-align:middle;","text-align:center;vertical-align:middle","text-align:center","text-align:center","text-align:center","text-align:center;    vertical-align:middle;","text-align:center;    vertical-align:middle;"')?>]);
mygrid.attachHeader(<?php echo utf8_encode('"#rspan,#rspan,#rspan,acceptées,refusées,attentes,acceptés,refusés,attentes,acceptés,refusés,attentes,#rspan,#rspan",["text-align:center","text-align:center","text-align:center","text-align:center","text-align:center","text-align:center","text-align:center","text-align:center","text-align:center","text-align:center","text-align:center","text-align:center"')?>]);
mygrid.setInitWidths(“160,80,70,70,60,60,65,60,60,65,60,60,60,60”);
mygrid.setColAlign(“left,right,right,center,center,center,center,center,center”)
mygrid.enableAlterCss(“even”,“uneven”);
mygrid.enableRowsHover(true,‘cellselected’)
mygrid.setMathRound(2);
mygrid.setColTypes(“tree,ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=(c9+c10+c11)/c1*1000]],ed[=(c9+c10+c11)/c2]]”);   
mygrid.setNumberFormat(“0,000”,3);
mygrid.init();

mygrid.setSkin(“modern”);
mygrid.enableSmartXMLParsing(false);
mygrid.loadXML(“data…xml”);

As you can see , the 3rd column still have 398.00 instead of 398.

How can i do ?




snapshot.jpg863×435 124 KB

#6


>>You can use method setNumberFormat() - set mask for formatting numeric data. Works only for the “end” or “ron” columns


Your 3rd column should has “edn” type:


mygrid.setColTypes(“tree,ed[=sum],ed[=sum],edn[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=sum],ed[=(c9+c10+c11)/c1*1000]],ed[=(c9+c10+c11)/c2]]”);

#7

Thank you very much :slight_smile: work great !