Is it possible to set a cell Class and colspan in aaData?

Akhor

Hi,

I have a table that's being generated via the an aaData array. Based on the data, I would sometimes like to change the cells css and sometimes add a column span.

What is the best way auto generate a table row like below

[code]DataSPECIALData2
Data ColspanData2
DataSPECIALData2[/code]


I may be wrong, but aaData seems to only take the "column values" as input.
[code]
"aaData": [
/* Reduced data set */
[ "Trident", "Internet Explorer 4.0", "Win 95+" ],
[ "Trident", "Internet Explorer 5.0", "Win 95+" ]
[/code]

allan

No it isn't. Also colspan / rowspan is not supported in the TBODY in DataTables.

You would need to use fnCreatedCell or some other callback to modify the css based on the data.

Allan

Akhor

Thanks for the information. I ended up getting it to work by

1) using fnCreatedCell to assign the appropriate CSS
2) usign fnCreatedRow to manipluate the row DOM to hide a the columns.



Below test code will randomly assign a background color to any column with the value "R".

[code]
"fnCreatedCell": function(nTD,sData,oData,iRow,iCol){
if (sData == "R"){
$(nTD).css('background-color', 'red');
if (Math.floor( (Math.random()*10+1)) == 2 ){
$(nTD).attr('colSpan',2);
}
}
}
[/code]



Below test code will hide 1 column if the colspan is 2 or more.

[code]
"fnCreatedRow": function( nRow, aData, iDataIndex){


// Check each cell for a column span attribute
// If there is one that is greater then 1 then
// hide the following columns so that the table
// does not expand.
$(nRow).find('[colSpan]').each( function(index,element){

for( i = 1; parseInt( $(element).attr('colSpan') ) > i ; i++ ){

//Hide the next elements that are part of the
//column span
var nextIndex = $(element).index() + i;
$(nRow).find("td:eq("+ nextIndex +")").hide();

}
});
}
[/code]