Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Ashutosh Agarwal on Dec 03, 2007 09:01
open dhtmlx forum
Frozen Columns

Hi,
I am trying to implement frozen columns feature. I am using evaluation professional edition.

my xml is as follows:

<rows>
<head>
    <afterInit>
<call command="splitAt">
<param>2</param>
</call>
</afterInit>
    <column width="100" type="ed" align="right" color="white" sort="int">RestId</column>
    <column width="100" type="ed" align="right" color="white" sort="str">Rest Description</column>
    <column width="100" type="ed" align="right" color="white" sort="str">Eligible</column>
    <column width="100" type="ed" align="right" color="white" sort="str">Eligibility Date</column>
    <column width="100" type="co" align="left" color="white" sort="str">PMIX via poller
        <option value="Y">Y</option>
    <option value="N">N</option>
</column>
    <column width="100" type="co" align="right" color="white" sort="str">JDE DC
        <option value="Y">Y</option>
    <option value="N">N</option>
</column>
    <column width="100" type="co" align="right" color="white" sort="str">ROP Planner
        <option value="Robert Michalak">Robert Michalak</option>
    <option value="Eric Pfeiffer">Eric Pfeiffer</option>
    <option value="Bill Duross">Bill Duross</option>
    <option value="Nick Spurck">Nick Spurck</option>
    </column>
    <column width="100" type="ed" align="right" color="white" sort="date">Date of cashless receipts</column>
    <column width="100" type="ed" align="right" color="white" sort="str"># days PMIX hist</column>
    <column width="100" type="ed" align="right" color="white" sort="str">Date of some attribute</column>
    <column width="100" type="co" align="right" color="white" sort="str">Some Attr
        <option value="Y">Y</option>
    <option value="N">N</option>
</column>
    <column width="50" type="co" align="right" color="white" sort="str">Another Attribute
        <option value="Y">Y</option>
    <option value="N">N</option>
</column>
    <column width="50" type="co" align="right" color="white" sort="str">DC People
        <option value="Robert Michalak">Robert Michalak</option>
    <option value="Eric Pfeiffer">Eric Pfeiffer</option>
    <option value="Bill Duross">Bill Duross</option>
    <option value="Nick Spurck">Nick Spurck</option>
    </column>
    <column width="50" type="ed" align="right" color="white" sort="str">Some Date</column>
    <column width="50" type="ed" align="right" color="white" sort="str"># days receipts</column>
    <column width="50" type="ed" align="right" color="white" sort="str">Some Date</column>
    <column width="50" type="co" align="right" color="white" sort="str">Some Selection List
        <option value="Pre-determined">Pre-determined</option>
    <option value="Orthogonal">Orthogonal</option>
    <option value="Minimum">Minimum</option>
    <option value="Insufficient">Insufficient</option>
    </column>
    <column width="50" type="ch" align="center" color="white" sort="na">Is complete</column>
