One column, Two different titles!

marinicg

Here's my problem:

I have a report that has 6 columns that are using png icons as columns's titles (just the image, no text). When an user puts a mouse over each icon, a tooltip shows up with its real name over the icon.

The problem is, when I export the whole data to an excel file, DataTables doesn't exports these images (and I'm not intending to export the images) nor the real titles (the ones I used as tooltips).

Also in the buttons ColVis, I can't get it to get the tooltip information with its real names.

Is there any possibility to have a column title different of its export title information and the same to ColVis extension?

I hope I made myself clear?

Any suggestion?

Thanks,
Mauricio

marinicg

Well...

This was FAST and in a DUMB WAY!

If someone has the same problem, I solved this way:

In the column title, I've added a SPAN with DISPLAY:NONE.

<th class="icon-tooltip" data-original-title="Check-In">
<span style="display:none">Check-In</span>
<div class="ocs_dataTable_header_title ocs_dataTable_coleta-checkin"></div>
</th>

This solved both problems: ColVis Titles and Export Data!

Hope this solution can helps someone.

Thanks,
Mauricio

btree

Hoi,

for the ColVis I would write my own buttons inside a collection.

{               
extend: 'collection',
text: 'ColVis',
buttons: [
      {
            text: 'First Col Title'
            extend: 'columnToggle',
            columns: ':gt(0)'
       },
      {
            text: 'Second Col Title'
            extend: 'columnToggle',
            columns: ':gt(1)'
       },
.......
]

If I understand you correctly and you dont want to export any title you can use header: false option, inside your export buttons.

Cheers
Hannes

marinicg

Hey Hannes,

Thanks for the answer.

I do want to export all titles but, in my case, I use icons instead texts. What i've done was add the "display:none" within a span tag and ColVis and Export worked fine.

For the custom ColVis buttons, i've used the code you posted and I managed to fix things in a better way.

Thanks,
Mauricio