Title: Column Sorting not working
Last modified: June 12, 2019

---

# Column Sorting not working

 *  Resolved [GoodShark](https://wordpress.org/support/users/goodshark/)
 * (@goodshark)
 * [6 years, 12 months ago](https://wordpress.org/support/topic/column-sorting-not-working-2/)
 * I’m trying to get the columns that are measured in feet to be sorted properly,
   but it doesn’t work. It seems to work on the backend editing, but when it’s previewed,
   it doesn’t work.
 * It seems to think that 9′ is bigger than 10′, I assume it has something to do
   with it being double digits.
 * Height works fine, because none of the values go into double digits, but the 
   block and spike touch both get screwed up when one of the values is under 10′.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcolumn-sorting-not-working-2%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 12 months ago](https://wordpress.org/support/topic/column-sorting-not-working-2/#post-11632078)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * The cause for this is that writing a cell value as e.g. 10’8″ technically turns
   that value into text string and not a number – and text strings are sorted differently
   than numbers. You’d be seeing the same with the weight, if someone were to have
   less than 100lbs.
 * Your best chance to work around this is probably to use the approach from [https://wordpress.org/support/topic/date-order-6/](https://wordpress.org/support/topic/date-order-6/)
   which deals with a very similar scenario. In your case, the extra column with
   the data for sorting could be the feet and inches written like “1008” for 10’8″,
   and e.g. “911” for 9’11”.
 * Regards,
    Tobias
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Column Sorting not working’ 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/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [6 years, 12 months ago](https://wordpress.org/support/topic/column-sorting-not-working-2/#post-11632078)
 * Status: resolved