Column visibility not respected with pdf export
Column visibility not respected with pdf export
ooioo
Posts: 23Questions: 4Answers: 0
Hi,
when using colspan and rowspan, column visibility is not respected.
In this test case :
https://live.datatables.net/fogigafi/1
if you hide column "Position" and then click "PDF", the column Position is visible in the PDF.
Javascript :
new DataTable('#example', {
layout: {
topStart: {
buttons: [{extend: 'pdfHtml5', exportOptions: {columns: ':visible'}},
'colvis']}},
});
Html :
<thead>
<tr>
<th rowspan="2">Name</th>
<th colspan="2">Position and office</th>
<th rowspan="2">Age</th>
<th rowspan="2">Start date</th>
<th rowspan="2">Salary</th>
</tr>
<tr>
<th>Position</th>
<th>Office</th>
</tr>
</thead>
Thanks,
Pierre.
Answers
See this example for how to export only visible columns.
Kevin
Thank you for this link Kevin, but I export only the visible columns with exportOptions: {columns: ':visible'} and the problem seems to me related to rowspan and colspan. Am I wrong ?
Pierre.
In fact if the two columns regrouped in colspan (Position and Office) are hidden with colvis, then they are not visible in pdf. If just one of the two is hidden with colvis then both are visible in pdf.
Pierre.
It works with being explicit with columns numbers :
exportOptions: {columns: ['0:visible', '1:visible', '2:visible', ... ]},
Pierre.