Export/Print Hidden Column with 1.1.4
Export/Print Hidden Column with 1.1.4
Markc
Posts: 1Questions: 0Answers: 0
Hello,
First off, Great script. I am attempting to export to excel a table with a number of hidden columns, but I cannot get the hidden columns to export. I am able to hide the columns just fine using [code]"aoColumns": [
/* Team */ null,
/* Members */ null,
/* Projects */ {"bVisible": false },
/* Files */ null,
/* Action */ null
][/code]
and with [code]oTable.fnSetColumnVis( 2, true );[/code], but the exported data either returns everything except for the hidden column, or the last attempt only returns a single row. I read a post about removing an if statement containing _DTSettings.aoColumns[i].bVisible , which i did from 632, and 652 of 1.14, but that didn't solve the issue.. I also noticed the fix was for an earlier version. If anyone has a solution to exporting a table with with hidden columns included, it would be a big help..
Thanks, Mark
First off, Great script. I am attempting to export to excel a table with a number of hidden columns, but I cannot get the hidden columns to export. I am able to hide the columns just fine using [code]"aoColumns": [
/* Team */ null,
/* Members */ null,
/* Projects */ {"bVisible": false },
/* Files */ null,
/* Action */ null
][/code]
and with [code]oTable.fnSetColumnVis( 2, true );[/code], but the exported data either returns everything except for the hidden column, or the last attempt only returns a single row. I read a post about removing an if statement containing _DTSettings.aoColumns[i].bVisible , which i did from 632, and 652 of 1.14, but that didn't solve the issue.. I also noticed the fix was for an earlier version. If anyone has a solution to exporting a table with with hidden columns included, it would be a big help..
Thanks, Mark
This discussion has been closed.