Copy values with spaces from Handsontable to Excel

Tags: #<Tag:0x00007f249c7c6c90>
#1

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:
https://handsontable.com/demo
The white space between word is char 32. But once I paste it into Excel, the white space becomes char 160.

Thanks!

#2

Hi @SNK

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

#3

Hi @SNK

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