Search

This seems like a bug and not a feature.

Sounds like you have server side processing enabled. There are many threads on the forum with this question. See if this thread helps.

The best way to do is to have the double row in the header in the HTML. See this example from this thread. Could you look at that, please, and see if it helps. If it's still not working for you, plea…

This example from this thread should help - it's disabling the Age field on edit, but it's writable on creation.

See Allan's response in this thread. I think it will answer your question.

Here is an example of such a manipulation: https://datatables.net/forums/discussion/comment/146854/#Comment_146854

https://datatables.net/forums/discussion/comment/148597/#Comment_148597

I updated Allan's example in this thread to show one way to access all columns. Allan's example uses a specific selector ($('row c[r^="C"]', sheet) to loop through all the rows but only fo…

There are lots of threads discussing this. See if this or this helps.

Yep, this thread was the origin of that example,

https://datatables.net/forums/discussion/comment/177394/#Comment_177394

https://datatables.net/forums/discussion/comment/172785/#Comment_172785

https://datatables.net/forums/discussion/comment/179968/#Comment_179968

See this [thread]https://datatables.net/forums/discussion/comment/165783/#Comment_165783) to learn how to calculate columns that are using columns.render.

Allan posted an example in this thread of creating a cascading option filter. I think its what you are looking for.

See if this thread helps. If not please provide a link to your page or a running test case showing the issue so we can help.

See if Gyrocode's example code in this thread.

This thread shows how to sum the data when using columns.render.

This example from this thread should do what you want.

Hi @antokios ,