Excel copy paste from currency or accounting format

Tags: #<Tag:0x00007efc6deb8078>
#1

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

http://jsfiddle.net/e3rq1sga/

Performing copy and paste from Excel results in wrong display of data
#2

Hey @christopher.renaud

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

#3

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

#4

Great to hear :wink:

#5