Pasting from Excel, inconsistent ###### value

Steps to replicate:

  1. Set a date in an excel cell, for example: 15/01/2025
  2. Manually adjust the column width, until the cell is narrower than the value, and displays as hashes, like ########
  3. Click the cell once, and copy (ctrl + c)
  4. Go to the hands on demo - Data grid demo - Handsontable data grid for JavaScript, React, Angular, and Vue.
  5. Click the the first date entry cell
  6. Paste (ctrl + v), observe that ######## is pasted.
  7. Double click the next date entry cell below (cell becomes an input)
  8. Delete the existing value
  9. Paste (ctrl + v), observe that 15/01/2025 is pasted.

How does the correct value come through when pasting to the input, but only the hashes when pasting to the cell selection?

Please note, we didn’t observe the behavior in Handsontable 1.4.1, the correct value is always pasted, we’re now trying to achieve this in the latest version of Handsontable, is there a config for this?

Hi @Jamie

Thank you for contacting us. This is most likely connected to the current architecture of our copy/paste plugin. There was a similar question reported on our GitHub some time ago: how do I copy ## data from excel? · Issue #9597 · handsontable/handsontable · GitHub

I described the reason for this behavior here: how do I copy ## data from excel? · Issue #9597 · handsontable/handsontable · GitHub