Copy values with spaces from Handsontable to Excel

Tags: #<Tag:0x00007f249c7c6c90>

I found some strange issue when I copy data from handsontable grid to Excel, Excel replaces white space (char 32) with non breaking space (char 160).

For example, if I copy “United States” from the grid in the demo:
The white space between word is char 32. But once I paste it into Excel, the white space becomes char 160.



This is an interesting case. I’ll investigate it and come back to you after the weekend.


I’ve found the reason for this behaviour, however, there’s not really much we can do about it. The reason is that Excel paste the copied value as text/html instead of text/plain and that is causing the change in the characters.

1 Like