Home Theater Forum › Home Theater Forum › Feedback and Testing › Forum Help and Feedback › Feedback Archive (Closed Issues) › How do I put up a table or excel sheet so that spacing is preserved
New Posts  All Forums:Forum Nav:

How do I put up a table or excel sheet so that spacing is preserved

post #1 of 12
11/15/04 at 5:14pm
Thread Starter 
I have a list of HTF Gamertags for Halo 2 which I want to put in the Halo 2 thread. It's in an excel sheet with one column as the gamertag, 2nd as HTF name, third has some misc. notes.

How do I put this table, sheet or whatever on the forum so that spacing is preserved. Ideally I'd like the three columns to be that: columns. But every time I try to type or cut-n-paste it into HTF the spacing goes away. I've tried using tabs (doesn't work) and the space bar + a font like courier new. All that does is take away the multiple spaces and so you get a result like this:

Bruin96 Carlo Medina
CanadianKnight Tony Whalen
Chosen 1 Love Mike~Sileck

instead of the nicely spaced out version I see on my screen.

Does anyone know any tricks so that I can put a table of our tags in that thread?

Thanks!
Reply
post #2 of 12
11/16/04 at 1:26pm
Thread Starter 
No feedback yet on how to do this (creating columns in our posts)?

Thanks.
Reply
post #3 of 12
11/16/04 at 8:21pm

TEST TABLE













1st gamertag 1st HTF name 1st set of notes
2nd gamertag 2nd HTF name 2nd set of notes
Reply
post #4 of 12
11/16/04 at 8:24pm
If the example that I posted above is anything close to what you're aiming for, I can post a link which will show you exactly how to achieve it.
Reply
post #5 of 12
11/16/04 at 8:52pm
Thread Starter 
That'll work, Linda, please do. Many thanks!
Reply
post #6 of 12
11/16/04 at 9:03pm
Here's the link:

http://www.w3schools.com/tags/tryit....=tryhtml_table

Play around with it, and you'll see how to make it do what you need. You can, literally, just cut and paste the code from the demo, and substitute your own info into the cells. Then, to post it in the forum, make sure your vB code is set to "Normal" mode.

Good luck!
Reply
post #7 of 12
11/18/04 at 10:23am
Thread Starter 
Linda, can you tell why the spacing on my table is so off? I can send you the code via email that I used if you need to look at that. I can't figure out why there's like 100 carriage returns between my text and the table I included. I've looked at the code and I can't find it.

Here is my messed up post...

My email is: cmedina@library.ucla.edu if you want to give me your email (it's blocked from this board).

Many thanks!
EDIT - Linda, never mind, I think I see the problem. The board software is putting < br > and < /br > around all my tables rows, and I can't take them out (they don't appear when I EDIT my post, only viewable when you go to the page and VIEW SOURCE via the browser, there they all are!). I've asked the admins to take a look...
Reply
post #8 of 12
11/18/04 at 7:51pm
Carlo...

Glad to see that my pointer worked out as far as helping you to format the info table.

As for the extra spaces (which you'll notice happened even in my example in this thread), variations on that problem have been going on for a good while now. Here's one discussion about it:

http://www.hometheaterforum.com/htfo...hreadid=208850

I'm not sure there is a way to "fix" it, but, at least you have the table the way you need it...
Reply
post #9 of 12
11/18/04 at 8:24pm
Actually, while it can't be "fixed", you can get around it.

Type in (or paste in) your text the way you want it in the post reply box.

Now highlight it all and copy it.

Submit.

Then edit your post, and highlight it all and paste in the correct version.

Submit.

For whatever reason the added nonsense doesn't show up on edited posts, only original posts (in certain threads).
Reply
post #10 of 12
11/18/04 at 9:38pm
Thread Starter 
Thanks for the recommendation George, unfortunately it doesn't work in this instance. I'm very familiar with the trick and tried it already, it didn't work.

It's really odd, the extra spacing is because of extra < br > and < /br > tags being put into posts, and when you edit your affected post you can usually see those tags (and hence when you paste it deletes those).

The weird thing with this one specific post is that those tags are embedding themselves within the table tags, yet when I edit, they are invisible. When I try the copy and paste trick, those tags still perpetuate themselves (you can see them when you view page source in your browser).

The really odd thing is that the br tags are within the table tags, but seem to take effect *above* the table (hence why there's like 40 carriage return spaces between the text of my post and the table.

Most puzzling.
Reply
post #11 of 12
11/18/04 at 9:48pm
Thread Starter 
WOO HOO!!! SUCCESS!!!

How's this for hardcore troubleshooting.

WITHIN the html table code itself were carriage returns (if you hit the "paragraph icon" in MS Word, it shows a carriage return as ^p). I went through and deleted all carriage returns in the table code, as well as extraneous spaces, so that the table HTML looked like a long, jumbled stream of characters, and it took away the < br > tags!

It is actually the act of having a carriage return that can trigger the forum software to inappropriately put < br > tags.

I feel productive tonight...
Reply
post #12 of 12
11/19/04 at 7:43am
Perseverance pays off...good detective work!
Reply
New Posts  All Forums:Forum Nav:
  Return Home
Home Theater Forum › Home Theater Forum › Feedback and Testing › Forum Help and Feedback › Feedback Archive (Closed Issues) › How do I put up a table or excel sheet so that spacing is preserved