Viewing 1 replies (of 1 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for your trouble.

    Basically you already described the reason for this: The values in the “Spread” column are actually not “numeric” values! They are strings, due to the “%” character in the cells. Due to that, the DataTables JavaScript library recognizes the values in that column as strings, and not as numeric. And strings are sorted differently than numeric values.
    So, to change this behavior, I suggest that you remove the “%” from that column’s cells for now. The DataTables JavaScript library does have a way to get percentage values sorted correctly (see https://datatables.net/plug-ins/sorting#percentage ), but I didn’t yet have the time to add this to TablePress. I have planned to do that in the next months, though.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘numeric sorting’ is closed to new replies.