Master Index of Archived Threads


Tables w/o coding

Willets Point Aug 31 2006 12:31 PM

What is the formula that Yancy taught us for converting spreadsheets into html tables?

Rockin' Doc Aug 31 2006 09:30 PM

Such a formula would be immensely helpful to me in compiling POTG Poll results and then converting them into tables. I owe a few beers (cyber for now), but hopefully real ones in the future, to anyone that can provide such valuable information.

Willets Point Aug 31 2006 09:46 PM

Yancy posted it once on the old board and it's presumably lost.

Yancy Street Gang Aug 31 2006 10:30 PM

Here's an example. You'd have to replace the { } with < > =CONCATENATE("{TR}{TD}",A4,"{/td} {TD align=right}",B4,"{/td} {TD align=right}",FIXED(C4,2),"{/td}{/tr}")

Willets Point Aug 31 2006 10:47 PM

Where do I put this?

Yancy Street Gang Sep 01 2006 10:15 AM

Create your table in a spreadsheet. And the end of each row add a formula similar to the one above. (It will depend on the number of columns and the formatting of each column.) In the row above your first row of table data, add a cell that has the {TABLE} html header tag, and a {/table} at the bottom. Paste all of the rows into a forum post, and you've got a table. You'll also have those annoying line feeds which will make the table appear far down on the page. I get around that by creating another formula column that concatenates all of the rows into one giant cell. Or, you can just delete the line feeds after you paste into the forum post.

Willets Point Oct 03 2006 06:59 PM

Bump.

cooby Oct 03 2006 08:38 PM

Bump? It's a five thread forum

Willets Point Oct 03 2006 08:41 PM

Yancy's archiving tool removes threads that have been inactive for a certain period of time. By bumping this thread I made it active today and thus was not removed when I did the archiving today. I want to keep this handy, even though I still haven't figured out how to make it work yet.

MFS62 Nov 02 2006 03:57 PM

If you create a spreadsheet in Excel, or a document in Word and save it as a html document, does the software automayically insert the formatting codes, so we can just cut and paste it to the board? Later