Fixed Column collide with bJQueryUI ?

JoeHetfield

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

allan

Can you link to a page showing the problem please. jQuery UI thumbing and FixedColumns should work just fine together.

Allan

JoeHetfield

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

JoeHetfield

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

JoeHetfield

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?

allan

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

david33409

@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;
}

david33409

@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.

david33409

@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