Error Type Configuration: Incorrect Cell Type

Suite and Optimus Suite 5
#1

We are experimenting with the free version, to buy eventually a pro version.



When loading the grid with these data, we are getting the JavaScript error “Error Type Configuration: Incorrect Cell Type” on loading the xml:





<?xml version="1.0" encoding="UTF-8"?><![CDATA[

AML10100
]]><![CDATA[
30.11.2007
]]><![CDATA[
727050
]]><![CDATA[
0
]]><![CDATA[
736.000
]]><![CDATA[
0.00000
]]><![CDATA[
736.000
]]><![CDATA[
0.00000
]]><![CDATA[
AML1030
]]><![CDATA[
30.11.2007
]]><![CDATA[
716060
]]><![CDATA[
0
]]><![CDATA[
227.000
]]><![CDATA[
0.00000
]]><![CDATA[
227.000
]]><![CDATA[
0.00000
]]><![CDATA[
AML1050
]]><![CDATA[
30.11.2007
]]><![CDATA[
716060
]]><![CDATA[
0
]]><![CDATA[
868.000
]]><![CDATA[
0.00000
]]><![CDATA[
868.000
]]><![CDATA[
0.00000
]]><![CDATA[
AML5100
]]><![CDATA[
30.11.2007
]]><![CDATA[
723110
]]><![CDATA[
0
]]><![CDATA[
1128.000
]]><![CDATA[
0.00000
]]><![CDATA[
1128.000
]]><![CDATA[
0.00000
]]><![CDATA[
AML530
]]><![CDATA[
30.11.2007
]]><![CDATA[
726050
]]><![CDATA[
0
]]><![CDATA[
2112.000
]]><![CDATA[
0.00000
]]><![CDATA[
2112.000
]]><![CDATA[
0.00000
]]><![CDATA[
AML550
]]><![CDATA[
30.11.2007
]]><![CDATA[
726050
]]><![CDATA[
0
]]><![CDATA[
908.000
]]><![CDATA[
0.00000
]]><![CDATA[
908.000
]]><![CDATA[
0.00000
]]><![CDATA[
ARL100
]]><![CDATA[
30.11.2007
]]><![CDATA[
710090
]]><![CDATA[
0
]]><![CDATA[
5996.000
]]><![CDATA[
0.00000
]]><![CDATA[
5996.000
]]><![CDATA[
0.00000
]]><![CDATA[
ARL100K
]]><![CDATA[
30.11.2007
]]><![CDATA[
706090
]]><![CDATA[
0
]]><![CDATA[
39.000
]]><![CDATA[
0.00000
]]><![CDATA[
39.000
]]><![CDATA[
0.00000
]]><![CDATA[
ARL20
]]><![CDATA[
30.11.2007
]]><![CDATA[
711090
]]><![CDATA[
0
]]><![CDATA[
6547.000
]]><![CDATA[
0.00000
]]><![CDATA[
6547.000
]]><![CDATA[
0.00000
]]><![CDATA[
ARL50
]]><![CDATA[
30.11.2007
]]><![CDATA[
703110
]]><![CDATA[
0
]]><![CDATA[
13191.000
]]><![CDATA[
0.00000
]]><![CDATA[
13191.000
]]><![CDATA[
0.00000
]]>



Inititialization of Grid:



    

    

    

    

    


    

    
#2


Such issue occurs because of cell types in your grid is not defined. To define cell type you should use method setColTypes() method or “type” attribute of the tag:


grid.setColTypes(“ro,ed,txt,txt,ro,co”);


or


List of all availibe cell types you can find here dhtmlx.com/docs/products/dhtmlxG … cellstypes

#3

Excellent… I was the same error. I only set the attribute type at column in my XML and this works wonderfully.

Thanks.

#4

Hello,

I’m using dhtmlxgrid data from mysql database.
the grid is places into layout and i’m getting same error although the grid.setColTypes is set.

files included in the header are:
dhtmlx.js
connector.js
dhtmlxdataprocessor.js

theme: dhx_skyblue

// reportGrid setup
	reportGrid = layout.cells("b").attachGrid()
	reportGrid.setHeader("Date, Admin, Total In, Expenses, Goods, Balance, Extra/Shorts") // 7 columns
	reportGrid.setInitWidths("100,150,100,100,100,100,*")
	reportGrid.setColAlign("left,left,right,right,right,right,right")
	reportGrid.setColTypes("ro,ro,ro,ro,ro,ro[=c3-c4],ro")
  //reportGrid.setColSorting("date,str,int,int,int,int,int");
	reportGrid.attachHeader('#rspan,#select_filter,#numeric_filter,#numeric_filter,#numeric_filter,#numeric_filter,#numeric_filter')	
	reportGrid.init()	
	reportGrid.load("elements/parts/connector.php")
#5

Please, try to add dhtmlxgrid_math.js extension to your page: