Title: [Plugin: WP-Table Reloaded] Sorting problem with blank cells
Last modified: August 20, 2016

---

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

 *  Resolved [sshauy](https://wordpress.org/support/users/sshauy/)
 * (@sshauy)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wp-table-reloaded-sorting-problem-with-blank-cells/)
 * 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/](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://wordpress.org/extend/plugins/wp-table-reloaded/](http://wordpress.org/extend/plugins/wp-table-reloaded/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wp-table-reloaded-sorting-problem-with-blank-cells/#post-2999900)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-table-reloaded_f7dcd3.svg)
 * [WP-Table Reloaded](https://wordpress.org/plugins/wp-table-reloaded/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-table-reloaded/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-table-reloaded/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-table-reloaded/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-table-reloaded/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-table-reloaded/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wp-table-reloaded-sorting-problem-with-blank-cells/#post-2999900)
 * Status: resolved