tables testing

[YinnarTiger]

I'm having similar problems with the Last Man Standing sheet (Excel). I've used a direct screenshot of the sheet in the thread.

Posting direct from the sheet, the rows and columns get variously messed up according to what the cells contain.

 

[Baloo]

I've found this site that might help until it's fixed

Convert Excel to BBCode Table Online - Table Convert Online

Effortlessly convert Excel (or other spreadsheets) to BBCode Table. Utilize the Table Editor to create and modify BBCode Table online.

tableconvert.com

It will take a simple copy/paste of Excel or Google Sheets then convert to bbCODE. Formatting isn't great but at least the columns line up

 

[Mr T.]

TESTING...

As per Xenforo standards, the tags should be formatted as follows¨

td1

td2

td3

Copy-Paste of @Baloo table text...

47

72

Brisbane Lions

Collingwood

Geelong

Gold Coast

48

74

2

Carlton

Gold Coast

49

74

0

50

77

1

St Kilda

51

78

0

52

83

1

Melbourne

53

84

0

54

98

0

[td]
4
[/td]

This is copy-paste from a previous post, and it seems to work...

Round				2016 Result			2016		2015		2014		2013
R1 v Carlton							1-0		1-0		0-1		1-0
R2 v Collingwood							1-1		1-1		1-1		2-0
R3 v Adelaide							1-2		2-1		1-2		3-0
R4 v West Coke Eagles							1-3		2-2		1-3		3-1

Copy-paste from Excel...

[td width="65pt"]header[/td][td width="12.5542%"]header[/td][td width="65pt"]header[/td][td width="65pt"]header[/td][td width="65pt"]header[/td][td width="65pt"]header[/td][td width="65pt"]header[/td][td width="12.554%"]header[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td]


Copy-paste from Google Sheets...

Header	Header	Header	Header	Header	Header
text	text	text	text	text	text
text	text	text	text	text	text
text	text	text	text	text	text
text	text	text	text	text	text
text	text	text	text	text	text
text	text	text	text	text	text
text	text	text	text	text	text
text	text	text	text	text	text

 

[Mr T.]

@Baloo @YinnarTiger mixed results, I've sent my test to the dev again.

 

[Baloo]

[td]

CORRECT​

[/td]​

[td]

1​

[/td][td]

2​

[/td][td]

3​

[/td][td]

4​

[/td][td]

5​

[/td][td]

6​

[/td][td]

7​

[/td][td]

8​

[/td]​

[td]

GWS Giants​

[/td][td]

Port Adelaide​

[/td][td]

St Kilda​

[/td]​

[td]

Gold Coast​

[/td]​

[td]

Melbourne​

[/td]​

[td]

West Coast​

[/td]​

[td]

GWS Giants​

[/td][td]

Brisbane Lions​

[/td][td]

Gold Coast​

[/td]​

[td]

Sydney​

[/td][td]

West Coast​

[/td]​

[td]

St Kilda​

[/td]​

[td]

St Kilda​

[/td]​

[td]

GWS Giants​

[/td][td]

Gold Coast​

[/td][td]

West Coast​

[/td]​

[td]

Gold Coast​

[/td][td]

West Coast​

[/td]​

[td]

Carlton​

[/td][td]

St Kilda​

[/td]​

[td]

GWS Giants​

[/td][td]

Collingwood​

[/td][td]

St Kilda​

[/td]​

[td]

West Coast​

[/td]​

[td]

Collingwood​

[/td][td]

Geelong​

[/td]​

 

[Baloo]

GWS Giants	Port Adelaide	St Kilda
Hawthorn	Sydney
GWS Giants	Brisbane Lions	Gold Coast
Geelong	St Kilda
GWS Giants	Gold Coast	West Coast
GWS Giants	Collingwood	St Kilda
Melbourne
Melbourne
Carlton
Sydney	Melbourne
Gold Coast
Sydney	West Coast
West Coast
St Kilda
Melbourne
Richmond	St Kilda	West Coast
Sydney	West Coast
Collingwood	Geelong
West Coast
GWS Giants	Collingwood
Melbourne	West Coast

[td]Correct Teams[/td]

 

[Baloo]

