Unable to math and use formula in cell after export to excel


#1

Hello .
when I export to excel by TreeGrid. After export Excel is enable to edit in table but unable to formula,calculate

example this image . when sum in cell result = 0

mygrid = new dhtmlXGridObject(‘gridbox’);
mygrid.gN=true;
mygrid.setImagePath(‘dhtmlxTreeGrid/codebase/imgs/csh_bluebooks/’);
mygrid.setHeader(header);
mygrid.setInitWidths(width);
mygrid.setColAlign(aling);
mygrid.setColTypes( mode);
mygrid.setColSorting( type);
mygrid.enableRowsHover(true,‘hover’);
mygrid.init();
mygrid.setSkin(“xp”);
mygrid.setStyle(" color:#333366; font-weight:bold;", “”,“color:white;”, “”);
mygrid.attachEvent(“onKeyPress”,onKeyPressed);
mygrid.attachEvent(“onBeforeSelect”,function(){ return false; });
mygrid.enableMathSerialization(ture);
mygrid.enableBlockSelection(true);
mygrid.enableAlterCss(“even”,“uneven”);

Thank you.


#2

Unfortunately the issue cannot be reproduced locally.
If the problem still occurs for you, please, provide with a complete demo or any kind of sample of your code, so the issue can be reproduced locally.


#3

Set column type like that

myGrid.setColTypes(‘ro,ro,edn,edn,edn,edn,edn,edn,edn,edn’);

“edn” Type will be accept number and Symbols