XF 1.5 How to copy and paste Excel Spreadsheets?

[T Money]

Hi all,
I am trying to create a thread using tables from Excel. When I copy the tables and try to pate on to XF, it does not transfer any table formatting, rather just disorganized text gets pasted. And I also noticed I cannot attach excel files.

Any advise?

 

[Brogan]

You will need table bb code in order to create tables.
Even then you won't just be able to copy and paste.

You can allow the attachment type in the options in the ACP.

 

[T Money]

Thanks Brogan,

I frequently use excel files and want to show it on the thread. Not as a picture (jpeg/png) but as text. Does not necessarily have to be in tables, but do want to show in correct alignment as columns and rows.

Do you have any suggestions on how to go about this?

 

[Brogan]

You can try using the code tags.

I'm not sure if doing so will faithfully retain the layout.

 

[James]

If you frequently use spreadsheets might it not be worthwhile integrating with Google docs and embedding that way?

 

[T Money]

If you frequently use spreadsheets might it not be worthwhile integrating with Google docs and embedding that way?

Would you be so kind and explain how to do this?

 

[T Money]

Found a example of table in Xenforo: how was this accomplished?

http://diecastcrazy.com/threads/raceweek-thunder-15-current-standings.139631/

 

[T Money]

Is this add-on still good to try?

https://xenforo.com/community/resources/tinymce-quattro-and-its-wysiwyg-bbcodes.1881/

 

[Brogan]

There are several resources - I personally haven't used that one.

I use this one on my site: https://xenforo.com/community/resources/cta-table-bb-code.2847/

 

[T Money]

Looks a little complicated... like it involves more than just simple copy/paste from excel?
So does this mean all XF forums out there don't allow regular members to copy/paste tables on posts?

 

[Brogan]

Correct.
It requires bb code or some other custom solution.

 

[Alfa1]

You can start a suggestion thread to get the function implemented. Ifcenough people like it then it will be considered.

 

[James]

Would you be so kind as to explain how to do this?

https://en.support.wordpress.com/google-docs/

That shows you how to embed a spreadsheet. You will need to create a bbcode so it may be worth creating a [gdocs] which basically uses the embed code but requires the ID part of the URL (i.e. the bit after the /document/d).

 

[racersimage]

Found a example of table in Xenforo: how was this accomplished?

http://diecastcrazy.com/threads/raceweek-thunder-15-current-standings.139631/

That is from my forum. I use an addon that allows you to copy/paste a table. Extremely simple but unfortunately that developer is no longer allowed here and no other developer has come up with the same solution.

 

[T Money]

That is unfortunate, I can really a easy and simple add-on. I've tried bbcode add-on but it's not perfect.

 

[Wesker]

I also need a mod like this. Willing to pay premium.

 

[Bryan Gilchrist]

Just use an HTML bbcode and export it as HTML from Excel.

 

[Wesker]

HTML BB Code mod for this?

 

[Wesker]

So you're saying

Excel save as html file
Then copy html file into xF posts via a html bb code mod?

 

[Bryan Gilchrist]

That should do the trick.