</head>
    <row id="100" style="">
        <cell>100</cell>
        <cell>CNR HEATHERTON & SPRINGVALE ROADS</cell>
        <cell>Y</cell>
        <cell>Sun Jan 01 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>09/16/2006</cell>
        <cell>30</cell>
        <cell>Sun Jul 02 00:00:00 IST 2006</cell>
        <cell>Y</cell>
        <cell>N</cell>
        <cell>Robert Michalak</cell>
        <cell>Wed Jun 14 00:00:00 IST 2006</cell>
        <cell>99</cell>
        <cell>Wed Jun 14 00:00:00 IST 2006</cell>
        <cell>Pre-determined</cell>
        <cell>true</cell>
    </row>

    <row id="101" style="">
        <cell>101</cell>
        <cell>123 MAIN ST & BUTTERFIELD ROAD</cell>
        <cell>Y</cell>
        <cell>Fri Dec 31 00:00:00 IST 2004</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>09/16/2006</cell>
        <cell>25</cell>
        <cell>Thu Aug 02 00:00:00 IST 2007</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>Wed Jun 20 00:00:00 IST 2007</cell>
        <cell>101</cell>
        <cell>Wed Jun 20 00:00:00 IST 2007</cell>
        <cell>Orthogonal</cell>
        <cell>false</cell>
    </row>

    <row id="102" style="">
        <cell>102</cell>
        <cell>OGDEN AVE & HOBSON ROAD</cell>
        <cell>N</cell>
        <cell></cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Bill Duross</cell>
        <cell>02/05/2004</cell>
        <cell>25</cell>
        <cell>Mon Mar 13 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Bill Duross</cell>
        <cell>Sat Mar 03 00:00:00 IST 2001</cell>
        <cell>33</cell>
        <cell>Sat Mar 03 00:00:00 IST 2001</cell>
        <cell>Minimum</cell>
        <cell>false</cell>
    </row>

    <row id="103" style="">
        <cell>103</cell>
        <cell>450 ROOSEVELT - LOMBARD</cell>
        <cell>N</cell>
        <cell></cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Nick Spurck</cell>
        <cell>03/17/2007</cell>
        <cell>30</cell>
        <cell>Mon Mar 13 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Nick Spurck</cell>
        <cell>Thu Dec 12 00:00:00 IST 2002</cell>
        <cell>23</cell>
        <cell>Thu Dec 12 00:00:00 IST 2002</cell>
        <cell>Insufficient</cell>
        <cell>true</cell>
    </row>

    <row id="104" style="">
        <cell>104</cell>
        <cell>409 ROOSEVELT - OAKBROOK TERRACE</cell>
        <cell>Y</cell>
        <cell>Tue Jul 04 00:00:00 IST 1995</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>04/01/1996</cell>
        <cell>2</cell>
        <cell>Wed Oct 10 00:00:00 IST 2007</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>Tue Dec 23 00:00:00 IST 2003</cell>
        <cell>0</cell>
        <cell>Tue Dec 23 00:00:00 IST 2003</cell>
        <cell>Pre-determined</cell>
        <cell>false</cell>
    </row>

    <row id="105" style="">
        <cell>105</cell>
        <cell>CNR HEATHERTON & SPRINGVALE ROADS</cell>
        <cell>Y</cell>
        <cell>Sun Jan 01 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>09/16/2006</cell>
        <cell>30</cell>
        <cell>Sun Jul 02 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>Wed Jun 14 00:00:00 IST 2006</cell>
        <cell>99</cell>
        <cell>Wed Jun 14 00:00:00 IST 2006</cell>
        <cell>Orthogonal</cell>
        <cell>true</cell>
    </row>

    <row id="106" style="">
        <cell>106</cell>
        <cell>123 MAIN ST & BUTTERFIELD ROAD</cell>
        <cell>Y</cell>
        <cell>Fri Dec 31 00:00:00 IST 2004</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Bill Duross</cell>
        <cell>09/16/2006</cell>
        <cell>25</cell>
        <cell>Thu Aug 02 00:00:00 IST 2007</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Bill Duross</cell>
        <cell>Wed Jun 20 00:00:00 IST 2007</cell>
        <cell>101</cell>
        <cell>Wed Jun 20 00:00:00 IST 2007</cell>
        <cell>Minimum</cell>
        <cell>false</cell>
    </row>

    <row id="107" style="">
        <cell>107</cell>
        <cell>OGDEN AVE & HOBSON ROAD</cell>
        <cell>N</cell>
        <cell></cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Nick Spurck</cell>
        <cell>02/05/2004</cell>
        <cell>25</cell>
        <cell>Mon Mar 13 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Nick Spurck</cell>
        <cell>Sat Mar 03 00:00:00 IST 2001</cell>
        <cell>33</cell>
        <cell>Sat Mar 03 00:00:00 IST 2001</cell>
        <cell>Insufficient</cell>
        <cell>true</cell>
    </row>

    <row id="108" style="">
        <cell>108</cell>
        <cell>450 ROOSEVELT - LOMBARD</cell>
        <cell>N</cell>
        <cell></cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>03/17/2007</cell>
        <cell>30</cell>
        <cell>Mon Mar 13 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>Thu Dec 12 00:00:00 IST 2002</cell>
        <cell>23</cell>
        <cell>Thu Dec 12 00:00:00 IST 2002</cell>
        <cell>Pre-determined</cell>
        <cell>false</cell>
    </row>

    <row id="109" style="">
        <cell>109</cell>
        <cell>409 ROOSEVELT - OAKBROOK TERRACE</cell>
        <cell>Y</cell>
        <cell>Tue Jul 04 00:00:00 IST 1995</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>04/01/1996</cell>
        <cell>2</cell>
        <cell>Wed Oct 10 00:00:00 IST 2007</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>Tue Dec 23 00:00:00 IST 2003</cell>
        <cell>0</cell>
        <cell>Tue Dec 23 00:00:00 IST 2003</cell>
        <cell>Orthogonal</cell>
        <cell>true</cell>
    </row>

    <row id="200" style="">
        <cell>200</cell>
        <cell>CNR HEATHERTON & SPRINGVALE ROADS</cell>
        <cell>Y</cell>
        <cell>Sun Jan 01 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>09/16/2006</cell>
        <cell>30</cell>
        <cell>Sun Jul 02 00:00:00 IST 2006</cell>
        <cell>Y</cell>
        <cell>N</cell>
        <cell>Robert Michalak</cell>
        <cell>Wed Jun 14 00:00:00 IST 2006</cell>
        <cell>99</cell>
        <cell>Wed Jun 14 00:00:00 IST 2006</cell>
        <cell>Pre-determined</cell>
        <cell>true</cell>
    </row>

    <row id="201" style="">
        <cell>201</cell>
        <cell>123 MAIN ST & BUTTERFIELD ROAD</cell>
        <cell>Y</cell>
        <cell>Fri Dec 31 00:00:00 IST 2004</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>09/16/2006</cell>
        <cell>25</cell>
        <cell>Thu Aug 02 00:00:00 IST 2007</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>Wed Jun 20 00:00:00 IST 2007</cell>
        <cell>101</cell>
        <cell>Wed Jun 20 00:00:00 IST 2007</cell>
        <cell>Orthogonal</cell>
        <cell>false</cell>
    </row>

    <row id="202" style="">
        <cell>202</cell>
        <cell>OGDEN AVE & HOBSON ROAD</cell>
        <cell>N</cell>
        <cell></cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Bill Duross</cell>
        <cell>02/05/2004</cell>
        <cell>25</cell>
        <cell>Mon Mar 13 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Bill Duross</cell>
        <cell>Sat Mar 03 00:00:00 IST 2001</cell>
        <cell>33</cell>
        <cell>Sat Mar 03 00:00:00 IST 2001</cell>
        <cell>Minimum</cell>
        <cell>false</cell>
    </row>

    <row id="203" style="">
        <cell>203</cell>
        <cell>450 ROOSEVELT - LOMBARD</cell>
        <cell>N</cell>
        <cell></cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Nick Spurck</cell>
        <cell>03/17/2007</cell>
        <cell>30</cell>
        <cell>Mon Mar 13 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Nick Spurck</cell>
        <cell>Thu Dec 12 00:00:00 IST 2002</cell>
        <cell>23</cell>
        <cell>Thu Dec 12 00:00:00 IST 2002</cell>
        <cell>Insufficient</cell>
        <cell>true</cell>
    </row>

    <row id="204" style="">
        <cell>204</cell>
        <cell>409 ROOSEVELT - OAKBROOK TERRACE</cell>
        <cell>Y</cell>
        <cell>Tue Jul 04 00:00:00 IST 1995</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>04/01/1996</cell>
        <cell>2</cell>
        <cell>Wed Oct 10 00:00:00 IST 2007</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>Tue Dec 23 00:00:00 IST 2003</cell>
        <cell>0</cell>
        <cell>Tue Dec 23 00:00:00 IST 2003</cell>
        <cell>Pre-determined</cell>
        <cell>false</cell>
    </row>

    <row id="205" style="">
        <cell>205</cell>
        <cell>CNR HEATHERTON & SPRINGVALE ROADS</cell>
        <cell>Y</cell>
        <cell>Sun Jan 01 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>09/16/2006</cell>
        <cell>30</cell>
        <cell>Sun Jul 02 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>Wed Jun 14 00:00:00 IST 2006</cell>
        <cell>99</cell>
        <cell>Wed Jun 14 00:00:00 IST 2006</cell>
        <cell>Orthogonal</cell>
        <cell>true</cell>
    </row>

    <row id="206" style="">
        <cell>206</cell>
        <cell>123 MAIN ST & BUTTERFIELD ROAD</cell>
        <cell>Y</cell>
        <cell>Fri Dec 31 00:00:00 IST 2004</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Bill Duross</cell>
        <cell>09/16/2006</cell>
        <cell>25</cell>
        <cell>Thu Aug 02 00:00:00 IST 2007</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Bill Duross</cell>
        <cell>Wed Jun 20 00:00:00 IST 2007</cell>
        <cell>101</cell>
        <cell>Wed Jun 20 00:00:00 IST 2007</cell>
        <cell>Minimum</cell>
        <cell>false</cell>
    </row>

    <row id="207" style="">
        <cell>207</cell>
        <cell>OGDEN AVE & HOBSON ROAD</cell>
        <cell>N</cell>
        <cell></cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Nick Spurck</cell>
        <cell>02/05/2004</cell>
        <cell>25</cell>
        <cell>Mon Mar 13 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Nick Spurck</cell>
        <cell>Sat Mar 03 00:00:00 IST 2001</cell>
        <cell>33</cell>
        <cell>Sat Mar 03 00:00:00 IST 2001</cell>
        <cell>Insufficient</cell>
        <cell>true</cell>
    </row>

    <row id="208" style="">
        <cell>208</cell>
        <cell>450 ROOSEVELT - LOMBARD</cell>
        <cell>N</cell>
        <cell></cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>03/17/2007</cell>
        <cell>30</cell>
        <cell>Mon Mar 13 00:00:00 IST 2006</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Robert Michalak</cell>
        <cell>Thu Dec 12 00:00:00 IST 2002</cell>
        <cell>23</cell>
        <cell>Thu Dec 12 00:00:00 IST 2002</cell>
        <cell>Pre-determined</cell>
        <cell>false</cell>
    </row>

    <row id="209" style="">
        <cell>209</cell>
        <cell>409 ROOSEVELT - OAKBROOK TERRACE</cell>
        <cell>Y</cell>
        <cell>Tue Jul 04 00:00:00 IST 1995</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>04/01/1996</cell>
        <cell>2</cell>
        <cell>Wed Oct 10 00:00:00 IST 2007</cell>
        <cell>N</cell>
        <cell>Y</cell>
        <cell>Eric Pfeiffer</cell>
        <cell>Tue Dec 23 00:00:00 IST 2003</cell>
        <cell>0</cell>
        <cell>Tue Dec 23 00:00:00 IST 2003</cell>
        <cell>Orthogonal</cell>
        <cell>true</cell>
    </row>

</rows>

In firefox error console I am getting this error

pa.style has no properties.
dhtmlxgrid_splt.js line 9.

Regards,
Ashutosh Agarwal.
Answer posted on Dec 04, 2007 02:51
The XML which you provides works correctly for me ( please contact at support@dhtmlx.com if you need a working sample )
The error which you describe can be caused by using not empty container tag for grid, please be sure that container in which grid initialized has not other content.