Is there a cell data type that is “integer” and would allow sorting of values that may contain “thousands” separators? E.g., suppose rows have “123”, “456”, and “6,789” When defining these as txt types and using the column sort feature, the rows are not necessarily sorted numerically.
There is no such special sorting type , but you can
a) create custom sort function, and assign it to the column in question ( pro only )
or
b) provide pure numbers as grids data and use edn or ron column type to define decimal and group separators - in such case data will be shown as you wish , and in same time API of grid will be able to access raw numbers and use them for sorting.
Thanks for this information. Subsequent to my post I moved the sorting to the server side, so it there becomes an easy issue to address.