How do you post a column aligned table of data ?

[ps56k]

For some other threads,
how do you post a column aligned table of data ?

ie -
1 2 3 4
11 22 33 44
111 222 333 444

[livesoft]

Like this:

For some other threads,
how do you post a column aligned table of data ?

ie -

Code: Select all

   1   2   3   4
  11  22  33  44
 111 222 333 444

Use the "Code" button and you will force a mono-spaced font within that section.

[ps56k]

tnx - I'll try that...

this is a test - using Firefox -
but the text on my typing screen is aligned, but the forum Preview it is not -
I must have a proportional font within the browser...

which means, I have to go back and forth between my "browser" image
and the resulting "Preview" image to get it all fudged to be aligned.

Code: Select all

Test      a    b    c    d
11         2    3    4    5
22       33  44   55  66

[CABob]

Requesting additional information or clarification. I get:

Code: Select all

     1       2            3       4
    11      22          33     44
  111     222        333   444

What am I missing?

[triceratop]

This topic is now in the Forum Issues and Administration forum.

[livesoft]

What am I missing?

You are not missing anything. You have too many space characters which take up space with a mono-spaced font.

[ps56k]

When I am typing - I'm guessing the screen area I'm typing into is actually using a proportional font, as everything is aligned -
Then using the CODE and the Preview - it is NOT aligned - since the mono-spaced chars are now different compared to the proportional spacing.

Code: Select all

this is totally aligned while typing prior to Preview - 

this is using spaces       
                                   a       b      c       d       e
                                aaa    bbb  ccc    ddd   eee

this is using tabs	
				aa	aa	aa	aa	aa
				bb	bb	bb	bb	bb
				cc	cc	cc	cc	cc   

[telemark]

What I do is type everything in another editor using a monospace font, then copy and paste into the browser. There are probably easier ways.

Edit to add: within a

Code: Select all

 section, of course.

[Epsilon Delta]

Also don't use tabs. It sometimes seems that tn two applications expand tabs exactly the same way.

Most text editors that support a fixed width font have an option to convert tabs to spaces.

[DSInvestor]

If you do not have an editor that uses monospaced font, use a different character for the spaces maybe a '.'

This way you can see how many "spaces" you have between your columns.

[ps56k]

What I do is type everything in another editor using a monospace font, then copy and paste into the browser.
There are probably easier ways..

But when you paste it into the browser window, doesn't it now become the "browser text" which is proportional -
I'll try - now is the time - Notepad with Courier - might work.. YES - THANKS -

Code: Select all

a    b    c    d
aa   bb   cc   dd
aaa  bbb  ccc  ddd

[#Cruncher]

(I noticed this old thread referenced here by LadyGeek.)

If you have columns of different size numbers in a spreadsheet, you can use the Excel RIGHT and TEXT functions to align them. For example, here is a table prepared from three columns of numbers in cells A2:C45. It was prepared with the following formula entered in cell D2 and then copied down:

Code: Select all

=RIGHT("   "&A2,3)&RIGHT("         "&TEXT(B2,"#0.0"),9)&RIGHT("            "&TEXT(C2,"#,###,##0"),11)

Code: Select all

Age  Divisor    Balance
 70     27.4  1,000,000
 71     26.5    963,504
 72     25.6    927,145
 73     24.7    890,928
 74     23.8    854,858
 75     22.9    818,940
 76     22.0    783,178
 77     21.2    747,579
 78     20.3    712,316
 79     19.5    677,227
 80     18.7    642,497
 81     17.9    608,139
 82     17.1    574,165
 83     16.3    540,588
 84     15.5    507,423
 85     14.8    474,686
 86     14.1    442,613
 87     13.4    411,222
 88     12.7    380,534
 89     12.0    350,570
 90     11.4    321,356
 91     10.8    293,167
 93      9.6    266,022
 94      9.1    238,311
 95      8.6    212,123
 96      8.1    187,458
 97      7.6    164,315
 98      7.1    142,694
 99      6.7    122,597
100      6.3    104,299
101      5.9     87,743
102      5.5     72,872
103      5.2     59,622
104      4.9     48,156
105      4.5     38,329
106      4.2     29,811
107      3.9     22,713
108      3.7     16,889
109      3.4     12,325
110      3.1      8,700
111      2.9      5,893
112      2.6      3,861
113      2.4      2,376
114      2.1      1,386

With only a few rows it's simpler to just copy/paste the cells from the spreadsheet into an editor (using a monospace font) and add spaces manually. But with many rows, using a formula is quicker.