Search

Hi Kevin, Thanks for that link! I reviewed it and changing the code to: "render": function (data, type, row) { if (type === 'export') return '=3+' + 4; return "whatever"; } And the buttons options to: buttons: [ { extend: 'excel', exportOptions: { orthogonal: 'export', }, customize: function (xlsx) { var sheet = xlsx.xl.worksheets['sheet1.xml']; var col = $('col', sheet); $('row c[r^="H"]', sheet).each(function ( index, element) { if (index !== 0) { //change the type to `str` which is a formula $(this).attr('t', 'str'); //append the concat formula $(this).append('<f>' + $('is t', this).text() + '</f>'); //remove the inlineStr $('is', this).remove(); } }); } } ] You were right I needed to understand better the xml structure. Thanks!

The JSON is not in a format that Datatables expects. Info regarding data format is here: https://datatables.net/manual/data/ Looks like you have only one column defined but returning more data. You can do that. Your data is in an object rows. I believe you will need to use ajax.dataSrc to change from the default of data to rows. The first example shows this. Kevin

depends. Basically you add a second header row with the appropriated control (text boxes or select boxes or whatever) in the th so it looks something like         <thead>             <tr>                 <th>Name</th>                 <th>Position</th>                 <th>Office</th>                 <th>Age</th>                 <th>Start date</th>                 <th>Salary</th>             </tr>             <tr>                 <th> <input type='text'> </th>                 <th><input type='text'></th>                 <th><select><option value='Tokyo'>Tokyo</option></select></th>                 <th> <select><option value=20>20</option></select> </th>                 <th><input type='text'></th>                 <th><input type='text'></th>             </tr>         </thead> Then you add the appropriate event handlers to trigger the search. It becomes more complicated depending on such things as scroller turned on, or serverSide set to true. I have not seen anything to make me think these feature are already built into DataTables. I can build you a working example if you like but it will be a while before I can get to it.

Ah - thanks for pointing that out. I had thought Editor would remove the hidden display. i'll look into that! Regards, Allan

Yes, the draw event or drawCallback option is the way to do this. The issues with page is that it is triggered before the page change has actually be redrawn! You could listen for draw inside a page listener, but its probably as well to just listen for draw. Allan

datawidth, you can define as column width as '*'

scrollY. Allan

Thanks for your question - however, per the forum rules can you link to a test case showing the issue please. This will allow the issue to be debugged. Information on how to create a test page, if you can't provide a link to your own page can be found here. Thanks, Allan

how to update dtOptions What is dtOptions? I think I've seen that before in an Angular compatibility library for DataTables, but that isn't authored or supported by myself. Allan

The deferRender option shouldn't effect the HTTP download speed at all - that will only change the draw time. What I think would be interesting here is to ascertain how long it is taking to download that data. For example, if it takes 19 seconds to download the data from the server to the client, there really any any changes that can be made to DataTables to make things faster. Allan