I have implemented a very elegant solution for the sorting of formatted numbers problem! Update 2.37.0 adds a new checkbox for every column that parses the formatted number as a number in the background to sort that list correctly.
This logic is very smart that it can recognises almost all ways to format a number up to 2 decimals. For example:
“$333.722,42” currency symbol, dot as thousand separator and comma as decimal separator.
“$333,722.42” currency symbol, comma as thousand separator and dot as decimal separator.
Even the sentence: “The total is: $333.722,42 dollar” works
Example:
Don’t forget to refresh your editor after upgrading