Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by chad on Nov 17, 2008 11:47
open dhtmlx forum
frozen columns. frozen col not showing any data

I've got a frozen col where the data in that col does not show. there are no cells actually. i am loading the columns, footers and rows with an xml file my code is as follows:

grid = new dhtmlXGridObject("grid");
grid.setImagePath("dhtmlx/imgs/");
grid.setEditable(true);
grid.setSkin("modern");

grid.enableEditEvents(true, false, false);

grid.init();

grid.enableSmartRendering(true);
grid.enableMultiselect(true);

var URL = "getGrid.xml";

grid.loadXML(URL,function(){
grid.splitAt(1);
});


if i put the splitAt(1) call between init() and loadXML the column disappears completely.
Answer posted by Support on Nov 18, 2008 02:25
According to the code snippet, you are initializing grid from XML config - in such case splitAt must be executed from XML as well. 
http://dhtmlx.com/docs/products/dhtmlxGrid/doc/articles/Common_Problems_in_Grid.html#grid_art_comprob
Answer posted by chad on Nov 18, 2008 08:59
i've now added the xml splitAt call so the xml head looks like this:

<head>
  <column width="200" type="link" align="left" sort="server" id="Product Category" format="" hidden="false">Product Category</column>
  <column width="200" type="link" align="left" sort="server" id="# Products" format="" hidden="false"># Products</column>
  <column width="100" type="ron" align="right" sort="server" id="# Cases Sold" format="0,000.00" hidden="false"># Cases Sold</column>
  <column width="100" type="ron" align="right" sort="server" id="Sales$" format="$0,000.00" hidden="false">Sales$</column>
  <column width="100" type="ron" align="right" sort="server" id="COGS$" format="$0,000.00" hidden="false">COGS$</column>
  <column width="100" type="ron" align="right" sort="server" id="GP$" format="$0,000.00" hidden="false">GP$</column>
  <column width="100" type="ron" align="right" sort="server" id="GP % of Sales" format="0,000.00%" hidden="false">GP % of Sales</column>
  <column width="100" type="ron" align="right" sort="server" id="Earned Income$" format="$0,000.00" hidden="false">Earned Income$</column>
  <column width="100" type="ron" align="right" sort="server" id="Adj. GP$" format="$0,000.00" hidden="false">Adj. GP$</column>
  <column width="100" type="ron" align="right" sort="server" id="Adj. GP % of Sales" format="0,000.00%" hidden="false">Adj. GP % of Sales</column>
  <column width="100" type="ron" align="right" sort="server" id="Adj. GP % of Total" format="0,000.00%" hidden="false">Adj. GP % of Total</column>
- <afterInit>
- <call command="attachFooter">
  <param>,6\,971.00,835\,966.26,$25\,973\,795.33,$21\,453\,777.83,$4\,520\,017.50,17.40%,$292\,585.10,$4\,812\,602.60,18.53%,100.00%</param>
  <param>text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right</param>
  </call>
  </afterInit>
- <afterInit>
- <call command="splitAt">
  <param>1</param>
  </call>
  </afterInit>
  </head>


But now the first column is gone, it just doesnt appear at all.  any other ideas?

Answer posted by chad on Nov 18, 2008 09:08
excuse me that was wrong.  it looks like this:

<head>
  <column width="200" type="link" align="left" sort="server" id="Product Category" format="" hidden="false">Product Category</column>
  <column width="200" type="link" align="left" sort="server" id="# Products" format="" hidden="false"># Products</column>
  <column width="100" type="ron" align="right" sort="server" id="# Cases Sold" format="0,000.00" hidden="false"># Cases Sold</column>
  <column width="100" type="ron" align="right" sort="server" id="Sales$" format="$0,000.00" hidden="false">Sales$</column>
  <column width="100" type="ron" align="right" sort="server" id="COGS$" format="$0,000.00" hidden="false">COGS$</column>
  <column width="100" type="ron" align="right" sort="server" id="GP$" format="$0,000.00" hidden="false">GP$</column>
  <column width="100" type="ron" align="right" sort="server" id="GP % of Sales" format="0,000.00%" hidden="false">GP % of Sales</column>
  <column width="100" type="ron" align="right" sort="server" id="Earned Income$" format="$0,000.00" hidden="false">Earned Income$</column>
  <column width="100" type="ron" align="right" sort="server" id="Adj. GP$" format="$0,000.00" hidden="false">Adj. GP$</column>
  <column width="100" type="ron" align="right" sort="server" id="Adj. GP % of Sales" format="0,000.00%" hidden="false">Adj. GP % of Sales</column>
  <column width="100" type="ron" align="right" sort="server" id="Adj. GP % of Total" format="0,000.00%" hidden="false">Adj. GP % of Total</column>
- <afterInit>
-   <call command="attachFooter">
    <param>,6\,971.00,835\,966.26,$25\,973\,795.33,$21\,453\,777.83,$4\,520\,017.50,17.40%,$292\,585.10,$4\,812\,602.60,18.53%,100.00%</param>
    <param>text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right</param>
</call>
<call command="splitAt">
<param>1</param>
</call>
</afterInit>
</head>
Answer posted by Support on Nov 18, 2008 09:22
Sample with same XML works correctly in local test. 
Full example sent by email.