Search

Inserting date values into Excel can be tricky. The internal storage format is number of days since 1899-12-30T00:00:00Z.

How can I update only the displayed value for a cell that contains an underlying array where a render is being used to display the array.length?

A similar plugin is demonstrated in this thread which seems to work. Need to remove the call todraw() though.

Sorry for the poor English (i'm using translator) and also for the code; I still have some difficulties with JS and I’ve been using ChatGPT to help.

AFAIK there is nothing built inot Datatables for this. See this thread for some examples of how to workaround deselect all with server side processing.

Nope, tbl = $('#tblQuestions').dataTable works just fine.

You have this to init Datatables:

I have a function that I call to create and populate grid.

Hi,

Do you have the raw SQL for what you want? If so, can you show me that?

I'm using

One more note: Last Working/Not Working statement applies also ColReorder issue.

For this example: https://editor.datatables.net/examples/styling/bootstrap5.html

On a different (but similar) page not implementing DT we have a with the following code:

I'm afraid your gen-AI friend is wrong there, or that it has stumbled on an answer that works due to some other issue. DataTables 2.3.6 will work, no problem with noConflict() as can be seen in this …

Sorry, yes you are right. The docs are here.

Buttons currently only has options to download or open the file (and even that is actually a bit limited by the browser's settings - i.e. it might download and open it).

I like to filter on a date range with ColumnControl, I created two searchDateTime

I have two more issues with ColumnControl

With regard to setting a filter via an API, yes it can be done and I use it a lot in the unit tests - have a look here for example: