Deactivate sorting for some columns

Hi,

thanks for your post. Great to hear that you like the plugin!

Deactivating sorting for some columns is possible with some small extra code. Please try adding this to the “Custom Commands” textfield in the “Features of the DataTables JavaScript library” section on the “Edit” screen of your table:

"aoColumnDefs": [ { "bSortable": false, "aTargets": [ 0, 4 ] } ]

This example would deactivate sorting for the first and fifth columns (the counting start with 0 in the code).

Having an extra static header with colspan is not possible, unfortunately. TablePress only supports on head row, and the DataTables JS library also requires serious extra work to have this. Sorry about that.

Regards,
Tobias

hi tobias,

thank you for your quick reply. the sorting deactivation works perfect. i guess i have to manually put another table on top to fake a static header.

i came across of some other issues ??

1) math function get disabled with a “:” when adding or deleting rows. is that normal?

2) is it also possible to only allow ascending sorting? descending just makes no sense in my case ??

3) is it possible to generate an automatic rank, based on the total points of a team?

Thank you in advance!

Hi,

great that this works already ??

1. I have no clue what you are talking about here. Can you maybe show me an example?

2. Yes, this is also possible, with another short command for the DataTables JS library (see https://www.datatables.net for its documentation). Please try extending the “Custom Command” from above to

"aoColumnDefs": [ { "bSortable": false, "aTargets": [ 0, 4 ] }, { "asSorting": [ "asc" ], "aTargets": [ 1 ] } ]

This would only allow ascending sorting for the second column.

3. I’m also not sure about this, as I don’t know what your table looks like. Can you show me an example for this as well?

Thanks,
Tobias

ok ascending sorting works good although i would like to make generally for all columns. is there a way to do that or do i have to put in all columns manually.

about 1)
i have =C3+D3 in a cell, which works fine. when i now add/delete a row, the code changes to =C3:+D3: which disables the math function of course.

about 3)
the table is pretty simple. there are five events. each has a rank and points (i put them in manually cause the points are based on the number of teams). at the end there are overall points (sum of five events) and the overall rank. if possible, i would like to generate the rank number automatically.

btw: which is the default ranked column at a table? the first one?

Hi,

if you want this for all columns, just use

"aTargets": [ "_all" ]

instead of

"aTargets": [ 1 ]

About the : in the formulas: Thanks for catching this! I investigated this a little bit, and from what I can see, this only happens when using Firefox. Internet Explorer and Chrome don’t do this. Are you using Firefox, too?

3) Hmm, ok. Unfortunately, I don’t really see a possibility for this, as that would require some comparision somehow… Sorry.

By default, the column is not sorted, it is printed exactly as you entered the data.

Regards,
Tobias

ok thx. sorting works perfect. yes, i am using firefox. the browser keeps getting worse and worse ??

can i set a default sorting for the table?

Hi,

oh, it’s not necessarily a bug in Firefox. It might also be a problem in my code. I’ll investigate this. If it is a bug (or if I can find a work around), I’ll of course add that in the next version of TablePress.

Yes, doing a default sort is possible. Just add this to the “Custom Commands”, separated from what you have now with a comma ,

"aaSorting": [[0,'asc']]

This will perform an initial ascending sort on the first column.

Best wishes,
Tobias

fixed with help from the author!

Hi,

great! Thanks a lot for the confirmation!

Best wishes,
Tobias