Selecting cells only from the 1st column

Selecting cells only from the 1st column

tambrams25tambrams25 Posts: 2Questions: 1Answers: 0

Hi,
Thanks for this awesome plug-in. I have a question about the select extension. I got the following code which works fine in selecting multiple cells :

$("#my_table").DataTable( {
"processing" : true,
"pageLength": 25,
"sDom": 'B<"clear">lfrtip',
"ordering": false,
"bJQueryUI": true,
buttons: [
{ extend: 'excelHtml5',
text: 'Export to Excel'
},
{ extend: 'selectAll',
action: function(e, dt, node, config) {
dt.cells(null,0,{page: 'current'}).select();
}
},
'selectNone',
{ extend: 'selectCells',
text: 'Select Hostnames'
},
{
extend: 'selected',
text: 'Create Schedule'
}
],
select: {
style: 'multi',
items: 'cells'
}

});

I'am wondering if it is possible to restrict multiple cell selection to just the 1st column. In other words, the users should be able to select-All or select multiple cells only from 1st columns, selection on all other columns should be disabled.

Thanks.

Answers

  • tambrams25tambrams25 Posts: 2Questions: 1Answers: 0

    Sorry the code was not formatted properly:

    $("#my_table").DataTable( {
                    "processing" : true,
                    "pageLength": 25,
                    "sDom": 'B<"clear">lfrtip',
                    "ordering": false,
                    "bJQueryUI": true,
                    buttons: [
                            { extend: 'excelHtml5',
                              text: 'Export to Excel'
                            },
                            { extend: 'selectAll',
                              action: function(e, dt, node, config) {
                                    dt.cells(null,0,{page: 'current'}).select();
                                    }
                            },
                            'selectNone',
                            { extend: 'selectCells',
                              text: 'Select Hostnames'
                            },
                            {
                                    extend: 'selected',
                                    text: 'Create Schedule'
                            }
                    ],
                    select: {
                            style: 'multi',
                            items: 'cells'
                    }
    });
    
This discussion has been closed.