Datatable doesn't save state of the hidden columns

tejadong

Hello, sorry for my English, I'm Spanish...

When I hide the columns of my table and I reload the web page It doesn't work for me however I check on the list where I can check/uncheck the columns that It works fine. It seems to be that when my web is loaded It doesn't work but the check list of column was saved.

Any suggestions?

Thanks you.

tejadong

Sorry, I forgot to paste my code:

$(document).ready(function() {
            
            var table = $('table').dataTable( {
                language: {
                    url: '{{ base_url() }}assets/json/spanish.json'
                },
                "dom": 'CT<"clear">lfrtip',

                "tableTools": {
                "sSwfPath": "{{ base_url() }}assets/swf/copy_csv_xls_pdf.swf",                  
                "aButtons": [
                             {
                                 "sExtends":     "xls",
                                 "sButtonText": "Excel"
                             },
                             {
                                 "sExtends":     "print",
                                 "sButtonText": "Imprimir"
                             }                             
                            ]
                },
                "colVis": {
                    "buttonText": "Ocultar/Mostrar columnas",
                    "restore": "Restaurar",
                    "showAll": "Mostrar todas",
                    "showNone": "Ocultar todas"
                },      
                "iDisplayLength": 10,
                "aLengthMenu": [[10, 25, 50, 100, -1], [10, 25, 50, 100, "todos"]],
                "stateSave": true,
                "stateDuration": -1
            } );
            
            new $.fn.dataTable.FixedHeader( table, {
                "offsetTop": 51
            } );                
            
        } );

tejadong

I made a test here: http://live.datatables.net/jekupuqo/1/ and work fine... I don't know...

tejadong

I'm using bootstrap datatable, i think It is the problem...

tejadong

When I use dataTables.fixedHeader and dataTables.responsive (js and css) the state of columns isn't saved... Is this a bug?

allan

The issue is that you have included Responsive - which is not currently compatible with ColVis since both are trying to control column visibility.

Allan

tejadong

What can i do then?

allan

There is unfortunately no option to use both at the same time at the moment. You need to decide which you want more...

It is something that I will address in a future update when I am able to do so.

Allan

tejadong

Ok thank you! your work is great! Cheer up!