Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Alex on Sep 09, 2008 07:51
open dhtmlx forum
Grid Problem

Hello

I have "dhtmlxGrid_pro_v16_80512" and i have a problem. My griid doesn´t mount totally. I have a partial grid mounted with javascript erros below: I got that problem when i put a lot of math cell inside grid (i have 56 rows with ten cells by row). Can you help me????

----FireFox error:

Erro: too much recursion
Arquivo-fonte: file:///C:/Documents%20and%20Settings/abc/Desktop/dhtmlxGrid/codebase/dhtmlxgridcell.js Line: 39

----Internet Explorer Error 7
window ALERT: "stack overflow at line: 15"


----My sources:

My JSP:

....
<link rel='STYLESHEET' type='text/css' href='../common/style.css'>
<link rel="STYLESHEET" type="text/css" href="../../codebase/dhtmlxgrid.css">
<link rel="STYLESHEET" type="text/css" href="../../codebase/dhtmlxgrid_skins.css">

<script src="../../codebase/dhtmlxcommon.js"></script>
<script src="../../codebase/dhtmlxgrid.js"></script>
<script src="../../codebase/dhtmlxgridcell.js"></script>

<script src="../../codebase/ext/dhtmlxgrid_nxml.js"></script>
<script src="../../codebase/ext/dhtmlxgrid_selection.js"></script>
<script src="../../codebase/ext/dhtmlxgrid_math.js"></script>
<script src="../../codebase/ext/dhtmlxgrid_keymap_excel.js"></script>
<script src="../../codebase/ext/dhtmlXGrid_srnd.js"></script>

<script>
var mygrid;

mygrid = new dhtmlXGridObject('mygrid_container');
mygrid.setImagePath("/scripts/componentes/imgs/");

mygrid.setSkin("gray");
mygrid.setMathRound(4);
mygrid.enableLightMouseNavigation(true);
mygrid.enableAlterCss("even","uneven")
mygrid.enableAutoHeigth(true,"1300");

mygrid.enableDistributedParsing(true,20);
mygrid.enableSmartRendering(true);

mygrid.init();
mygrid.clearAll();

//Local test
mygrid.loadXML("step44.xml");
    
</script>
...


My XML:

