TableTools Copy not copying all rows using TableScroller and bdeferRender

sruimveld

I am using Jquery-1.9.1.js, TableTools 2.2.0 and Scroller 1.2.0.

I have a table which is generated on the Client after reading a large CSV file on the server.
The table has 19,000 rows.

Here is the initialization of the table:

var oTable = $('#lots').dataTable({
"aaData":[
<?php
echo setup::aaDataSerializeArray(setup::$summary_lot_data);
?>
],
"aoColumns":[
<?php
echo setup::aoColumnsSerializeArray(setup::$summary_lot_head);
?>
],
"aaSorting": [[0,'desc'], [1,'desc'],[3,'desc']],
"sScrollY": "500px",
"sDom": 'T<"clear"><"H"fr>tS<"F"i><"clear">',
"bJQueryUI": true,
"bDeferRender": true,
"oTableTools": {
"sSwfPath": "swf/copy_csv_xls.swf",
"aButtons": [
"copy",
{
"sExtends": "collection",
"sButtonText": "Save",
"aButtons": [ "csv", "xls" ]
}
]
}
}).fnFilterOnReturn();



The php code will read the file on the server and load it into the browser memory and create the data for aaData and aaColumns.

I set the scrolling and table tool options in the sDom parameter.
I set the bDeferRender option to true for faster scrolling.

The table displays as expected with only a portion of the table visible in the 500px window set by the sScrolly parameter.
I can scroll through the data, though slowly as there are 19000 rows and about 100 columns.

But the problem comes when I click on the Copy button or the Save->CSV button.
Only a small portion of the data gets copied to the Click board or CSV file (like 200 rows).

There was a post about this in 2011 that was closed and it seemed that they implied that this would work fine as long as bServerside processing was turned off.

Can someone help explain my problem here?

Thanks,

Steve