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!!
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 )