Sorting Problem – I do not get it.

Hi,

thanks for your post, and sorry for the trouble.

It takes multiple sorts for me in Chrome as well, as the sorting directly after the first click is also wrong. My assumption here is that this is caused by the HTML code for the links in the cells. Because of that, the content in the cells is a string and not a number.
Now, as the reason for the links is in your other post at https://www.ads-software.com/support/topic/link-entire-highlighted-row?replies=1 , I suggest that we take a look at that first, as we can then maybe remove the link HTML again.

Regards,
Tobias

Okay, Tobias!

Let us first see if we even get the whole wrows linkable. What is still irritating me is: Why does sorting work with the prices? And all the other columns? I inserted links in every column but this single column does not work…

My belief in your talent and capabilities is limitless, so let’s see…

Thanks from AnDee!

Hi,

ok, now that the whole row linking is working, you can probably remove all those extra links again ?? The sorting should then work as expected again.

Now, for the reasons (at least as far as I think) why this happened: Sorting is very complicated and always needs a sorting algorithm that is dependent on the data format, simply because numbers are sorting in another way as text or dates, etc. Also, numbers can have different decimal separators, like a , in German, but a . in English. All this has to be taken into account, and the external DataTables JavaScript library from https://www.datatables.net/ that TablePress uses does that by offering sorting algorithms for a wide range of formats. Those algorithms get an extra challenge when the data that is actually the interesting data is captured inside of extra link HTML. Then, it sometimes has to remove that link HTML internally, first. In the case of prices, this is all fine, as it afterwards has to do more processing anyways (like internally removing the currency symbol). For a column with just numbers, it thinks that it doesn’t have to do anything else though – which is not accurate, however. It would have to check the decimal separator but apparently is not doing that (maybe for performance reasons). So, this would require manual attention by adding another sorting algorithm.

But this is just my interpretation, as I’m not the developer of the DataTables JS library, I don’t know every detail of it ??

Anyway, removing the extra links again should now be the best fix to this.

Regards,
Tobias