Formatting numbers using DataTables breaks sorting

Question

I have a tables that I am trying to sort, the problem is that when I add locales to the numbers, it breaks sorting, it sorts as it were strings.

I followed this answer and I modified without having to use regex, but then it begins sorting as it were strings and no longer numbers, for instance

1
1.200
2

$(document).ready(function () {
    $('.my_table').DataTable({
        "bProcessing": true,
        "bPaginate": true,
        "bDestroy": true,
        "bShowPollInfo": false,
        "iDisplayLength": 20,
        "aLengthMenu": [[20, 40, -1], [20, 40, "_all"]],
        "sScrollX": "100%",
        "aoColumns": [
            { "sWidth": "160px", "sClass": "nowrap" },
        ],
        "aoColumnDefs": [
            {
               "mRender": function (data, type, row) {
                   return formatNumbers(data);
               },
               "aTargets": [1, 2]
            },
        ],
    });
});
function formatNumbers(val) {
    return parseInt(val).toLocaleString("de-DE");
}

Your formatNumbers() function explicitly returns a string; what did you expect to happen? Also, if you really have numbers with fractional parts, you should not be using parseInt() on the values. (If they start out as numbers, then you don't need to "parse" them at all anyway.) — Pointy
– Pointy, Commented Feb 2, 2022 at 16:28

ruleboy21 · Accepted Answer · 2022-02-02 18:03:12Z

1

Change the "aoColumnDefs" part to this

"aoColumnDefs": [
    {
       "mRender": function (data, type, row) {
            if( type === 'display' ){
                return formatNumbers(data); // only format the data for display
            }else{
                return data; // the default data should be used for sorting
            }
       },
       "aTargets": [1, 2]
    },
],

answered Feb 2, 2022 at 18:03

ruleboy21

6,5215 gold badges23 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Formatting numbers using DataTables breaks sorting

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related