Copy text into numerical column

Tags: #<Tag:0x00007f51b5a825b0> #<Tag:0x00007f51b5a823d0>
#1

Hi

I would like to copy some of the number copy from Excel into handsome table like “1,100” into a numerical cell. However, HOT auto translate this into 1.1 for some reason. Is there a way to prevent HOT from auto translate this ?

https://jsfiddle.net/c4f0o9wq/ Here is a example

best

#2

Hi @haoliu

To achieve that you need to set the numeric format pattern. I modified your example by adding this config:

  const numFormat = {
  	pattern: '0,0.000',
  }

Here’s an example: https://jsfiddle.net/sLokz7wc/1/