From what I can work out, it seems to have problems with numbers in cells and blank cells. A selection that is text in every cell seems to work.

Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers

 

[dev]

[td width="65pt"]header[/td][td width="12.5542%"]header[/td][td width="65pt"]header[/td][td width="65pt"]header[/td][td width="65pt"]header[/td][td width="65pt"]header[/td][td width="65pt"]header[/td][td width="12.554%"]header[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td] [td]text[/td][td width="12.5542%"]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td]text[/td][td width="12.554%"]text[/td]

 

[Mr T.]

From what I can work out, it seems to have problems with numbers in cells and blank cells. A selection that is text in every cell seems to work.

Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers
Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers	Tigers

Can you share your spreadsheet with me at [email protected] ?

 

[Baloo]

Can you share your spreadsheet with me at [email protected] ?

Done

 

[RoarEmotion]

 

[Mr T.]

#	Player	Pts	Corr	Correct Teams
1	ahyeahnah	71	3	GWS Giants
2	Coburgtiger	75	1	Geelong
3	BrisTiger24	76	2	GWS Giants
4	backpocketplumber	77	3	Western Bulldogs
5	year of the tiger	77	1	Essendon
6	Quickdraw	78	4	GWS Giants
7	DavidSSS	80	2	GWS Giants
8	Letsroar	80	2	Essendon
9	JoMamma	82	4	Collingwood
10	RoarEmotion	84	4	Collingwood
11	bandoftigers	85	3	Essendon
12	The Mole	85	1	West Coast
13	Sammy Cougar	86	2	Essendon
14	IanG	87	1	Essendon
15	JimJessTorp	87	1	GWS Giants
16	Mopsy	87	1	Melbourne
17	mrposhman	87	1	West Coast
18	WotC	87	3	Collingwood
19	tbartiger	89	1	Essendon
20	DeathNinthandTaxes	90	2	Geelong
21	MalenyTiger	90	2	Essendon
22	Brodders17	93	3	Essendon
23	marella jube	93	1	Essendon
24	MD Jazz	93	1	St Kilda
25	Number8	93	1	Geelong
26	Platinum member	93	1	Hawthorn
27	Total Tiger	93	1	Melbourne
28	Baloo	94	0
29	DuD_Delist	94	0
30	larabee	94	2	Essendon
31	wayne	95	1	Essendon
32	toothless	96	2	St Kilda
33	tigertim	97	1	Geelong
34	tigerman	99	1	Sydney
35	YinnarTiger	99	1	West Coast
36	DanMinogue	100	0
37	Freezer	100	0
38	Tigers of Old	103	1	Melbourne
39	Midsy	104	0
40	DjJazzyPete	105	1	Essendon
41	tommystigers	106	0
42	Tiger Ghost	107	1	West Coast
43	Tigaman	108	0
mainlandy	0

[td]

44​

[/td]​

[td]

110​

[/td]​

 

[Mr T.]

#	Player	Pts	Corr	Correct Teams
1	ahyeahnah	71	3	GWS Giants
2	Coburgtiger	75	1	Geelong
3	BrisTiger24	76	2	GWS Giants
4	backpocketplumber	77	3	Western Bulldogs
5	year of the tiger	77	1	Essendon
6	Quickdraw	78	4	GWS Giants
7	DavidSSS	80	2	GWS Giants
8	Letsroar	80	2	Essendon
9	JoMamma	82	4	Collingwood
10	RoarEmotion	84	4	Collingwood
11	bandoftigers	85	3	Essendon
12	The Mole	85	1	West Coast
13	Sammy Cougar	86	2	Essendon
14	IanG	87	1	Essendon
15	JimJessTorp	87	1	GWS Giants
16	Mopsy	87	1	Melbourne
17	mrposhman	87	1	West Coast
18	WotC	87	3	Collingwood
19	tbartiger	89	1	Essendon
20	DeathNinthandTaxes	90	2	Geelong
21	MalenyTiger	90	2	Essendon
22	Brodders17	93	3	Essendon
23	marella jube	93	1	Essendon
24	MD Jazz	93	1	St Kilda
25	Number8	93	1	Geelong
26	Platinum member	93	1	Hawthorn
27	Total Tiger	93	1	Melbourne
28	Baloo	94	0
29	DuD_Delist	94	0
30	larabee	94	2	Essendon
31	wayne	95	1	Essendon
32	toothless	96	2	St Kilda
33	tigertim	97	1	Geelong
34	tigerman	99	1	Sydney
35	YinnarTiger	99	1	West Coast
36	DanMinogue	100	0
37	Freezer	100	0
38	Tigers of Old	103	1	Melbourne
39	Midsy	104	0
40	DjJazzyPete	105	1	Essendon
41	tommystigers	106	0
42	Tiger Ghost	107	1	West Coast
43	Tigaman	108	0

