Sort numbers and letters incorrectly

Tags: #<Tag:0x00007f8b2b0caa40>
#1

Good morning
I have a problem with sort.
This is my Code:
columnSorting: {
indicator: true,
sortEmptyCells: true,
initialConfig: {
column: 1, // deve essere assolutamente un numero
sortOrder: ‘asc’
}
},

I want sort following ascii code.
The sort is wrong.

Immagine.jpg889×402 19.7 KB

Why 00 is before all.
I want this sequence of sort:

//
00
my text

What am I do to have the right sort ?
Best regards

#2

Hey @crepuscolog

if you’re using the latest version then this is the code https://jsfiddle.net/doum02yk/

Why 00 is before all.

We are using browser sorting logic. We did not change it.

#3

Good morning
So is not possible to have the ascii sorting sequence ?
In my case I wish:
1st position: #
2nd position: //
3rd position: 00
4th position: my text

Is this possible ? How ?
Thanks
Regards

#4

You’d need to use our multiColumn Sorting plugin (src: https://handsontable.com/docs/6.2.2/demo-multicolumn-sorting.html) there’s a Extended plugin configuration section where you have compareFunctionFactory it allows to set custom sorting order.

#5