<?xml version="1.0" encoding="iso-8859-1"?>
<rows>
<head>
<column width="212" type="ro" align="left" sort="na">44444</column>
<column width="90" type="edn" align="center" sort="na" format="0,000.0000">11111111</column>
<column width="90" type="edn" align="center" sort="na" format="0,000.0000">#cspan</column>
<column width="90" type="edn" align="center" sort="na" format="0,000.0000">#cspan</column>
<column width="90" type="edn" align="center" sort="na" format="0,000.0000">222222222</column>
<column width="90" type="edn" align="center" sort="na" format="0,000.0000">#cspan</column>
<column width="90" type="edn" align="center" sort="na" format="0,000.0000">#cspan</column>
<column width="90" type="edn" align="center" sort="na" format="0,000.0000">3333333</column>
<column width="90" type="edn" align="center" sort="na" format="0,000.0000">#cspan</column>
<column width="90" type="edn" align="center" sort="na" format="0,000.0000">#cspan</column>
<afterInit>
<call command="attachHeader">
<param>#rspan,fgh/er,tes1/2434,fgh/wer,fgh/wer,tes1/234,fgh/wer,fgh/wer,tes1/234,fh/wer</param>
</call>
</afterInit>
</head>
<row locked="true" id="1" style="font-size:8pt; height:16px;">
<cell type="ro" class="blue">grp1</cell>
<cell type="ro" />
<cell type="ro" />
<cell type="ro" />
<cell type="ro" />
<cell type="ro" />
<cell type="ro" />
<cell type="ro" />
<cell type="ro" />
<cell type="ro" />
</row>
<row id="2" style="font-size:8pt; height:16px;">
<cell class="preto">test</cell>
<cell class="azul" type="math">=[[3,1]]*1000/60</cell>
<cell class="azul" type="math">=[[2,3]]/36.7454</cell>
<cell class="azul" type="math">=[[2,1]]/[[56,1]]</cell>
<cell class="azul" type="math">=[[2,6]]*[[56,1]]</cell>
<cell class="azul" type="math">=[[2,6]]/1.1023</cell>
<cell class="azul" type="math">=[[19,6]]-[[18,6]]-[[17,6]]-[[16,6]]-[[15,6]]-[[14,6]]-[[13,6]]-[[10,6]]-[[9,6]]-[[8,6]]-[[7,6]]-[[6,6]]-[[5,6]]-[[4,6]]</cell>
<cell class="azul" type="math">=[[2,9]]*[[56,1]]</cell>
<cell class="azul" type="math">=[[2,9]]/22.0462</cell>
<cell class="azul" type="math">=[[19,9]]-[[18,9]]-[[17,9]]-[[16,9]]-[[15,9]]-[[14,9]]-[[13,9]]-[[10,9]]-[[9,9]]-[[8,9]]-[[7,9]]-[[6,9]]-[[5,9]]-[[4,9]]</cell>
</row>
<row id="3" style="font-size:8pt; height:16px;">
<cell class="black">test</cell>
<cell class="green">39.99</cell>
<cell class="green">0</cell>
<cell class="blue" type="math">=[[3,1]]/[[56,1]]</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
</row>
<row id="4" style="font-size:8pt; height:16px;">
<cell class="black">test</cell>
<cell class="blue" type="math">=[[4,3]]*[[56,1]]</cell>
<cell class="green">0</cell>
<cell class="green">0.39</cell>
<cell class="blue" type="math">=[[4,6]]*[[56,1]]</cell>
<cell class="green">0</cell>
<cell class="green">0.39</cell>
<cell class="blue" type="math">=[[4,9]]*[[56,1]]</cell>
<cell class="green">0</cell>
<cell class="green">0.39</cell>
</row>
<row id="5" style="font-size:8pt; height:16px;">
<cell class="black">test</cell>
<cell class="blue" type="math">=[[5,3]]*[[56,1]]</cell>
<cell class="green">0</cell>
<cell class="green">80</cell>
<cell class="azul" type="math">=[[5,6]]*[[56,1]]</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="blue" type="math">=[[5,9]]*[[56,1]]</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
</row>
...
..until...
...
<row id="56" style="font-size:8pt; height:16px;">
<cell class="black">test</cell>
<cell class="green">1.7</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
<cell class="green">0</cell>
</row>
</rows>

Answer posted by Support on Sep 09, 2008 08:31
a) usage of distributed parsing and smart rendering in same time - has not sense, those are mutual exclusive modes ( enableDistributedParsing can be removed )
b) which version of grid you are using? versions before grid 1.6 not supported math operation in SRND mode. 


With version 1.6 and enableDistributedParsing removed all works correctly - sample sent by email.

Answer posted by Alex on Sep 09, 2008 09:36

I have dhtmlxGrid v.1.6 Professional edition build 80512.

I didn´t receive samples by email.

I removed enableDistributedParsing , but it doens´t work. Now the problem is:

Firefox:

Erro: this.grid._compileSCL is not a function
Arquivo-fonte: http://localhost:8080/myapplication/scripts/comp/ext/dhtmlxgrid_math.js    Line: 8

----------------------------------

line error: 

function eXcell_math(cell){if (cell){this.cell = cell;this.grid = this.cell.parentNode.grid};this.edit = function(){};this.isDisabled = function(){return true};this.setValue = function(val){val=this.grid._compileSCL(val,this.cell);if (this.grid._strangeParams[this.cell._cellIndex])this.grid.cells5(this.cell,this.grid._strangeParams[this.cell._cellIndex]).setValue(val);else

 

 

Answer posted by Support on Sep 09, 2008 10:18
If you still have not receive the working sample, please contact us directly at support@dhtmlx.com
Answer posted by Sergey on Apr 09, 2009 23:33
Hi from Ukraine!

I have the same error with this version of dhtmlxTreeGrid.
Something is wrong in dhtmlxgrid_math.js file or in interaction of this file functionality with other dhtmlx components.
The version of dhtmlxTreeGrid is 1.6 build 80512.

Answer posted by dhxSupport on Apr 10, 2009 03:24
This issue was fixed at the latest version of dhtmlxGrid. Please contact sales@dhtmlx.com to update your files.