Pasting from spreadsheet won't work if corner cell is empty

AI-generated summary

A user, rizka, has reported a UX issue with pasting data from a spreadsheet into Discourse when the top-left or bottom-right corner cell is empty. To reproduce the issue, follow these steps: enter data into a spreadsheet, copy and paste into Discourse (which works if all cells have data), clear the corner cell, then try copying and pasting again (which fails). A workaround exists by filling the empty cell, copying, pasting, and then clearing the cell again.

codinghorror has acknowledged the bug and proposed assigning it for the next week. kris.kotlarek has since fixed the issue, which will be included in the next release, as demonstrated in this pull request.

I don’t think I’ve reported this UX issue before, but it’s been there for years now. It sometimes affects you when you copy data from a spreadsheet to import it as a table onto Discourse. Steps of reproduction:

  1. Enter some data on a spreadsheet.
  2. Copy and paste it to Discourse.
  3. Works :white_check_mark:.
This works perfectly
What a lovely
feature this is.
  1. Go back to spreadsheet.

  2. Clear the top-left corner cell or the bottom-right corner cell.

  3. Copy and paste it to Discourse.

  4. Won’t work. :x:

    works perfectly
    What a lovely
    feature this is.

I ran into this once again today when I downloaded some data from a web page into Excel and then was trying to paste it to our site. There is an easy work-around: fill something into the empty square, copy-paste and clear the cell again on Discourse end.

works perfectly
What a lovely
feature this is.

I would like this fixed anyway since it still confuses me for a second every time it happens! And frankly, you can’t educate your users about such niche scenarios, but it really disrupts you when you run into it for the first time.

6 Likes

Looks like a valid bug to me, I think we should assign it next week @sam

6 Likes

Thank you for reporting that bug, it is fixed and improvement will be included in next release.

https://github.com/discourse/discourse/pull/11163

Demo:

a b
1 2
10 Likes