[td]

44​

[/td]​

[td]mainlandy[/td]

[td]

110​

[/td][td]

0​

[/td]​

 

[The_General]

Males	Rating	Metres
Elite	>1120	>22.1
Excellent	880-1120	21.3-22.1
Good	680-840	20.6-21.2
Average	480-640	20.1-20.5
Below Average	240-440	18.2-19.4
Poor	<240	<18.2[TD]

 

[Baloo]

@ahyeahnah	Brisbane Lions	Geelong	Hawthorn	Essendon	Carlton
@MD Jazz	Collingwood	Brisbane Lions	GWS Giants	Port Adelaide
@backpocketplumber	Brisbane Lions	Western Bulldogs
@mrposhman	GWS Giants	North Melbourne
@tbartiger	Collingwood	Brisbane Lions	GWS Giants	Port Adelaide
@JimJessTorp	Brisbane Lions	Port Adelaide
@year of the tiger	Collingwood	North Melbourne
@Freezer	Collingwood	Hawthorn	North Melbourne
@Letsroar	North Melbourne	West Coast
@RoarEmotion	GWS Giants	Western Bulldogs
@DanMinogue
@Midsy	GWS Giants
@Quickdraw	Brisbane Lions
@toothless	Geelong	Hawthorn	Essendon	North Melbourne​
@The Mole	Richmond	North Melbourne
@YinnarTiger	GWS Giants	Richmond
@Mopsy
@DeathNinthandTaxes
WotC
@mainlandy	North Melbourne
@Sammy Cougar	Port Adelaide
@tigerman	North Melbourne
@marella jube	GWS Giants	Port Adelaide
@Number8
@bandoftigers	North Melbourne
@JoMamma	North Melbourne
@DavidSSS	Brisbane Lions	Geelong
@Tigers of Old	Brisbane Lions	GWS Giants
@Tigaman	Geelong	Essendon	North Melbourne
@wayne
@MalenyTiger	Brisbane Lions
@Platinum member	North Melbourne
@tigertim
@Baloo	North Melbourne
@tommystigers	Essendon
@Total Tiger	Hawthorn	Essendon
@DuD_Delist
@larabee
@DjJazzyPete	Hawthorn
@crackajack71
@IanG
@Brodders17	North Melbourne
@Tiger Ghost
@BrisTiger24
@Coburgtiger

[td]

#​

[/td][td]

Player​

[/td][td]

Pts​

[/td][td]

+/-​

[/td][td]

Corr​

[/td]​

[td]Teams[/td]

[td]

1​

[/td]​

[td]

49​

[/td][td]

+1​

[/td][td]

5​

[/td]​

[td]

2​

[/td]​

[td]

50​

[/td][td]

+9​

[/td][td]

4​

[/td]​

[td]

3​

[/td]​

[td]

54​

[/td][td]

+2​

[/td][td]

2​

[/td]​

[td]

3​

[/td]​

[td]

54​

[/td][td]

-2​

[/td][td]

2​

[/td]​

[td]

5​

[/td]​

[td]

56​

[/td][td]

+8​

[/td][td]

4​

[/td]​

[td]

6​

[/td]​

[td]

56​

[/td][td]

-2​

[/td][td]

2​

[/td]​

[td]

7​

[/td]​

[td]

58​

[/td][td]

-2​

[/td][td]

2​

[/td]​

[td]

8​

[/td]​

[td]

61​

[/td][td]

+7​

[/td][td]

3​

[/td]​

[td]

9​

[/td]​

[td]

64​

[/td][td]

+16​

[/td][td]

2​

[/td]​

[td]

9​

[/td]​

[td]

64​

