Hi,
thanks for your post, and sorry for the trouble.
Unfortunately, I couldn’t check your table, as the link you have posted only asks me to log in or subscribe 🙁
Now, most likely, the reason for this is that not all values in that column are purely numeric. There must not be any text strings or characters in that column. Could that be the issue?
Regards,
Tobias
So there can’t be any parentheses or periods? How can you insert the number so that it is purely numeric but also so that you can understand the actual value?
Thank you for the response!
Hi,
periods (as decimal separators) are fine. Parentheses are not, because the sorting algorithm simply can not know how to treat those.
Depending on the actual format that you use, you could have a look at the DataTables Sorting Plugins Extension from http://tablepress.org/extensions/datatables-sorting-plugins/
That contains algorithms for some types of formatted numbers.
Regards,
Tobias
Thank you.
I apologize for the inexperience, but once I have downloaded and activated the extension, will the datatables sorting plugin automatically apply? Or will I need to reupload the table for it to apply?
Thanks
Hi,
it will automatically apply, but as mentioned on the Extension’s web page, you will have to add a “Custom Command” on the table’s “Edit” screen.
Regards,
Tobias
One last question and then you have solved all of my issues!
For negative numbers, instead of parentheses, does the “-” work as a numerical sign that signifies negative? Or is it not possible to insert negative numbers?
Hi,
the - in front of a negative number will work just fine.
Regards,
Tobias
Thank you for all of your help!
Hi,
no problem, you are very welcome! 🙂 Good to hear that this helped!
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!
