Fixed Column collide with bJQueryUI ?
Fixed Column collide with bJQueryUI ?
![JoeHetfield](https://secure.gravatar.com/avatar/19195bb01246d32eff530c1a6f525328/?default=https%3A%2F%2Fvanillicon.com%2F19195bb01246d32eff530c1a6f525328_200.png&rating=g&size=120)
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
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
This discussion has been closed.
Replies
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
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
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?
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
#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;
}
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.
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