Search

Allan, Just to give you a heads up - I tried the 1.8.3.dev file that's currently on the site and it still does this for me in the header and footer. Plus, I found that if I added the following at line 2817: [code] anCells[i].innerHTML = $.trim(anCells[i].innerHTML); [/code] If got rid of the extra spaces in the footer cells. Hope that helps.

They are text string - that's why :-). If you what DataTables to treat them as numbers, you would need to use a sorting plugin such as this one: http://datatables.net/plug-ins/sorting#formatted_numbers Allan

PLease see this thread which covers a similar topic: http://datatables.net/forums/discussion/6073 . Allan

Update: I found a way around the problem by putting the style="display:none"; directly in the td and th html and making the bVisible true for this column. I'm still kind of curious about this though--seems a bit ugly to solve in either of the two ways I could think of.

I've added a reply to your original question here: http://datatables.net/forums/discussion/comment/22417#Comment_22417 Allan

Hi, had the same problem, thanks to your help i got it to work within minutes :) [code] function fnFormatDetails(nTr) { var aData = oT.fnGetData(nTr); var sOut; $.ajax({ url: 'yourServiceURL', data: '{}', type: 'POST', contentType: 'application/json; charset=utf-8', dataType: 'json', success: function (result) { sOut = 'Detailed information: ' + result; oT.fnOpen(nTr, sOut, 'details'); } }); } [/code]

Thanks!

actually sorted this out - i had a little bit of a mess with hidden columns and jquery updates. sorry for the inconvenience! wonderful work

It is quite a common thing, and it's in the FAQs: http://datatables.net/faqs#ss_events :-) . I'd suggest just using a live event rather than $().click() for this, since it will be much easier to maintain. Allan

[code] <script type="text/javascript" charset="utf-8" src="media/js/jquery.js"></script> <script type="text/javascript" charset="utf-8" src="media/js/jquery.dataTables.js"></script> <script type="text/javascript" charset="utf-8" src="media/js/TableTools.js"></script> <script type="text/javascript" charset="utf-8" src="media/js/ZeroClipboard.js"></script> <script type="text/javascript" charset="utf-8"> $(document).ready( function () { TableTools.DEFAULTS.aButtons = [ "print","pdf", "xls" ]; $('#example').dataTable( { "bRetrieve": true, "sDom" : 'T<"clear">lfrtip' /*"oTableTools": { "aButtons": ["print","pdf", "xls"] }*/ } ); } ); </script> [/code]