When sorting a type:"text" column, and the first row is a number eg "911", it crashes about kingtable

[RobertoPrevato]

Hi @binary64, thanks for your kind words and for the heads up! I am taking a look at this bug right now - I write again once it's fixed.

[RobertoPrevato]

@binary64, I fixed the bug (was a silly mistake), please download again the library and let me know if I can close this issue. :)

[binary64]

Hi many thanks for the update. I have tried the update, but it's worse. It's sorting based on the number within the string, but not the whole string itself, eg:-

Reno911
42-Universe
7_Ducks
X2
A1

[RobertoPrevato]

Hi again,
Please change this configuration, to obtain the desired result:

KingTable.ArrayUtils.options.autoParseNumbers = false;

I made this configurable (and default) because other people were recommending the opposite: for example they were returning amounts of money together with currency ("100.30 PLN", "1000 PLN", "200 PLN") or percentages ("10%", "50%", "100%") and were expecting the sorting function to sort using the number within the string. In the first version of the library I shared your same point of view, and expected that strings should be sorted like strings, numbers like numbers - but speaking with many people I found that both points of view make sense. The piece of code responsible of this thing is here.