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

Tags: #<Tag:0x00007f0b0e8e9548>

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!

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.

Hi @piotr.nowak,

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

Thanks!

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.