Sort problem

[te-deum]

Hello,

I am using this plugin and notice some problems on sorting.

Here is an example :

• Values : ['9320', '4110', '48BOX-K', '10009']
• Expected result : ["10009", "4110", "48BOX-K", "9320"]
• Result from plugin : ["48BOX-K", "4110", "9320", "10009"]

The problem come from the sort function inside filteredRows function :

        // sort rows
        var collator = new Intl.Collator(undefined, {
-->         numeric: true,
            sensitivity: 'base',
        });
        const sortOrder = currentSortDirection.value === 'desc' ? -1 : 1;

        rows.sort((a: any, b: any): number => {
            const valA = currentSortColumn.value?.split('.').reduce((obj: any, key: string) => obj?.[key], a);
            const valB = currentSortColumn.value?.split('.').reduce((obj: any, key: string) => obj?.[key], b);

            return collator.compare(valA, valB) * sortOrder;
        });

Option numeric to true in Intl.Collator options is the origin of the problem. Initialize this to false change the sort order to the expected result. It may be better to set this option to true only when column.type === 'number'

        // sort rows
        var collator = new Intl.Collator(undefined, {
            numeric: props.columns.find(col => col.field == currentSortColumn.value)?.type === 'number',
            sensitivity: 'base',
        });

Regards.

[bhaveshpatel200]

Hi te-deum,

Above issue has been solved in new version 1.1.4.