table paste test

[iusedtoberich]

High Run	Member	Table	FargoRate
wrldpro	9' Rasson Ox
gerard soriano
ZZpop	9' GC
mnorwood	9' Brun. Heritage​
batmmann5	9' GC
DJKeys	8' Diamond
jeagle64	9' Diamond
The_JV	9'
Samiel	8'
Bob Jewett	9' GC
mjantti	9' Predator
RobMan
DaveM	9' GC
krupa	9' GC
dquarasr
Fatboy

[td]

211​

[/td]​

[td]

737​

[/td]​

[td]

100​

[/td]​

[td]

76​

[/td]​

[td]

75​

[/td]​

[td]

69​

[/td]​

[td]

58​

[/td]​

[td]

549​

[/td]​

[td]58 Video[/td]

[td]

49​

[/td]​

[td]

676​

[/td]​

[td]

46​

[/td]​

[td]

598​

[/td]​

[td]

43​

[/td]​

[td]

35​

[/td]​

[td]

35​

[/td]​

[td]

29​

[/td]​

[td]

20​

[/td]​

[td]

15​

[/td]​

[td]

426​

[/td]​

[td]

2​

[/td]​

 

[iusedtoberich]

a	z
b	y
c	z

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

 

[iusedtoberich]

a	z
b	y
c	z

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

 

[iusedtoberich]

@Bob Jewett
Any idea what is going on? I can't paste tables anymore from google sheets. A portion of the table turns into garbage. It does not matter if there are hyperlinks or not. I tried multiple browsers on both the spreadheet and the AZB forum. Before this glitch, pasting tables has been rock solid using google sheets for the past 2 years. (Excel had issues before I switched to Google Sheets).

 

[Korsakoff]

@iusedtoberich, If I make a table in Excel, sometimes I can paste it in, but sometimes it pastes weird. In the latter instance, I paste the table from Excel to Word and Paste Special as a Picture. Then, I just click on the picture in Word and paste it into the AZB post.

 

[iusedtoberich]

num	letter
i
j
k

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

 

[iusedtoberich]

 

[Bob Jewett]

No idea. Well, it might have been a forum update. I think I've seen a recent change or two. I never had a problem pasting from Excel but I haven't tried for a year or two.

 

[iusedtoberich]

Excel kept messing up the hyperlinks to the youtube videos.

@azhousepro was there a recent forum update that messed up pasting tables?

 

[iusedtoberich]

I found this. Looks exactly what's happening here. I'm not a member there, can't interact.

XF 2.3 - Table formatting is not working since update

Hi, users were able to copy and paste from Google Sheets, and the formatting remained... once they submit the post, the formatting is not retained - this includes when they reply to a post with a table.

xenforo.com

 

[iusedtoberich]

The table paste is still not working (across all of xenForo, not just AZB). I searched today on chatgpt and found a workaround. It involves placing a patch in the xenforo code. @azhousepro, is there any chance you can apply the patch safely? Thank you.

XenForo table issue

ChatGPT helps you get answers, find inspiration, and be more productive.

chatgpt.com

 

[Bob Jewett]

The table paste is still not working (across all of xenForo, not just AZB). I searched today on chatgpt and found a workaround. It involves placing a patch in the xenforo code. @azhousepro, is there any chance you can apply the patch safely? Thank you.

XenForo table issue

ChatGPT helps you get answers, find inspiration, and be more productive.

chatgpt.com

This seems to still be broken. Any chance for a fix @azhousepro , Mike?

 

[iusedtoberich]

The workaround I found in Jan was to paste the google sheets data into chatgpt, and ask it to convert for bbcode formatting. I've been using it in the 2026 ghost threads successfully.

 

[Korsakoff]

You can take an Excel table and Paste Special into Word (as Windows Metafile). I save that as a JPG and then post here.

 

[Hungarian]

I might be missing something but..

Couple things I’ve learned. If you highlight the cells you want to paste and then copy them, as long as you keep the xls file open you can paste it as an image.

You can also screen grab and past as image. Nothing gets garbled this way.

Then you can size it bigger or smaller to scale easily

 

[Korsakoff]

You can also print anything in Excel to PDF, open in Photoshop instead of Acrobat Pro, do whatever you want, size it as desired, and save in the desired file format. That’s what I do when the easier paths don’t work out.

 

[iusedtoberich]

Pasting as an image is not nearly as good as pasting as a table. As a table, it is legible, even for large data sets. It also resizes automatically for both desktop browser or mobile as the browser window is resized.

 

