Page 1 of 1
Excel Copy/Paste
Posted: November 4th, 2010, 8:56 pm
by AGinNEIowa
on the Scout board, I used to be able to copy data cells from Excel and paste it directly into the message body. Here it doesn't work.
any suggestions? Pick'em Standings will be a major pain, if I have to go through the table process for a table with 30 people and up to 15 weeks...
Re: Excel Copy/Paste
Posted: November 4th, 2010, 8:58 pm
by treesap32
Screenshot of the excel sheet as .jpg then uploaded? That's what I've done on other PHPBB boards in the past...
Re: Excel Copy/Paste
Posted: November 4th, 2010, 9:15 pm
by ProvoAggie
There is an add-on for phpBB that will allow you to attach XLS files to your post and have them appear as tables in your post. I will work on installing it and see how well it works. Would that make it easier?
Re: Excel Copy/Paste
Posted: November 4th, 2010, 9:52 pm
by AGinNEIowa
ProvoAggie wrote:There is an add-on for phpBB that will allow you to attach XLS files to your post and have them appear as tables in your post. I will work on installing it and see how well it works. Would that make it easier?
YES!
also notice no "Quick Reply" in this forum.
Thanks ProAg (can't stand to even type the city name!)
Re: Excel Copy/Paste
Posted: November 4th, 2010, 10:04 pm
by ProvoAggie
AGinNEIowa wrote:Thanks ProAg (can't stand to even type the city name!)
At least you don't live there...also, Quick Reply is here now.
Re: Excel Copy/Paste
Posted: November 4th, 2010, 11:57 pm
by BigBlueDart
This would be great. BBCode tables are kind of tough if they get very big.
Re: Excel Copy/Paste
Posted: November 5th, 2010, 7:35 am
by ProvoAggie
I guess you didn't see the other post. You can actually do HTML tables now and they don't have to be contained on 1 row. The only HTML tags allowed on the site are table, th, tr, and td.
Re: Excel Copy/Paste
Posted: November 5th, 2010, 7:56 am
by AGinNEIowa
I don't know any html, and was trying to use the example you posted in the other thread, it took me 10 min to figure out 3 lines. With 30 weekly participants in Pick'em, I just don't have that much time to enter a table for standings.
Re: Excel Copy/Paste
Posted: November 5th, 2010, 9:38 am
by BigBlueDart
BBCode and HTML are both a bit tedious to do large tables by hand. I might be able to write a macro, but if cutting and pasting excel spreadsheets was an option it could help.
I'm sure we'll all be fine, regardless. Don't let yourself get too bogged down by all the suggestions. The site is absolutely fantastic!
Re: Excel Copy/Paste
Posted: November 5th, 2010, 11:08 am
by ProvoAggie
I have installed the module to show Excel files inline and it appears to work pretty well. There are a few things to note. It does remove all formatting from the document so it shows a plain table. The files have to be .xls files...if you made them with Excel 2007-2010, save them as an Excel 97-2003 file. Also, If it's a big document, it will have a scrollbar. This should make posting tables quite a bit easier...especially for those of you that are coming from Excel files to begin with.
Re: Excel Copy/Paste
Posted: November 5th, 2010, 1:23 pm
by AGinNEIowa
so it's a file attachment, not copy/paste? I guess I'll have to change my process.
Re: Excel Copy/Paste
Posted: November 5th, 2010, 1:29 pm
by ProvoAggie
It is just an attachment. It will be a bit different but it shouldn't be too difficult. The biggest difference between scout and here is that they have a WYSIWYG editor that converts things to HTML. By allowing HTML, you open the door for security problems and so phpBB doesn't support it.
Re: Excel Copy/Paste
Posted: November 15th, 2010, 9:43 am
by treesap32
I found a very useful site for those of us who like to post formatted date (tables). This site will let you paste in comma or tab separated input and will automatically put it into HTML table format for you.
http://www.bagism.com/tablemaker/
Now if we could just figure out how to get rid of that blasted spacing before the tables....
Re: Excel Copy/Paste
Posted: November 15th, 2010, 10:10 am
by BigBlueDart
treesap32 wrote:I found a very useful site for those of us who like to post formatted date (tables). This site will let you paste in comma or tab separated input and will automatically put it into HTML table format for you.
http://www.bagism.com/tablemaker/
Now if we could just figure out how to get rid of that blasted spacing before the tables....
You need to put all the code on one line. Maybe go ahead and us the automatic table generator and then go back and manually remove all the carriage returns and extra white space.
Re: Excel Copy/Paste
Posted: November 15th, 2010, 10:29 am
by ProvoAggie
It doesn't have to be all on one line but right now you can't have any space at the beginning of a row. What is happening is phpBB is putting a <br /> in after each line...and because you can't have a break in between 2 columns they all appear above the table. I have some code in to remove it but for some reason it is failing when there are spaces at the beginning of the new rows. I'm trying to figure out why right now and hopefully it will be fixed soon.
Re: Excel Copy/Paste
Posted: November 15th, 2010, 10:38 am
by treesap32
ProvoAggie wrote:It doesn't have to be all on one line but right now you can't have any space at the beginning of a row. What is happening is phpBB is putting a <br /> in after each line...and because you can't have a break in between 2 columns they all appear above the table. I have some code in to remove it but for some reason it is failing when there are spaces at the beginning of the new rows. I'm trying to figure out why right now and hopefully it will be fixed soon.
I see. Thanks for fixing it.
I just went in the sandbox and tested it and now I see what you mean.
The following code works fine by the way for BBD to see: (I added a "." so it wouldn't process the table).
Code: Select all
<.TABLE BORDER=1>
<.TR>
<.TD>Date <./TD>
<.TD>Season <./TD>
<.TD>Opponent <./TD>
<.TD>Home/Away <./TD>
<.TD>Win/Loss <./TD>
<.TD>Score <./TD>
<.TD>Game Type <./TD>
<.TD>Attendance<./TD>
<./TR>
<.TR>
<.TD>2009-12-16<./TD>
<.TD>2009-10<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>A<./TD>
<.TD>W<./TD>
<.TD>68-51<./TD>
<.TD>Non-Conference<./TD>
<.TD>4481<./TD>
<./TR>
<.TR>
<.TD>2009-02-18<./TD>
<.TD>2008-09<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>H<./TD>
<.TD>W<./TD>
<.TD>78-57<./TD>
<.TD>Non-Conference<./TD>
<.TD>8189<./TD>
<./TR>
<.TR>
<.TD>2007-12-08<./TD>
<.TD>2007-08<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>A<./TD>
<.TD>W<./TD>
<.TD>88-66<./TD>
<.TD>Non-Conference<./TD>
<.TD>1739<./TD>
<./TR>
<.TR>
<.TD>2006-12-30<./TD>
<.TD>2006-07<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>H<./TD>
<.TD>W<./TD>
<.TD>65-49<./TD>
<.TD>Non-Conference<./TD>
<.TD>8049<./TD>
<./TR>
<.TR>
<.TD>1977-01-04<./TD>
<.TD>1976-77<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>H<./TD>
<.TD>W<./TD>
<.TD>110-89<./TD>
<.TD>Non-Conference<./TD>
<.TD>6522<./TD>
<./TR>
<./TABLE>
This code doesn't work because of the spaces before each <TD>:
Code: Select all
<.TABLE BORDER=1>
<.TR>
<.TD>Date <./TD>
<.TD>Season <./TD>
<.TD>Opponent <./TD>
<.TD>Home/Away <./TD>
<.TD>Win/Loss <./TD>
<.TD>Score <./TD>
<.TD>Game Type <./TD>
<.TD>Attendance<./TD>
<./TR>
<.TR>
<.TD>2009-12-16<./TD>
<.TD>2009-10<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>A<./TD>
<.TD>W<./TD>
<.TD>68-51<./TD>
<.TD>Non-Conference<./TD>
<.TD>4481<./TD>
<./TR>
<.TR>
<.TD>2009-02-18<./TD>
<.TD>2008-09<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>H<./TD>
<.TD>W<./TD>
<.TD>78-57<./TD>
<.TD>Non-Conference<./TD>
<.TD>8189<./TD>
<./TR>
<.TR>
<.TD>2007-12-08<./TD>
<.TD>2007-08<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>A<./TD>
<.TD>W<./TD>
<.TD>88-66<./TD>
<.TD>Non-Conference<./TD>
<.TD>1739<./TD>
<./TR>
<.TR>
<.TD>2006-12-30<./TD>
<.TD>2006-07<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>H<./TD>
<.TD>W<./TD>
<.TD>65-49<./TD>
<.TD>Non-Conference<./TD>
<.TD>8049<./TD>
<./TR>
<.TR>
<.TD>1977-01-04<./TD>
<.TD>1976-77<./TD>
<.TD>Cal State Bakersfield<./TD>
<.TD>H<./TD>
<.TD>W<./TD>
<.TD>110-89<./TD>
<.TD>Non-Conference<./TD>
<.TD>6522<./TD>
<./TR>
<./TABLE>
A quick Find & Replace in notepad did the job.
Re: Excel Copy/Paste
Posted: November 15th, 2010, 10:54 am
by ProvoAggie
It should be fixed now. You are able to have up to 5 spaces on the beginning of a row. If you have more than that then it may or may not have spaces.
Re: Excel Copy/Paste
Posted: November 15th, 2010, 11:07 am
by BigBlueDart
Okay, I see what my issue was before. Thanks!
Re: Excel Copy/Paste
Posted: November 15th, 2010, 11:08 am
by treesap32
WooHoo!! it's working!
That Table Maker page should be a good resource now.
