Copy & Pasting Googlesheets Tables is Buggy

[casportpony]

When I copy and paste this:
https://docs.google.com/spreadsheets/d/1YvefBx9UaONzC8u35_dEe3LP79Vs5cZ1w-1l9Z6WHRM/edit?gid=0#gid=0

I get this:

Spoiler

Orange or chocolate Hostess cupcakes!? (Never seen vanilla.)

What animal do you hate the most/is your least favorite?

How do you react (internally and externally) when someone pets your dog without asking?

[td]
648

[/td][td]
09/22/2025

[/td]​

[td]Question of the Day - Monday, September 22nd, 2025[/td]

[td]
649

[/td][td]
09/23/2025

[/td]​

[td]Question of the Day - Tuesday, September 23rd, 2025[/td]

[td]
650

[/td][td]
09/24/2025

[/td]​

[td]Question of the Day - Wednesday, September 24th, 2025[/td]

It used to work like all of the posts here in the Past Questions of the Day Thread

 

[casportpony]

It behaves the same at Xenforo:

 

[casportpony]

There is a Xenforo thread about it here:

Unable to paste from spreadsheet​

 

[casportpony]

If I select all, remove formatting, toggle BB code, then manually remove RIGHT, COLOR, and U, I get what I expect.

648	09/22/2025	Question of the Day - Monday, September 22nd, 2025	Orange or chocolate Hostess cupcakes!? (Never seen vanilla.)
649	09/23/2025	Question of the Day - Tuesday, September 23rd, 2025	What animal do you hate the most/is your least favorite?
650	09/24/2025	Question of the Day - Wednesday, September 24th, 2025	How do you react (internally and externally) when someone pets your dog without asking?

 

[casportpony]

But this is cool:

 

[casportpony]

Bumping this. @Nifty-Chicken, can you look into this?
https://xenforo.com/community/threads/unable-to-paste-from-spreadsheet.223298/post-1760860

 

[Nifty-Chicken]

Ya, I've got that on my list. I was told that the core XF update would include it, so I'm hoping that will happen before too long.

 

[casportpony]

Ya, I've got that on my list. I was told that the core XF update would include it, so I'm hoping that will happen before too long.

I use paste tables every day, and sometimes doing the manual edits can add 30-60 minutes, depending on how many I copy and paste.

Yesterday, I ran into a new bug with pasting tables that I will try to reproduce. If I had tried to edit that one table, it would have taken me a really long time because it inserted several extra items into every cell!

 

[casportpony]

Yesterday, when I copied and pasted something into a post that already had a table:

Spoiler: Existing Post and its BB Code

I copied:

Pasted:

Selected all and removed formatting:

It added right, U, and color to almost every cell:

When copying and pasting to a new post, or one without a table, it only adds that stuff to the last table row, like this:

 

[Nifty-Chicken]

Ya, it's definitely frustrating when the tables don't render correctly.

I'll see what we can do to get it fixed.