Spreadsheets or tables in posts

[dickm]

Have been trying to compile a table of what jaws fit what lathe chuck, to post on the spinny bit. But I can't see how to incorporate a table into a posting.
Any hints?

 

[paultnl]

Test 1 a 1
Test 2 b 2
Test 3 c 3

I just cut and paint this from excel

 

[Eric The Viking]

It's a bit clunky, but you can screengrab from Excel and post it as a GIF or PNG (will look better than a JPEG):

(it's for helping me to set the saw table for the odd mitre angles of an octagonal bird table roof!).

Note it's a tiny file yet pretty crisp to look at.

It would be nicer still to be able to actually post spreadsheets!



E.

 

[gregmcateer]

Dick,

This is from excel, highlight required fields, copy, paste to word, then highlight and copy then paste to here;

a1 b1
a2 b2
a3 b3

ie the lines get lost.

I tried the same via MS Paint and lost the lines too.

I guess you have to ensure all lined up nicely, (ie justified for numbers) and hope it's clear on pasting - possibly colouring the lines / columns alternately may clarify for reading?

a1 b1
a2 b2
a3 b3

Hey, this is almost as much fun as playing on the lathe! (and warmer!!)

Cheers,

Greg

PS, I bet Blister and the Appleheads will have rinky-dink tool that works perfectly evertyime :lol:

 

[CHJ]

For correct formatting they need to be written and edited in PHP compliant code, not HTML.
This is not easy as most editors want to format the code for you and put in all sorts of unwanted spaces and html code etc.

Do a quote on this thread and you will see an example.
woodworking-show-dates-2010-t38294.html

I used to do my lists this way but now just do them in HTML and provide a link to my server as being much easier to edit.

Perhaps the easiest way is to save the screen shot as a gif as suggested by Eric.

 

[Chems]

written and edited in PHP compliant code, not HTML.
Do a quote on this thread and you will see an example.
woodworking-show-dates-2010-t38294.html

That not PHP thats HTML, inline html?

Heres how you do a table dick, its really easy if you just ignore the fact it looks mad!

A tr is a row (Table Row), and a td is a cell (Table Data).

You start by saying

[table]

to open the table, then you say

[tr]

to start a line. Put the content you want inside a

[td]Your Content[/td]

do that for as many columns as your having. Then when your ready to make a new row you close that row by saying

[/tr]

rinse and repeat this process for each row. When you are done close the table by saying

[/table]

So a 2x2 table would look like:

[table]
[tr]   [td]Cell a1[/td]    [td]Cell b1[/td]    [/tr]
[tr]   [td]Cell a2[/td]    [td]Cell b2[/td]    [/tr]
[/table]

Which would show as:

Cell a1	Cell b1
Cell a2	Cell b2

An image is good an easy, but html last for ever!

 

[CHJ]

Chems, I did say PHP compliant Most modern HTML editors will try and include css etc. which will come out as garbage.

Hand coding a large table and manually entering the content is not a quick job, especially if you need to return and ammend.

 

[Chems]

I think what you meant then was that it needs to be written as inline HTML so it will display.

 

[AndyT]

If you wanted to post a spreadsheet which could actually be used to do calculations, another option would be to link to a Google Document. Anyone with a Google account can create these, from scratch or from an existing spreadsheet, and you can choose to make the document entirely public if you want.

 

[dickm]

Thanks, Chems. I'll try that.
Guess I was hoping there was an easy "cut and paste" solution.
(one of the few downsides of retirement is losing instant access to a computer support person )

 

[Chems]

Ah there is of course, you can save your excel table as Webpage. It'll create some ugly html, and you can clean it up and then use find and replace to replace all the < for [ and all the > for ].

But quicker to write it yourself as to remove the ugly code will take longer than to just write it out.

 

[CHJ]

The nearest I found to WYSIWYG editing of large tables that could be used on the forum was the old MS Frontpage, once all html page headers etc. had been stripped it would generally leave the in-line code alone and not try to reformat it.
But even that had a habit of putting unwanted non breaking spaces in that had to be removed if you were not careful with the typing.
At the last forum software upgrade even that became less usable so I gave up.

Don't know what editor Neil uses, maybe he just uses a plain text editor, might be worth a PM to him.