Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Jennifer on Oct 02, 2008 07:10
open dhtmlx forum
dhtmlxgrid: #SCL math error? Javascript _cellType errors?

I was working with my dhtmlxgrid (professional edition) and was fixing some bugs, and another one randomly came up ..

mygrid3.setCellExcellType (rowSplit[j], 13, 'math');
mygrid3.cells (rowSplit[j], 13).setValue ("=c1+c2+c3+c4+c5+c6+c7+c8+c9+c10+c11+c12");

is my code, and was working fine all along, but now the totals column (13) displays #SCL and I get a javascript error that says
"'_cellType' is null or not an object" and when I try to debug it, it breaks on this point:

cells4:function(cell){var type = window["eXcell_"+(cell._cellType||this.cellType[cell._cellIndex])];if (type)return new type(cell)},
in dhtmlxgrid.js

Help? Not quite sure where to go from here!!
Answer posted by Support on Oct 02, 2008 09:06
Be sure that dhtmlxgrid_math.js file is included, similar error may occurs when grid encounters unknown column type. 
The second possible reason of problem - incorrect math formula. According to your code grid must have at least 13 columns on moment of formula calculation. 
( the error during incorrect math calculation catched by try|catch code, so it not detectable, unless you are using firebug, which detects errors in try|catch blocks as well )