[Plugin: WP-Table Reloaded] Sorting problem with blank cells

  • Resolved sshauy

    (@sshauy)


    13 years, 9 months ago

    Hi Tobias,

    Great plugin, man!

    1) I’m having trouble with sorting and I suspect it’s because of blank cells in the column (no data available)… and perhaps the commas in the numbers like 1,230,000 might be another cause? It’s sorting all wrong.

    2) Having a column with many blank cells, would it be possible when sorting by it, to show only the numbers sorted at the top and have the blank cells at the bottom (both ascending and descending) – just like Excel does?

    You can see my table at http://en.shauy.com/new-york-properties/

    I tried to search back 6 months of posts to find the answer and not have to bother you, but unfortunately couldn’t find the answer.

    Thanks in advance for your time!
    Best,

    Sidney

    http://ww.wp.xz.cn/extend/plugins/wp-table-reloaded/

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 9 months ago

    Hi,

    thanks for your post.

    Yes, commas in numbers cause trouble for the sorting, as that leads to the cell being sorted as a string and not as a number. You will either need to remove the commas, or apply a custom sorting plugin for the DataTables JS library.

    The issue with the blank cells is similar. As far as I know, they are treated as 0, that’s why they are sorted at the beginning. Unfortunately, I don’t know how to fix those to the bottom of the table, and you might want to check this with the DataTables library as well (www.datatables.net).

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘[Plugin: WP-Table Reloaded] Sorting problem with blank cells’ is closed to new replies.