Column sorting is not working with numbers(formatted like 1,234,45.00)

[rajesh-rk1]

[qwadrox]

@rajesh-rk1 Hi!

It should work. This is what's happening internally: https://github.com/primefaces/primeng/blob/d6c7ffcfc5cb9a8ed355399ddae276c279836ccf/src/app/components/table/table.ts#L1593-L1605

Which PrimeNg version are you using?
Could you create a sample on Stackblitz?

const a = '2,234,45.00';
const b = '1,234,45.00';

console.log(b.localeCompare(a));
console.log(a < b);

> -1
> false

[rajesh-rk1]

@qwadrox I am using "primeng": "~17.8.0".