Hi,
the reason for this likely is that not all of the cells in that column (except for the head row) have plain numerical values in them. Plain numeric value means nothing except the numbers from 0 to 9, and the . for non-integer values.
If you post the URL to the page with your table, I will gladly take a look and check if that is the case here.
Regards,
Tobias
That must be it. I have percentages in those columns. Any way to display a %?
Here is the table (A work in progress).
http://homebrewresource.com/hop-guide/
Thanks!
Hi,
thanks for the link. The percentages are indeed the reason for this.
Fortunately, there is a “Plugin Extension” that makes these sortable (just like currency values, for examples).
To install this, please take a look at the thread http://ww.wp.xz.cn/support/topic/plugin-wp-table-reloaded-sorting-numbers-1 where I explain this.
Regards,
Tobias
Thanks for the reply Tobias.
I installed the extension and added the custom code ” “aoColumnDefs”: [ { “sType”: “currency_sorting”, “aTargets”: [ “column-3”, “column-4″ ] } ”
to my page. Doing so makes it no longer sortable or searchable at all. I left this version on the server for you to view.
Any suggestions? Thanks again for your help!
Hi,
from what I can see there’s a ] missing at the end of the code that you inserted. Please try again with
"aoColumnDefs": [ { "sType": "currency_sorting", "aTargets": [ "column-3", "column-4" ] } ]
Regards,
Tobias
Hi,
awesome, thanks for the confirmation! 🙂
Best wishes,
Tobias
