Search

Thanks Allan for your reply. I thought that this would be the answer. Oh well, IE7 will have to just look different! Thanks again.

You can update a row without reloading all the data again by using the fnUpdate api function. You can read up more on it here: http://www.datatables.net/api#fnUpdate. It also allows you to update just a cell within a given row. Hope this helps.

My bad - in trying to resolve the issue, I'd changed the css path to the images and didn't change them back, so your solution works perfectly - thanks and sorry for the time wasted.

Hi xover, I think this sounds like an ideal case for fnRender ( http://datatables.net/usage/columns#fnRender ). This will take the data you feed to the table and process the string as you require (adding a form field for example). If you were to combine this with the new data source options in DataTables 1.8 (currently beta - although not for much longer... :-) ) you could indeed base the formatting on other attributes in the data source object ( http://datatables.net/blog/Extended_data_source_options_with_DataTables ). An alternative would be to attach a class of, say, 'number' to the TH element for the column, and use aoColumnDefs to target a given rendering function at that column. You might also be interested in this post: http://datatables.net/blog/Inline_editing and this example: http://datatables.net/examples/api/form.html Regards, Allan

Nevermind -- didn't realize I had to have the SS script output the buttons, figured it was done automatically like so much other stuff datatables does. I'm in good shape (for now).. thanks!

Nice one - thanks for the feedback :-) Regards, Allan

I fixed the issue by just adding a ling from "http://developer.yahoo.com/yui/articles/hosting/" to my index.html. Maybe this can help in resolving other issues that many others are experiencing. Thanks again for responding to my questions. I really appreciate it.

var button = 'Add'; var idButton = $("#guideContainer-rootPanel-panel-guidebutton___widget"); idButton.replaceWith(button); $("#guideContainer-rootPanel-panel-guidebutton___widget").on('click',function(){ //debugger; detailsTableDailyExcess.row.add( { "institution": "", "region": "", "branch": "", "rgm": "", "crm": "", "ID": "", } ).draw(); }); //I am trying to add drop down to "institution","region" and "branch". Right now I am able to add an empty row when I click the button

Hi there, I've some table cell with complex data, not only a simple string, but a sort of div-grid table nested into the cell. So I'm exporting it keeping new lines, in this way, extendings buttons: $.extend(true, $.fn.dataTable.defaults, { buttons: { buttons: [ { extend: 'excel', exportOptions: { format: { body: function (data, row, column, node) { var result = data; var columnIndex = GetColumnIndexByColumnName("MissingPayments", true); if (column == columnIndex) { result = ""; var cellGrid = $(node).find('.cell-grid'); var cellGridRows = cellGrid.find('.cell-grid-row.active'); cellGridRows.each(function (index, row) { var cellGridRowsColsArray = $(row).find('.cell-grid-col').map(function () { return $(this).text(); }).get(); var row = cellGridRowsColsArray[0] + ": " + cellGridRowsColsArray[1] + " (" + cellGridRowsColsArray[2] + ")"; result += row + "\r\n"; }); } return result.trim(); } } }, customize: function (xlsx) { var sheet1 = xlsx.xl.worksheets['sheet1.xml']; var columnIndex = GetColumnIndexByColumnName("MissingPayments", true); var columnLetter = GetLetterByNumber(columnIndex).toUpperCase(); $('row c[r^="' + columnLetter + '"]', sheet1).attr('s', '55'); $('row:first c', sheet1).attr('s', '2'); // overwrite first row, so it keeps bold } } ] } }); It works perfectly, but the row with a single line become vertically aligned to the bottom on the excel. How can I align them to the top (or middle) keeping the wrap text on the selected column? Thanks, you are very helping me in these days!

Hello, at first i am so sorry for my bad english. I am using DataTables for my gridviews and i started to use exportButtons to print grid's on Pdf and Excel. The excel exportation is perfect, but when i try pdf i have a problem. Look at the image i uploaded. My report is to small comparing to the A4 page and i would like to fill all the page with the Report. I searched a lot on the site, but i didnt find something like this. As u can see in this image i have my report and a gigant Blank space in the right side. I would like to fix this expandig my cell, i dont knot the best way to do this. Thanks everyone who see this!