[Hungarian]

Pasting as an image is not nearly as good as pasting as a table. As a table, it is legible, even for large data sets. It also resizes automatically for both desktop browser or mobile as the browser window is resized.

On the Seniority List I copy from xls and paste into the thread as an image.

I think it’s pretty good quality?

https://forums.azbilliards.com/threads/the-azb-seniority-thread.570019/page-28

 

[Korsakoff]

In experimentation over the years, I have tried several methods. A plain copy/paste from Excel works well if there is minimal or no formatting. Methods 2 and 3 below work better if the spreadsheet involves formatting. Using Photoshop (or some picture processing software) yields the best result if there is a lot of formatting involved.

Method #1
Copy/Paste table directly from Excel into Post

Cue Maker	Cue	Grams	Ounces	Total As	Wt. Distrib.
Butt	Shaft	Total	Butt	Shaft	Total	Fraction	Butt	Shaft
Richard Black	Bushka	457	125	582	16.12	4.41	20.53	20 1/2	78.5%	21.5%
Led Zeppelin	457	113	570	16.12	3.99	20.11	20	80.2%	19.8%
Scott Gilmore	Classic Maple & Ebony	452	128	580	15.94	4.52	20.46	20 1/2	77.9%	22.1%
Wrapless	464	107	571	16.37	3.77	20.14	20	81.3%	18.7%
Texas	421	117	538	14.85	4.13	18.98	19	78.3%	21.7%
The Classic	459	110	569	16.19	3.88	20.07	20	80.7%	19.3%
Sunburst	403	117	520	14.22	4.13	18.34	18 1/4	77.5%	22.0%
Bob Meucci (Production Cue)	Meucci MO-3	468	98	566	16.51	3.46	19.97	20	82.7%	17.3%
William Ricard	Sneaky Pete	463	114	577	16.33	4.02	20.35	20 1/4	80.2%	19.8%

Method #2
(a) Copy from Excel (b) In Word, Paste Special>Picture (Enhanced Metafile) (c) Copy/Paste that directly into post

Method #3
(a) Copy from Excel (b) Paste into Photoshop from Clipboard using 300 ppi (pixels per inch) (c) adjust size to a 4" width (d) Save as a JPG

Since most things I produce have some or a lot of formatting, I have defaulted to Method #3.

 

[iusedtoberich]

In experimentation over the years, I have tried several methods. A plain copy/paste from Excel works well if there is minimal or no formatting. Methods 2 and 3 below work better if the spreadsheet involves formatting. Using Photoshop (or some picture processing software) yields the best result if there is a lot of formatting involved.

Method #1
Copy/Paste table directly from Excel into Post

Cue Maker	Cue	Grams	Ounces	Total As	Wt. Distrib.
Butt	Shaft	Total	Butt	Shaft	Total	Fraction	Butt	Shaft
Richard Black	Bushka	457	125	582	16.12	4.41	20.53	20 1/2	78.5%	21.5%
Led Zeppelin	457	113	570	16.12	3.99	20.11	20	80.2%	19.8%
Scott Gilmore	Classic Maple & Ebony	452	128	580	15.94	4.52	20.46	20 1/2	77.9%	22.1%
Wrapless	464	107	571	16.37	3.77	20.14	20	81.3%	18.7%
Texas	421	117	538	14.85	4.13	18.98	19	78.3%	21.7%
The Classic	459	110	569	16.19	3.88	20.07	20	80.7%	19.3%
Sunburst	403	117	520	14.22	4.13	18.34	18 1/4	77.5%	22.0%
Bob Meucci (Production Cue)	Meucci MO-3	468	98	566	16.51	3.46	19.97	20	82.7%	17.3%
William Ricard	Sneaky Pete	463	114	577	16.33	4.02	20.35	20 1/4	80.2%	19.8%

Method #2
(a) Copy from Excel (b) In Word, Paste Special>Picture (Enhanced Metafile) (c) Copy/Paste that directly into post

View attachment 899294

Method #3
(a) Copy from Excel (b) Paste into Photoshop from Clipboard using 300 ppi (pixels per inch) (c) adjust size to a 4" width (d) Save as a JPG

View attachment 899295

Since most things I produce have some or a lot of formatting, I have defaulted to Method #3.

Method 1 was not working for 2 years, after working for 10 with no issues. That was the whole point of this thread. I'll try it again see if it works for me.