Search

Hello, I was able to export ISO8601 dates in date format. According to requirement, I am looking for below cases 1. When user see date values in YYYY-MM-DD format in page then same should be exported to excel in date format. 2. When user see date values in MM-DD-YYYY format in page then same should be exported to excel in date format. 3. When user see date values in DD-MM-YYYY format in page then same should be exported to excel in date format. I've tried for multiple cases but no luck. Your help would be much appreciated and would be very helpful. Thanks PD

I have found a way to get past the problem, however if there is a more efficient method, would love to hear! The way I solved it was by var id = t.row('[id='+symbol+']').index(); t.cell({row:id, column: 2}).data(response.c).draw(false);

o/

Confirmed, thanks

@allan Thanks again :)

Hi RolandH, The API method .cell().index() can tell you details about the cell you have, then you can tweak it to get the neighbouring cell, as in this example. Cheers, Colin

Eventually got there.... editorInvoices.edit( currentSelectedInvoiceIndex, false ).submit(); Cheers Steve Warby

Buttons 1.5.0 is now available which addresses this issue. Using a space would also workaround the problem. Allan

Yup - that looks good for that method - nice one. So for the second method you would simply have the renderer return what you want to display in the table (i.e. the button). Remove the onclick DOM0 event handler and instead use something like: $('#myTable').on( 'click', 'button.btn', function () { var rowData = table.row( $(this).closest('tr') ).data(); ... } }; Then use rowData to write the data into an existing modal element and finally use the Bootstrap modal API to display the modal. Allan

Ok this is the cottection: function changeName(element) { var jch = $(element); var col2 = jch.parent().parent().find('[name="col2"]'); col2.html('Xantos'); var tbx = $('#tableTopic').DataTable(); var rwx = tbx.row(jch.parent().parent()); rwx.invalidate(); } Thanks :)