Exporting one hidden column and visible columns but not all columns to Pdf .. overwriting
Exporting one hidden column and visible columns but not all columns to Pdf .. overwriting
pluginfan
Posts: 6Questions: 0Answers: 0
I am trying to export one of the hidden columns and all the visible columns to PDF.
It is overwriting the hidden column over an visible column and header is off too.
has any one else had this issue.
All other exports work fine.
[code]
$(document).ready(function () {
$('#list').dataTable({
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "swf/copy_cvs_xls_pdf.swf" , // setting path for swf file. Displays export buttons
"aButtons": [
{
"sExtends": "copy",
"mColumns": [0, 1, 2, 3, 4,5] // Export settings for Copy to Clipboard
},
{
"sExtends": "csv",
"mColumns": [0, 1, 2, 3, 4,5] // Export settings for CSV file
},
{
"sExtends": "xls",
"mColumns": [0, 1, 2, 3, 4,5] // Export settings for Excel file
},
{
"sExtends": "pdf",
"mColumns": [0, 1, 2, 3, 4,5], // Export settings for PDF file
"sPdfOrientation": "landscape"
}
],
},
"aaSorting": [[0,'asc']], // setting default sort on first column
"aoColumns" : [ null,
{"bVisible": false}, // hide column
null,
null,
null,
null,
null,
null,
null
]
});
});
[/code]
It is overwriting the hidden column over an visible column and header is off too.
has any one else had this issue.
All other exports work fine.
[code]
$(document).ready(function () {
$('#list').dataTable({
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "swf/copy_cvs_xls_pdf.swf" , // setting path for swf file. Displays export buttons
"aButtons": [
{
"sExtends": "copy",
"mColumns": [0, 1, 2, 3, 4,5] // Export settings for Copy to Clipboard
},
{
"sExtends": "csv",
"mColumns": [0, 1, 2, 3, 4,5] // Export settings for CSV file
},
{
"sExtends": "xls",
"mColumns": [0, 1, 2, 3, 4,5] // Export settings for Excel file
},
{
"sExtends": "pdf",
"mColumns": [0, 1, 2, 3, 4,5], // Export settings for PDF file
"sPdfOrientation": "landscape"
}
],
},
"aaSorting": [[0,'asc']], // setting default sort on first column
"aoColumns" : [ null,
{"bVisible": false}, // hide column
null,
null,
null,
null,
null,
null,
null
]
});
});
[/code]
This discussion has been closed.