sorting problem

Hi,

thanks for your post.

No, this is not a bug, but a result of the used number format.
The JavaScript library that is used in TablePress is based on English numbers, where the dot (.) is used instead of the comma (,) as the decimal separator.
Your columns are therefore not recognized as numbers and therefore sorted as strings.

To change this, please install the “DataTables Sorting plugins” Extension for TablePress from https://tablepress.org/extensions/datatables-sorting-plugins/ and follow the instructions in the “Comma as the decimal separator” section.

Regards,
Tobias

Sorry, but that seems to be a bit too complicated. Wouldn’t it be easier to have an option in the backend to choose whether to use the point or the comma as decimal seperator?

Hi,

thanks for your feedback!

I know that it might not be the best solution, but an option in the backend is also not my favorite. I’ll think about it, but for now this is the only way to go.

And it’s really not complicated at all! Just install that file that you can download on that page as a new WordPress plugin, and add that one line of code to the “Custom Commands” field on the “Edit” screen of the table. That’s it.

Regards,
Tobias

Yes sure, that was not, what I meant to be complicated. The process of entering this code in every table is odd and not useful for managing lot of tables.

Hi,

ah, ok, that’s what you mean. Yeah, that can indeed be tedious.

The problem is that I can’t really automate this, as the code needs the numbers of the columns that use the numeric comma.
Changing this for all tables at once would require a change in the code of the DataTables JavaScript library (which is used for the sorting), but that’s not something that I can do ?? Sorry.

Regards,
Tobias