Multiple headers when performing XML initialisation

Suite and Optimus Suite 5
#1

I am dynamically creating the configuration for my grid in xml, so we create a set of columns in the tag.

<column type="edn" width="7.5" sort="na" align="left" >P01 2010/11</column> <column type="edn" width="7.5" sort="na" align="left" >P01 2010/11</column> <column type="edn" width="7.5" sort="na" align="left" >P02 2010/11</column> <column type="edn" width="7.5" sort="na" align="left" >P02 2010/11</column>
I can then use the attachHeader technique to add a second header row

<afterInit> <call command="attachHeader"> <param> Plan , Actual , Plan , Actual </param> </call> </afterInit>
We would like to have the ‘P01’ headers span the Plan and Actual headers, but how can I tell the grid I need 4 columns (in this case) if I use the #cspan on the first row of headers inside the xml?

#2

You can safely add #cspan in your header. The grid will treat it like two separate columns.
For example:

<column type="edn" width="7.5" sort="na" align="left" >P01 2010/11</column> <column type="edn" width="7.5" sort="na" align="left" >#cspan</column> <column type="edn" width="7.5" sort="na" align="left" >P02 2010/11</column> <column type="edn" width="7.5" sort="na" align="left" >#cspan</column>
…

<afterInit> <call command="attachHeader"> <param>Plan ,Actual ,Plan ,Actual</param></call> </afterInit>
…

<row id="1001"> <cell>100</cell> <cell>80</cell> <cell>12.99</cell> <cell>13.5</cell> </row> <row id="1002"> <cell>1000</cell> <cell>1015</cell> <cell>0</cell> <cell>0</cell> </row>