Pasting into the title field from a spreadsheet cell causes new table block to be created

[bhkh]

How to recreate

1. Add new page
2. from spreadsheet (external program like libre office) copy the contents of a cell that is to become the page title
3. Paste (using ctrl-v or ctrl-shift-v) into the page title field on the new page

Expected Result: text of the copied cell would become the title of the page.

Actual Result: Instead of pasting the text of the cell (as it had done prior to 5.5) it skips away from the title title field and instead creates a one cell "table" block on the body of the page. Title field remains empty.

I'm absolutely sure this started with 5.5. My process to create posts always takes the title from a spreadsheet cell.
I have tried with all plugins disabled on TwentyTwenty.
I posted about this issue here and someone else was able to recreate: ​https://wordpress.org/support/topic/copy-from-spreadsheet-cell-into-page-title-does-not-work/#post-13408178

[sabernhardt]

Hi @bhkh and thanks for the report!

I can confirm that the behavior has changed since 5.4. With WordPress 5.4.2, using Ctrl-V to paste a cell from an Excel spreadsheet into the title block pastes the contents of the cell without formatting into the title. Now it creates the separate table block in 5.5.1.

[sabernhardt]

It seems to be related to this change:
​https://github.com/WordPress/gutenberg/pull/21758

Also, I can use Ctrl-Shift-V to paste as plain text within a paragraph block, but it does not paste at all for me in the title block.

[bhkh]

Replying to sabernhardt:

It seems to be related to this change:
​https://github.com/WordPress/gutenberg/pull/21758

Oh, that's interesting. That kind of functionality seems like it is just asking for trouble. Why would someone paste a whole document into the title field? Any way, thanks for looking into this!! My first bug report.

[bhkh]

It's not directly related to this bug, but it seems like Gutenberg is trying extra hard to guess what it is that we want. I just noticed that it is impossible to paste a block of pure text that begins with a number into a paragraph bloc without it turning into a numbered list.

[sabernhardt]

For the number formatting, "1 is the loneliest number" should remain as plain text within a paragraph or heading block. However, adding a period and space for "1. first step" is a popular ​Markdown shortcut to turn that text into an ordered list.

[sabernhardt]

I moved this report to GitHub so the Editor team can handle it there.
​https://github.com/WordPress/gutenberg/issues/27219

If you have anything to add, please comment on that issue.