[/td][td]

+10​

[/td][td]

2​

[/td]​

[td]

11​

[/td]​

[td]

64​

[/td][td]

+6​

[/td][td]

0​

[/td]​

[td]

12​

[/td]​

[td]

65​

[/td][td]

+3​

[/td][td]

1​

[/td]​

[td]

12​

[/td]​

[td]

65​

[/td][td]

-1​

[/td][td]

1​

[/td]​

[td]

14​

[/td]​

[td]

66​

[/td][td]

+5​

[/td][td]

4​

[/td]​

[td]

15​

[/td]​

[td]

66​

[/td][td]

+14​

[/td][td]

2​

[/td]​

[td]

15​

[/td]​

[td]

66​

[/td][td]

+15​

[/td][td]

2​

[/td]​

[td]

17​

[/td]​

[td]

66​

[/td][td]

-10​

[/td][td]

0​

[/td]​

[td]

18​

[/td]​

[td]

68​

[/td][td]

+1​

[/td][td]

0​

[/td]​

[td]

18​

[/td]​

[td]

68​

[/td][td]

-13​

[/td][td]

0​

[/td]​

[td]

20​

[/td]​

[td]

69​

[/td][td]

+19​

[/td][td]

1​

[/td]​

[td]

20​

[/td]​

[td]

69​

[/td][td]

-11​

[/td][td]

1​

[/td]​

[td]

20​

[/td]​

[td]

69​

[/td][td]

+9​

[/td][td]

1​

[/td]​

[td]

23​

[/td]​

[td]

70​

[/td][td]

-1​

[/td][td]

2​

[/td]​

[td]

24​

[/td]​

[td]

70​

[/td][td]

-9​

[/td][td]

0​

[/td]​

[td]

25​

[/td]​

[td]

71​

[/td][td]

-16​

[/td][td]

1​

[/td]​

[td]

25​

[/td]​

[td]

71​

[/td][td]

+9​

[/td][td]

1​

[/td]​

[td]

27​

[/td]​

[td]

72​

[/td][td]

-22​

[/td][td]

2​

[/td]​

[td]

27​

[/td]​

[td]

72​

[/td][td]

+2​

[/td][td]

2​

[/td]​

[td]

29​

[/td]​

[td]

73​

[/td][td]

+5​

[/td][td]

3​

[/td]​

[td]

30​

[/td]​

[td]

74​

[/td][td]

-6​

[/td][td]

0​

[/td]​

[td]

31​

[/td]​

[td]

75​

[/td][td]

-2​

[/td][td]

1​

[/td]​

[td]

31​

[/td]​

[td]

75​

[/td][td]

-13​

[/td][td]

1​

[/td]​

[td]

33​

[/td]​

[td]

76​

[/td][td]

+7​

[/td][td]

0​

[/td]​

[td]

34​

[/td]​

[td]

77​

[/td][td]

-9​

[/td][td]

1​

[/td]​

[td]

34​

[/td]​

[td]

77​

[/td][td]

0​

[/td][td]

1​

[/td]​

[td]

36​

[/td]​

[td]

78​

[/td][td]

+6​

[/td][td]

2​

[/td]​

[td]

37​

[/td]​

[td]

78​

[/td][td]

-2​

[/td][td]

0​

[/td]​

[td]

37​

[/td]​

[td]

78​

[/td][td]

-14​

[/td][td]

0​

[/td]​

[td]

39​

[/td]​

[td]

79​

[/td][td]

-10​

[/td][td]

1​

[/td]​

[td]

40​

[/td]​

[td]

80​

[/td][td]

-15​

[/td][td]

0​

[/td]​

[td]

41​

[/td]​

[td]

82​

[/td][td]

-7​

[/td][td]

0​

[/td]​

[td]

42​

[/td]​

[td]

85​

[/td][td]

+2​

[/td][td]

1​

[/td]​

[td]

43​

[/td]​

[td]

86​

[/td][td]

0​

[/td][td]

0​

[/td]​

[td]

44​

[/td]​

[td]

88​

[/td][td]

-3​

[/td][td]

0​

[/td]​

[td]

44​

[/td]​

[td]

88​

[/td][td]

0​

[/td][td]

0​

[/td]​