Hi,
I have a grid and i user setNumberFormat on the 10th col like this :
etatDepensesGrid.setNumberFormat(“0,000”,9,“,”," ");
When I export the grid in excell, number like “8 000” are displayed (on excell) as 11
If I comment the setNumberFormat line i don’t have the problem.
Here is my full Grid Code :
if (etatDepensesGrid){
etatDepensesGrid.destructor();
}
etatDepensesGrid = new dhtmlXGridObject('etatDesDepenses_div');
etatDepensesGrid.setImagePath("/Common/Output/Javascript/dhtmlx_v3_pro/dhtmlxGrid/codebase/imgs/");
/* 1 2 3 4 5 6 7 8 9 10 11 12 */
etatDepensesGrid.setHeader("Immat., N° Carte, Agence/Service, Affectation, Date transaction, Jour transaction,Heure transaction, Lieu transaction, Nature, KMage saisi, Quantité de prise (L), Montant");
/* 1 2 3 4 5 6 7 8 9 10 11 12 */
etatDepensesGrid.setInitWidths("60,60,90,120,70,55,45,90,60,50,45,60");
etatDepensesGrid.setSkin("dhx_skyblue");
etatDepensesGrid.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ron,ron,ron");
etatDepensesGrid.setColAlign("left,left,left,left,left,left,left,left,left,right,right,right");
etatDepensesGrid.setColSorting("str,str,str,int,date,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int");
etatDepensesGrid.attachHeader("#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#select_filter,#text_filter,#text_filter,#select_filter,#numeric_filter,#numeric_filter,#numeric_filter");
etatDepensesGrid.enableRowsHover(true,"bv_hover");
etatDepensesGrid.init();
etatDepensesGrid.setNumberFormat("0,000",9,","," ");
etatDepensesGrid.setNumberFormat("0,000",10,","," ");
etatDepensesGrid.setNumberFormat("0,000.0",11,","," ");
etatDepensesGrid.loadXMLString(xmlString);
etatDepensesGrid.groupBy(0,["#title","#cspan","#cspan","#cspan","#cspan","#cspan","","","","","#stat_total","#stat_total"]);
etatDepensesGrid.sortRows(4,"date","asc");