[Bug-15644]Table sorting not working on numeric columns

Currently running an 8.0.7 nightly from earlier this month.

When sorting on a render: number column (where the data in the data source is definitely numeric), the sort seems to go by lexicographic ordering. Screenshots of ascending/descending sorts below:

1 Like

What is going on with this bug? It affects both integer and float columns.

1 Like

We are aware of the issue and have an open ticket to fix the sorting, though there is no time estimate for when the ticket will be begun.

1 Like

Any updates on when this might be getting fixed?

This is still happening. However, it seems like setting the column’s numberFormat to none fixes the sorting temporarialy. Probably only works well on integer-valued columns though.

@cmallonee I am still seeing this on 8.0.15.
Any time estimate on resolution for this?

No, the prioritization of that ticket has resulted in it staying more or less in limbo as we address other issues.

Thanks for keeping us updated. I’m really surprised that this bug has been going on for this long. I really needs to be fixed. But, I know its probably out of your control. I’m powerless as well but can only complain on this forum.

I will say that the poster above is correct, it appears that when you set the numberFormat to none, it sorts better

Any chance this has been fixed in 8.1?

No. We’ll update this post when it is resolved.

1 Like



As mentioned in a post above, setting numberFormat to “none” does appear to fix the issue, but it would be nice if this works by default whenever the render format is set to “number”.


I’m noticing that numberFormat none fixes the issue and then a script transform where I round the values can set the format in a round-a-bout way.

For anyone following this issue, according to our internal ticket for this, this should be fixed as of 8.1.6.