sortingFn: 'alphanumeric' returns numbers last

[jessewriter]

TanStack Table version

8.14.0

Framework/Library version

React 18.2

Describe the bug and the steps to reproduce it

expected behavior is for sorting to put symbols, numbers, followed by letters.

what i see is letters first with numbers last

example.

Amy
Frank
1dude

Your Minimal, Reproducible Example - (Sandbox Highly Recommended)

propriatary code sorry

Screenshots or Videos (Optional)

column def
{
id: stationCode,
accessorFn: (row) => ${row.x}::${row.y}
sortingFn: 'alphanumeric',
}

default sorting def
defaultSorting={[{ id: 'stationCode', desc: false }]}

Do you intend to try to help solve this bug with your own PR?

Maybe, I'll investigate and start debugging

how i solved : sortingFn: (rowA, rowB, columnId) => {
console.log('rowA', rowA.getValue('stationCode'))
return rowA
.getValue('stationCode')
.localeCompare(rowB.getValue('stationCode'), 'en', { numeric: true })
},

Terms & Code of Conduct

• I agree to follow this project's Code of Conduct
• I understand that if my bug cannot be reliable reproduced in a debuggable environment, it will probably not be fixed and this issue may even be closed.

[jessewriter]

interesting when i click the sorting from the header and disable sorting on this column it sorts correctly :/ , that may be because our data is pre-sorted correctly