Title: Sorting problem
Last modified: August 21, 2016

---

# Sorting problem

 *  Resolved [RienraG](https://wordpress.org/support/users/rienrag/)
 * (@rienrag)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sorting-problem-2/)
 * Hello Tobias,
 * I would like to thank you for your great plugin!! It’s really great.
 * But I have a problem with sorting the columns. Not all of them are bad but only
   some. I’ve tried almost every advice which I found overe here. Went thru the 
   documentation but now I’m completely lost.
 * Here is the img of the table [http://i59.tinypic.com/2iaty76.jpg](http://i59.tinypic.com/2iaty76.jpg)
 * I would put a link on the web but its not public yet but I could provide you 
   access.
 * Thx a lot!
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sorting-problem-2/#post-4744509)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Most likely, you are having issues in the columns that have a #N/A entry, right?
   
   The reason for this is that those entries are not numbers, but text strings, 
   and because of that the JS library that is used for the sorting will sort the
   entire column with a text string sorting algorithm, which is different to a number
   sorting algorithm. The only real chance to change this is to remove those entries
   with numbers, unfortunately.
 * Regards,
    Tobias
 *  Thread Starter [RienraG](https://wordpress.org/support/users/rienrag/)
 * (@rienrag)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sorting-problem-2/#post-4744518)
 * Thx for answer Tobias,
 * well It doesn’t have to be #N/A can be anything else. Do you have any suggestion
   what I could put there instead?
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sorting-problem-2/#post-4744564)
 * Hi,
 * it should be a number, so that it can be sorted appropriately… Is that possible?
 * Regards,
    Tobias
 *  Thread Starter [RienraG](https://wordpress.org/support/users/rienrag/)
 * (@rienrag)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sorting-problem-2/#post-4744568)
 * Hi,
 * it could be zero but it would look stupid 🙂 In worst case I’m gonna put it there
   but would be much better to put sg like ?,-,N/A you know what I’m saying.
 * Thx a lot m8!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sorting-problem-2/#post-4744597)
 * Hi,
 * I understand that something else would be great, but the sorting algorithm then
   simply doesn’t know how to interpret `?` or `N/A`.
    You would need to rewrite
   the sorting algorithm, or use the 0.
 * Regards,
    Tobias
 *  Thread Starter [RienraG](https://wordpress.org/support/users/rienrag/)
 * (@rienrag)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sorting-problem-2/#post-4744695)
 * I see,
 * thanks a lot Tobias for your great work!!!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/sorting-problem-2/#post-4744696)
 * Hi,
 * no problem, you are very welcome! 🙂 Sorry that I didn’t have a better solution
   here.
 * Best wishes,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Sorting problem’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 7 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [12 years, 2 months ago](https://wordpress.org/support/topic/sorting-problem-2/#post-4744696)
 * Status: resolved