Fixed Column collide with bJQueryUI ?

Fixed Column collide with bJQueryUI ?

JoeHetfieldJoeHetfield Posts: 5Questions: 0Answers: 0
edited August 2012 in FixedHeader
Hi,

I use data table with Fix Column and enabled the bJQueryUI feature.

when i changed the display row numbers (form 25 rows to 50 rows), the unfixed columns is changed to 50 rows but the fixed column is remained as 25 rows (and can't sort).

If I remove the bJQueryUI option, everything goes fine.

I'm really stack here, any ideas?

thanks.

Joe

Replies

  • allanallan Posts: 54,572Questions: 1Answers: 8,534 Site admin
    Can you link to a page showing the problem please. jQuery UI thumbing and FixedColumns should work just fine together.

    Allan
  • JoeHetfieldJoeHetfield Posts: 5Questions: 0Answers: 0
    Hi, Allan

    sorry our site is not open to public yet. but I can post the code with this problem (localized with japanese...):

    [code]
    $(document).ready(function(){

    var oTable = $( "#dataTable" ).dataTable({
    "sScrollX": "100%",
    "sScrollXInner": "150%",
    "bScrollCollapse": true,
    "sPaginationType": "full_numbers",
    "iDisplayLength": 25,
    "sDom": '<"H"<"left"T>l<"right"C>fr>t<"F"ip>',
    "oTableTools": {
    "sRowSelect": "multi",
    "sSwfPath": "../swf/copy_csv_xls_pdf.swf",
    "aButtons": [ "csv", "xls", "pdf" ]
    },
    "oColVis": {
    "buttonText": "表示列設定",
    "aiExclude": [ 0, 1 ]
    },
    "oLanguage": {
    "oPaginate": {
    "sFirst": "先頭",
    "sLast": "最後",
    "sNext": "次",
    "sPrevious": "前",
    },
    "sInfo": "_TOTAL_件を発見しました。(_START_件〜_END_件を表示しています。)",
    "sInfoEmpty": "0件を発見しました。(0件〜0件を表示しています。)",
    "sInfoFiltered": "_MAX_件に絞り込んでいます。",
    "sLengthMenu": "ページ毎に_MENU_件表示します",
    "sSearch": "検索:",
    "sZeroRecords": "該当レコードが見つかりませんでした。"
    },
    "bJQueryUI": true
    });

    new FixedColumns( oTable, {
    "iLeftColumns": 2,
    "iLeftWidth": 200
    } );

    });
    [/code]

    is there something wrong with the setting ? I'm new to data table.

    thanks.
    Joe
  • JoeHetfieldJoeHetfield Posts: 5Questions: 0Answers: 0
    edited August 2012
    Hi, Allan

    BTW, I got this error message in browser's console :

    FixedColumns.min.js: 41
    TypeError: 'undefined' is not an object (evaluating 'b("span.DataTables_sort_icon",l[d][i].cell)[0].className')

    Any ideas?

    thanks.
    Joe
  • JoeHetfieldJoeHetfield Posts: 5Questions: 0Answers: 0
    edited September 2012
    Hi, Allan

    I found this example has the same problem I posted before (with IE9) :
    http://datatables.net/release-datatables/extras/FixedColumns/themed.html
    you can try to click the header of the fixed column, it can't sort. but the unfixed column are sorted.

    is it a bug?
  • allanallan Posts: 54,572Questions: 1Answers: 8,534 Site admin
    Thanks for the link - yes thats a bug in the current release version of FixedColumns :-(.

    However, the current 2.5.0.dev version has a fix for it. You can download the nightly from the downloads page: http://datatables.net/download .

    Allan
  • david33409david33409 Posts: 11Questions: 0Answers: 0
    @allan, I retrieved version 2.5.0.dev of Fixed Columns. I see the new design and it seems to work with jQuery UI. I recommend adding style "border-spacing: 0;" to table. Otherwise (in Safari at least), you can see the other column data under the cell borders when scrolling. For example:

    #mytablediv table {
    border-spacing: 0;
    }

    Also recommend adding a background color to the elements so that the column title isn't fuzzy (at least in Safari). For example:

    table.dataTable thead th {
    padding: 3px 0px 3px 10px;
    cursor: pointer;
    /*DAM added to fix issue with dev FixedColumns*/
    background-color: cyan;
    }
  • david33409david33409 Posts: 11Questions: 0Answers: 0
    edited October 2012
    @allan,

    FWIW, with respect to ColReorder working with FixedColumn plugin. I recommend preventing user from a) dropping column onto fixed columns and b) reordering fixed columns. Currently, you can drag a column onto the fixed columns causing the fixed columns to be duplicated. You can also drag a fixed column causing a duplicate.

    Thank you for your great work.
  • david33409david33409 Posts: 11Questions: 0Answers: 0
    @allan,

    I noticed that the dev version of FixedColumns also has an issue with ColVis. I've got 24 columns with 5 initially hidden in between the fixed (2) and non-fixed (22) columns. When you use ColVis to view hidden columns, the first 'non-fixed' column's width is not adjusted correctly and seems to get cropped on the left. I'd be happy to send you screen shots if you want and I can also look into a solution.

    Thank you
This discussion has been closed.