Excel copy paste from currency or accounting format

Tags: #<Tag:0x00007fd2bf1a7518>

Hi there,

Any thoughts on how to allow copy/paste from the currency or accounting format in excel? When I paste its throwing a validation error on numeric columns. Example below:

Copy and paste any currency into format info the jsfiddle below and you’ll see the red highlight


Hey @christopher.renaud

you’d need to remove the comma. Handsontable treats this like a string. You can add it (via custom renderer) afterwards.

Got it! Thanks for the idea, we’ve added a hook to replace the commas and its working well.

Great to hear :wink: