Not able to use thousands separator In copy paste functionality for Numeric type of cell

Tags: #<Tag:0x00007efc6d724050>
#1

Hi Team,

Is it possible to use the thousands separator in the editor for numeric cell. Actually when I copy paste the numeric values as per the below ( included thousands separator “,”) from excel to Handsontable grid:

5,000
2,500
3,700

After paste values populated in numeric cell as per the below:

5
2.5
3.7

It replace the “,” with “.”

I have used below configuration for Numeric column:
{
data: ColumnName ,
type: ‘numeric’,
numericFormat: {
pattern: ‘0,0’,
culture: ‘en-US’
}
}

Can you please help me to resolve this issue?

Thanks!

#2

Hi @ketan.navadiya

This is an issue about this topic from our repo - https://github.com/handsontable/handsontable/issues/4396

It might give you an insight of reason our default behaviour.

#3

Hi @piotr.nowak,

Could you please let us know when will the fix of this open issue release?

Thanks!

#4

Honestly, we don’t plan in the nearest future work on this.

You could check our demo with a workaround - http://jsfiddle.net/ca3mn15y/
Unfortunately, the validator doesn’t work well.

#5