Hi Robert

Thank you for reaching out to us.

We're using a 3rd party HTML5 library and it has some limitations. One of them is that for tables with server-side processing, only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export.

You can view all limitations in our documentation.

One more thing you can try is to make some code customization and to change in file  wp-content/plugins/wpdatatables/source/class.wpdatatable.php search for all (there is a couple of them)

exportOptions

and you will find this

'exportOptions' => array('columns' => ':visible'),

and you have to replace with this

'exportOptions' => array('columns' => ''),

Like this all columns from the table will be exported (visible and hidden)

Please note that this will be overwritten in next update and you have to do it again.

I hope this helps, do let us know if there is anything else we can assist you with.