Sorting problem with comma number column

Tags: #<Tag:0x00007efc64df35d8>
#1

Excuse me, May I ask you for the question? The question is about sorting problem with comma number column, The follwoing picture shows the comparison chart of the sorting results of Handsontable and excel, But the excel result shows the correct sort, the handsontable result seems has sorting problems , So i want to know the reason. Thanks a lot

{data:‘posAmount’,className: ‘custom-cell’,type:‘numeric’}

image
image.png508×629 123 KB

#2

Hi @kamizono_naoya

I do not see pattern added for your numeric column. Here https://jsfiddle.net/o65y29gs/3/ is a demo with the thousand comma separator added. At the moment, it seems that your data contains commas and is not recognized as numbers. Numeric data can only contain dits for decimals.

47

#3

The problem has been solved.
thank’s very much.

#4

I’m glad to hear that. Thank you for the update.
If you would need anything more than that please feel free to create a new topic or message us at support@handsontable.com

#5