JQUERY Tablesorter not sorting numeric columns correctly

Question

I'm having problems sorting columns that contain floating point numbers and integers:

Example

Column currently being sorted like so :

I would like to sort the column by value as it appears to be sorting the figures by character length at the moment - possibly?

Here's my javascript :

<script>

$(function(){
    $('table').tablesorter({
        widgets        : ['zebra', 'columns', 'stickyHeaders'],
        usNumberFormat : false,
        numberSorter: function (a, b, direction) {
    if (a >= 0 && b >= 0) { return direction ? a - b : b - a; }
    if (a >= 0) { return -1; }
    if (b >= 0) { return 1; }
    return direction ? b - a : a - b;
}
    });
});

</script>

Could somebody please let me know what I need to do to correct this? Thanks

just a guess, but you set usNumberFormat false, the sorter should then expect numeric values like 430,95... either change your values or use true — fuchs777
– fuchs777, Commented Sep 30, 2014 at 10:53
Why do you need the extra code in the numberSorter? It should work properly without it. — Mottie
– Mottie, Commented Oct 2, 2014 at 17:34

Donal · Accepted Answer · 2014-09-30 11:12:12Z

2

The fix was suggested by @fuchs777. The usNumberFormat setting was set to false. Which meant the tablesorter was treating the values as if they were in German number format, e.g. 1.234.567,89. With German number format the thousands are denoted by periods (full stops) and not commas.

The fix was setting usNumberFormat : true

For example:

$(function(){
    $('table').tablesorter({
        widgets        : ['zebra', 'columns', 'stickyHeaders'],
        usNumberFormat : true,
        numberSorter: function (a, b, direction) {
        if (a >= 0 && b >= 0) { return direction ? a - b : b - a; }
        if (a >= 0) { return -1; }
        if (b >= 0) { return 1; }
        return direction ? b - a : a - b;
    }
    });
});

edited Sep 30, 2014 at 11:12

answered Sep 30, 2014 at 10:51

Donal

33.2k10 gold badges69 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

aphextwix Over a year ago

Nothing has changed. Any other suggestions? Thanks

Donal Over a year ago

@fuchs777 suggested the answer: usNumberFormat : true.

Donal Over a year ago

@fuchs777 Yes it would. When usNumberFormat was set to false - it was assuming the values were German number format. In German number format thousands are denoted by periods and not commas.

fuchs777 Over a year ago

@Donal after years of using js I still don't trust that automatic type casting ;)

fuchs777 · Accepted Answer · 2014-09-30 11:06:43Z

2

you set usNumberFormat false, the sorter should then expect numeric values like 430,95... either change your values to use "," as decimal separator or use

usNumberFormat : true

answered Sep 30, 2014 at 11:06

fuchs777

1,0021 gold badge15 silver badges32 bronze badges

Comments

Barry · Accepted Answer · 2014-09-30 10:51:00Z

0

Can't you convert the values a and b to floats with parseFloat before doing any calculation or comparison?

a = parseFloat(a);
b = parseFloat(b);

answered Sep 30, 2014 at 10:51

Barry

3,7331 gold badge20 silver badges25 bronze badges

Collectives™ on Stack Overflow

JQUERY Tablesorter not sorting numeric columns correctly

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related