fnCellRender option not working

jsidhu

I am using "sAjaxSource" to render the data from the server. I have few columns. One of the column also renders two links which are dropdown toggle.
ex:
"aoColumns": [
{
'sName':'ID' ,
'mDataProp': 'SYS_ID',
'sTitle': 'C Sys ID',
'bSortable': true,
'aDataSort': true,
'bVisible': true,
'bSortable': false,
'sWidth': "60px",
'sType': 'html',
'mRender': function(data,type,full){
return ""+data +"ViewEdit";
//""+data+"";
},




When I use the TableTools as:
sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "/assets/plugins/tables/dataTables/swf/copy_csv_xls_pdf.swf",
"aButtons": [
{
"sExtends": "collection",
"sButtonText": 'Save Data on screen ',
"aButtons": [ "csv", "xls", "pdf" ],
}



the exported csv/pdf file prints the above column as "value+ViewEdit" for ex:"data123ViewEdit" for that particular column.

How can I get rid off "ViewEdit" in that column in csv/pdf.

I tried using "fnCellRender" but didnt helped.

Can anyone plz help me with that?

tangerine

It may be your mRender function "return" value. Check your use of quotes,

jsidhu

thx for the response.

yes it is coz of the mRender function. So my question is how can I hide that :viewEdit" from mRender function in the exported csv/excel/pdf?

Please help!!

allan

You'd need to modify TableTools since it uses the display value for the export.

Allan

jsidhu

Can you please help me what needs to be modify in the tabletools?

jsidhu

I figured out that fnCellRender doenot works if the button type is of type "collection". Can anyone help me with the workaround to edit the column values with the "collection" button type.

please help!! its urgent

jsidhu

i figured it out!!

thx!!