fixed columns on datatable

Question

I have a portlet view jsp that I am trying to fix the left two columns along with the headers using dataTables and the FixedColumns plugin for a pivot table.

I get the header row to fix and to be able to scroll the Y-axis, but I am unable to Fix the two left columns in place as the code suggests.

 <script  type="text/javascript">
  var pTable ;
 $(document).ready( function () {
    pTable = $('#scheduleTable').dataTable( {
    "sDom": "<'row-fluid'r><'row-fluid't><'row-fluid'<'span6'i><'span6'p>>", 

    "sScrollY": 200,
    "sScrollX": "100%",
    "sScrollXInner": "100%",
    "bScrollCollapse": false,
    "fnInitComplete": function () {
       var fCols =  new FixedColumns( pTable , {
                "iLeftColumns":2,
                "sHeightMatch" : "auto",
                "iRightColumns": 0
                }
        );
      }
});

} );

</script>

I can see the FixColumns library via Firebug in Firefox but I cannot see how or if it is applied to the dataTable. It seems like the FixedColumns code is being ignored. Any thoughts on how to better debug this or to code this?

Thank you in advance.

YuC · Accepted Answer · 2013-09-15 09:06:10Z

1

@iowatiger08

have you tried this way:

var pTable ;
$(document).ready( function () {
    pTable = $('#scheduleTable').dataTable( {
        "sDom": "<'row-fluid'r><'row-fluid't><'row-fluid'<'span6'i><'span6'p>>", 

        "sScrollY": 200,
        "sScrollX": "100%",
        "sScrollXInner": "100%",
        "bScrollCollapse": false
    });
    new FixedColumns( pTable , {
        "iLeftColumns":2,
        "sHeightMatch" : "auto",
        "iRightColumns": 0
    });

});

answered Sep 15, 2013 at 9:06

YuC

1,8473 gold badges20 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

fixed columns on datatable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related